NTSB investigations, 2001, TX
12 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.
Cases per year
| 1982 | 27 |
|---|---|
| 1983 | 20 |
| 1984 | 30 |
| 1985 | 35 |
| 1986 | 21 |
| 1987 | 29 |
| 1988 | 20 |
| 1989 | 28 |
| 1990 | 22 |
| 1991 | 14 |
| 1992 | 19 |
| 1993 | 20 |
| 1994 | 16 |
| 1995 | 18 |
| 1996 | 16 |
| 1997 | 19 |
| 1998 | 10 |
| 1999 | 15 |
| 2000 | 14 |
| 2001 | 12 |
| 2002 | 8 |
| 2003 | 4 |
| 2004 | 11 |
| 2005 | 11 |
| 2006 | 8 |
| 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\" = 'TX' 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" = 'TX' 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 FTW02LA029Accident · No injuriesLimited investigationFinal reportLandoll Vans RV 3-A · Denton, TXthe pilot's failure to perform a preflight inspection, which resulted in a loss of total engine power due to oil starvation. A contributing factor was the lack of suitable training for the forced landing.NTSB FTW02LA018Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Ozona, TXThe loss of engine power due to fuel exhaustion resulting from the pilot's failure to refuel the airplane. Contributing factors were the lack of suitable terrain for the forced landing and the dark night conditions.NTSB FTW02LA008Accident · Serious injuriesLimited investigationFinal reportBeech C90 · Dallas, TXthe pilot's failure to refuel the airplane, which resulted in fuel exhaustion and subsequent loss of dual engine power while on approach.NTSB FTW02LA006Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS355F1 · Rosebud, TXThe pilots impairment due to drugs. Contributing factors were the dark night light conditions, the pilot's failure to refuel, resulting in the total loss of engine power due to fuel exhaustion, and the pilot's misjudged landing flare.NTSB FTW01LA184Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Fabens, TXthe pilot's inadequate preflight resulting in loss of engine power due to fuel exhaustion. A contributing factor was the power line.NTSB FTW01LA166Accident · Serious injuriesLimited investigationFinal reportEurocopter BK117-C1 · Decatur, TXthe pilot's failure to follow the checklist and turn on the fuel transfer pumps, which resulted in fuel starvation and a dual loss of engine power while in cruise flight.NTSB FTW01LA162Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Caldwell, TXthe solo student pilot's intentional engine shutdown, while practicing emergency landing prodecures. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW01LA150Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Winnsboro, TXthe loss of engine power during takeoff climb for undetermined reasons. A contributing factor was the lack of suitable terrain for the ensuing forced landing.NTSB FTW01LA112Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Marfa, TXfuel exhaustion resulting in a total loss of engine power in cruise flight due to the pilot's failure to refuel the aircraft. Contributing factors were the lack of suitable terrain for the forced landing, and the dark night condition.NTSB FTW01LA099Accident · No injuriesLimited investigationFinal reportCessna 150L · Iowa Park, TXfuel exhaustion during takeoff due to the pilot's failure to refuel.NTSB FTW01LA094Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Pearland, TXthe pilot's failure to refuel the airplane, which resulted in fuel exhaustion while in the traffic pattern.NTSB FTW01LA096Accident · No injuriesLimited investigationFinal reportCessna T210M · Abilene, TXthe loss of engine power while on final approach due to fuel starvation as a result of the pilot's improper use of the fuel selector. A contributing factor was the elevated runway edge.