NTSB investigations, 2002, FL
5 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.
Cases per year
| 1982 | 9 |
|---|---|
| 1983 | 15 |
| 1984 | 8 |
| 1985 | 15 |
| 1986 | 17 |
| 1987 | 9 |
| 1988 | 11 |
| 1989 | 11 |
| 1990 | 10 |
| 1991 | 6 |
| 1992 | 6 |
| 1993 | 6 |
| 1994 | 6 |
| 1995 | 13 |
| 1996 | 8 |
| 1997 | 9 |
| 1998 | 6 |
| 1999 | 5 |
| 2000 | 2 |
| 2001 | 4 |
| 2002 | 5 |
| 2003 | 9 |
| 2004 | 4 |
| 2005 | 7 |
| 2006 | 5 |
| 2007 | 7 |
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\" = '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\" = 351)
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" = '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" = 351) 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 ATL02FA175Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Milton, FLA sheared mixture cable which resulted in a loss of engine power.NTSB MIA02FA131Accident · 2 fatalField investigationFinal reportAmerican General AA-5 · Boca Raton, FLThe owner/operator's failure to perform an overhaul or comply with a service bulletin 240 which would have probably precluded the continued installation of the number four cylinder exhaust valve and its subsequent failure.NTSB MIA02LA121Accident · Minor injuriesLimited investigationFinal reportKenneth Parmerter Loehle 5151 Mustang · Lake Placid, FLThe pilot's failure to maintain airspeed and his inflight loss of control while maneuvering to land following an engine failure. Contributing to the accident was the builder/owner's improper engine installation that resulted in engine overheating and ceasing…NTSB MIA02FA100Accident · No injuriesField investigationFinal reportBell 206L-1 · Fort Lauderdale, FLThe excessive rate of descent by the pilot-in-command during the autorotative landing resulting in a hard landing, following a total loss of engine power caused by failure of the No. 4 bearing.NTSB ATL02LA052Accident · No injuriesLimited investigationFinal reportCessna 152 · Hudson, FLTotal loss of engine power due to oil starvation to the No. 3 connecting rod preceded by aft displacement of the center main bearing due to excessive wear. This resulted in a forced landing to none suitable terrain and subsequent on-ground collision with a…