NTSB investigations, 1992
10 cases where the first occurrence was “On ground/water encounter with weather”.
Cases per year
| 1982 | 7 |
|---|---|
| 1983 | 7 |
| 1984 | 7 |
| 1985 | 16 |
| 1986 | 22 |
| 1987 | 21 |
| 1988 | 10 |
| 1989 | 14 |
| 1990 | 17 |
| 1991 | 15 |
| 1992 | 10 |
| 1993 | 5 |
| 1994 | 6 |
| 1995 | 3 |
| 1996 | 7 |
| 1997 | 6 |
| 1998 | 6 |
| 1999 | 15 |
| 2000 | 12 |
| 2001 | 7 |
| 2002 | 9 |
| 2004 | 6 |
| 2005 | 3 |
| 2006 | 5 |
| 2007 | 8 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
WHERE year(c.\"eventDate\") = 1992
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 330)
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE year(c."eventDate") = 1992 AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 330) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB ATL93FA004Accident · 1 fatalField investigationFinal reportAero Commander 680 · Headland, ALThe pilot's failure to maintain control of the airplane while conducting a high speed taxi maneuver which resulted in inadvertent flight. Factors were the pilot's over confidence in his ability, his lack of familiarity with the airplane and the wind gust.NTSB NYC92LA176Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Coatesville, PAThe pilot's decision to continue the approach and eventual touching down off the runway which resulted in a loss of control of the airplane and collapsing the landing gear. A factor in this accident was the pilot's loss of visual perception and fog.NTSB BFO92LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Dayton, OHAn encounter with a strong wind gust which resulted in loss of control and nose over.NTSB LAX92LA158Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Douglas, AZAn encounter with an unforecasted high velocity wind gust which caused the airplane to nose over to an inverted position.NTSB ATL92LA058Accident · No injuriesLimited investigationFinal reportPiper PA-46-310 · Aiken, SCThe unexpected, gusting crosswind.NTSB MIA92LA092Accident · No injuriesLimited investigationFinal reportCessna 170A · Miami, FLFailure of the pilot in command to maintain directional control. Contributing to the accident was the unfavorable wind (windshift).NTSB SEA92LA054Accident · Serious injuriesLimited investigationFinal reportMichael Conner Avid Flyer · Nampa, IDThe pilot's inadequate weather evaluation. A factor in the accident was the unfavorable wind.NTSB ATL92LA046Accident · No injuriesLimited investigationFinal reportCessna 172 · Leesburg, FLThe unfavorable wind conditions encountered by the flight during taxi.NTSB NYC92LA058Accident · No injuriesLimited investigationFinal reportPiper PA60-700P · Wooster, OHThe pilot allowed the airspeed to decay, delayed the go-around, and prematurely rotated the airplane which resulted in the airplane over running the runway. Factor in the accident were the pilot inadequately planned the approach; freezing drizzle and runway…NTSB ANC92IA030Incident · No injuriesIncident investigationFinal reportPiper PA-31-T3 · Anchorage, AKThe pilot's continued taxi after becoming lost or disoriented. Factors relating to the accident were the whiteout conditions caused by the freshly falling and blowing snow and the inadequate snow removal by airport personnel.