NTSB investigations, 2001, GA
6 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.
Cases per year
| 1982 | 12 |
|---|---|
| 1983 | 10 |
| 1984 | 14 |
| 1985 | 12 |
| 1986 | 13 |
| 1987 | 4 |
| 1988 | 9 |
| 1989 | 10 |
| 1990 | 15 |
| 1991 | 7 |
| 1992 | 12 |
| 1993 | 5 |
| 1994 | 8 |
| 1995 | 4 |
| 1996 | 6 |
| 1997 | 3 |
| 1998 | 3 |
| 1999 | 4 |
| 2000 | 3 |
| 2001 | 6 |
| 2002 | 5 |
| 2003 | 4 |
| 2005 | 3 |
| 2006 | 5 |
| 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\") = 2001
AND c.\"eventStateOrRegion\" = 'GA' 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\" = 353)
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" = 'GA' 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" = 353) 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 ATL02LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Brunswick, GAThe pilot's improper inflight planning which resulted in fuel exhaustion, and subsequent loss of engine power. A factor was the none suitable terrain.NTSB MIA01LA222Accident · No injuriesLimited investigationFinal reportCirrus Design SR-22 · Mitchell, GAThe poor in-flight planning by the pilot-in-command resulting in the total loss of engine power due to fuel starvation.NTSB ATL01LA067Accident · No injuriesLimited investigationFinal reportCessna 172N · Colquitt, GAThe student pilot's failure to use the fuel selector valve properly which resulted in fuel starvation and the subsequent loss of engine power, and the pilot's improper flare during landing.NTSB ATL01LA045Accident · Serious injuriesLimited investigationFinal reportCessna 182 P · Kennesaw, GAThe loss of engine power for undetermined reasons. Conditions for carburetor icing were present at the time of the accident.NTSB MIA01LA085Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Whitesburg, GAThe improper emergency procedure performed by the pilot due to his electing to perform a run-on landing resulting in excessive airspeed at touchdown and subsequent roll-over following ground contact with grass. A contributing factor was the inadequate…NTSB ATL01LA033Accident · Minor injuriesLimited investigationFinal reportCessna 210M · Augusta, GAThe pilot's failure to properly preflight fuel required for the flight that resulted in fuel exhaustion and the lost of engine power.