NTSB investigations, 1993
5 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\") = 1993
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") = 1993 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 SEA93LA190Accident · No injuriesLimited investigationFinal reportCessna 182L · Idaho Falls, IDThe encounter with unfavorable wind during landing roll and the pilot's failure to maintain directional control.NTSB FTW93LA194Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hondo, TXThe pilot's improper evaluation of the weather which led to the downwind takeoff. Factors were the windshift and the tailwind.NTSB FTW93LA182Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Ozona, TXThe pilot's failure to correctly compensate for wind conditions. A factor was the unexpected encounter with the crosswind.NTSB MIA93LA112Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · La Belle, FLThe pilot in commands failure to correct for wind conditions during landing rollout resulting in the aircraft flipping over during wind gust encounter.NTSB MIA93LA087Accident · No injuriesLimited investigationFinal reportCessna 402B · Opa-Locka, FLFailure of the pilot-in-command to perform weight and balance calculations, exceeding the gross weight of the airplane, and disregarding wind information provided by the tower controller.