NTSB investigations, 2001, FL
3 cases where the first occurrence was “In flight encounter with weather”.
Cases per year
| 1982 | 6 |
|---|---|
| 1983 | 9 |
| 1984 | 8 |
| 1985 | 7 |
| 1986 | 4 |
| 1987 | 9 |
| 1988 | 8 |
| 1989 | 7 |
| 1990 | 6 |
| 1991 | 14 |
| 1992 | 13 |
| 1993 | 6 |
| 1994 | 5 |
| 1995 | 9 |
| 1996 | 3 |
| 1997 | 9 |
| 1998 | 6 |
| 1999 | 5 |
| 2000 | 3 |
| 2001 | 3 |
| 2002 | 8 |
| 2003 | 8 |
| 2004 | 7 |
| 2005 | 9 |
| 2006 | 6 |
| 2007 | 2 |
Where
Latest 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\") = 2001
AND c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
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\" = 240)
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") = 2001 AND c."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA' 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" = 240) 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 MIA02GA011Accident · 2 fatalFinal reportBell OH-58A · Bartow, FLThe pilot's continued VFR flight into IMC, and his failure to maintain altitude, resulting in an in-flight collision with the ground. Factors in this accident were fog, and dark night.NTSB MIA01LA217Accident · No injuriesLimited investigationFinal reportCessna 152 · Summerfield, FLThe poor in-flight planning decision by the student pilot for his failure to turn around to avoid low ceilings resulting in a precautionary landing in a field. A contributing factor in the accident was the pilot's lack of total experience. A finding in the…NTSB ATL01LA049Accident · Serious injuriesLimited investigationFinal reportBoeing 737-200 · Jacksonville, FLThe flight dispatcher failure to provide the flight crew with current in-flight turbulence information that resulted in the in-flight encounter with turbulence during climb. A factor was the pilots failure to obtain adequate weather information.