NTSB investigations, 2002, AR
10 cases where the first occurrence was “Loss of engine power”.
Cases per year
| 1982 | 10 |
|---|---|
| 1983 | 3 |
| 1984 | 4 |
| 1985 | 6 |
| 1986 | 2 |
| 1987 | 6 |
| 1988 | 4 |
| 1989 | 1 |
| 1990 | 5 |
| 1991 | 6 |
| 1992 | 6 |
| 1993 | 6 |
| 1994 | 9 |
| 1995 | 11 |
| 1996 | 8 |
| 1997 | 4 |
| 1998 | 5 |
| 1999 | 5 |
| 2000 | 1 |
| 2001 | 5 |
| 2002 | 10 |
| 2003 | 8 |
| 2004 | 6 |
| 2005 | 6 |
| 2006 | 4 |
| 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\") = 2002
AND c.\"eventStateOrRegion\" = 'AR' 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\" = 350)
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" = 'AR' 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" = 350) 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 FTW03LA052Accident · No injuriesLimited investigationFinal reportShepherd Kolb Mark III · Norfork, ARThe loss of engine power due to fuel contamination. Contributing to the accident were the trees.NTSB FTW03LA050Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Weiner, ARThe loss of engine power due to a compressor stall for undetermined reasons. A contributing factor was the soft terrain.NTSB FTW03LA026Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Marshall, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW03LA023Accident · No injuriesLimited investigationFinal reportBeech A23 · Farmington, ARThe loss of engine power due to the failure of the mechanical fuel pump.NTSB FTW02LA183Accident · Serious injuriesLimited investigationFinal reportBeech V35A · Leslie, ARThe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW02LA168Accident · No injuriesLimited investigationFinal reportErcoupe ERCO-415-E · Conway, ARThe loss of engine power for undetermined reasons. Factors were the pilots necessity to avoid a power line during the emergency descent and the lack of suitable terrain for the forced landing.NTSB FTW02LA163Accident · Minor injuriesLimited investigationFinal reportPiper J-5 · Greers Ferry, ARThe loss of engine power for undetermined reasons. A factor was the probability of carburetor ice.NTSB FTW02LA161Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Aubrey, ARThe failure of a compressor turbine blade(s) for an undetermined reason.NTSB FTW02LA151Accident · 1 fatalLimited investigationFinal reportNolan RV-4 · Jonesboro, ARThe loss of engine power for an undetermined reason.NTSB FTW02LA137Accident · Serious injuriesLimited investigationFinal reportCessna 182G · Tuckerman, ARThe pilot's operation of the airplane with a known equipment deficiency, which resulted in fuel leakage and a loss of engine power due to fuel exhaustion. A contributing factors was the lack of suitable terrain for the forced landing.