NTSB investigations, 2002, AL
7 cases where the first occurrence was “Loss of control - in flight”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 3 |
| 1984 | 7 |
| 1985 | 3 |
| 1986 | 4 |
| 1987 | 3 |
| 1988 | 4 |
| 1989 | 5 |
| 1990 | 6 |
| 1991 | 6 |
| 1992 | 9 |
| 1993 | 6 |
| 1994 | 3 |
| 1995 | 5 |
| 1996 | 4 |
| 1997 | 3 |
| 1998 | 3 |
| 1999 | 2 |
| 2000 | 3 |
| 2001 | 3 |
| 2002 | 7 |
| 2003 | 4 |
| 2004 | 5 |
| 2005 | 3 |
| 2006 | 3 |
| 2007 | 4 |
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\") = 2002
AND c.\"eventStateOrRegion\" = 'AL' 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\" = 250)
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") = 2002 AND c."eventStateOrRegion" = 'AL' 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" = 250) 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 ATL03FA008Accident · 1 fatalField investigationFinal reportCessna 208B · Spanish Fort, ALthe pilot's spatial disorientation, which resulted in loss of airplane control. Contributing to the accident was the night instrument meteorological conditions with variable cloud layers.NTSB MIA03LA002Accident · 2 fatalLimited investigationFinal reportGolden RV6A · Tuskegee, ALthe failure of the pilot to maintain airspeed, which resulted in an inadvertent stall/spin, and subsequent impact with the terrain.NTSB ATL02FA143Accident · 2 fatalField investigationFinal reportCessna 150G · Duncanville, ALThe pilot's failure to maintain airspeed , which resulted in an inadvertent stall, and subsequent collision with the ground. A contributing factor was low level flight.NTSB ATL02LA115Accident · Serious injuriesLimited investigationFinal reportFrank Fitzgerald Team Z Max · Huntsville, ALThe pilot's failure to maintain airspeed during a take off climb resulting in a loss of control (inadvertent stall) and the subsequent in-flight collision with terrain. A factor was the lack of total experience in type of aircraft.NTSB ATL02LA093Accident · No injuriesLimited investigationFinal reportCessna 150B · Enterprise, ALThe pilot's failure to maintain airspeed during an attempted go-around that resulted in an inadvertent stall and the subsequent collision with the ground.NTSB MIA02LA071Accident · No injuriesLimited investigationFinal reportBeech C-24R · Bayou La Batre, ALThe pilot's failure to maintain aircraft directional control while executing a go-around, resulting in an inflight collision with trees.NTSB ATL02LA061Accident · 1 fatalLimited investigationFinal reportMoore Sammie M-Breezy · Pell City, ALThe pilot's failure to maintain flying speed, followed by an inadvertent stall spin, and subsequent collision with terrain.