NTSB investigations, 2000, TX
14 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\") = 2000
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") = 2000 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 FTW01LA028Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Valley Spring, TXthe loss of engine power due to fuel exhaustion after the pilot became lost during cruise flight. A contributing factor was the dark night condition.NTSB FTW01LA002Accident · Serious injuriesLimited investigationFinal reportCessna 401A · Andrews, TXThe hard landing due to the pilot's excessive rate of descent. A factor was the loss of engine power due to fuel starvation as a result of the pilot's improper positioning of the fuel selectors.NTSB FTW01FA007Accident · 1 fatalField investigationFinal reportPiper PA-23-160 · Cotulla, TXThe pilot's failure to refuel the airplane which resulted in fuel exhaustion and subsequent loss of engine power. Also contributing to the accident was the pilot's failure to feather the engine.NTSB FTW00LA272Accident · Serious injuriesLimited investigationFinal reportPorterfield LP65 · Corsicana, TXThe failure of the pilot to refuel the airplane, which resulted in fuel exhaustion. A factor was the pilot's inadequate preflight planning and the lack of suitable terrain for the forced landing.NTSB FTW00LA237Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Ennis, TXThe loss of engine power due to fuel starvation, which resulted from the pilot's improper fuel selector positioning.NTSB FTW00LA204Accident · No injuriesLimited investigationFinal reportCessna 402A · Del City, TXthe total loss of engine power on both engines during cruise due to fuel starvation as a result of the pilot's improper use of the fuel selectors. Contributing factors were the pilot's lack of familiarity with the aircraft, and the lack of suitable terrain…NTSB FTW00LA198Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Leonard, TXThe inadvertent stall. A factor was the improperly positioned fuel selector.NTSB FTW00LA188Accident · No injuriesLimited investigationFinal reportCessna 172N · San Antonio, TXThe flight instructor's failure to refuel the airplane, which resulted in fuel exhaustion. Contributing factors were the flight instructor's fatigued condition and diverted attention.NTSB FTW00LA186Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Hondo, TXThe fuel exhaustion due to the pilot's failure to refuel the airplane. A factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA202Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Sugar Land, TXThe pilot's improper fuel tank selection, which resulted in fuel starvation. A factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA170Accident · No injuriesLimited investigationFinal reportAero Commander 700 · Breckenridge, TXFuel exhaustion as a result of an inaccurate fuel quantity indicating system. A factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA119Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Lubbock, TXThe pilot's incorrect positioning of the fuel selector which resulted in fuel starvation. Factors were the pilot's lack of familiarity with the fuel system due to an inadequate checkout by a flight instructor, and the lack of suitable terrain for the forced…NTSB FTW00LA082Accident · Minor injuriesLimited investigationFinal reportBeech BE-35K · Houston, TXThe pilot's failure to refuel resulting in fuel exhaustion and a total loss of engine power. Factors were the low ceilings, mist, and the pilot's inability to fly the ILS approach.NTSB FTW00LA071Accident · No injuriesLimited investigationFinal reportCessna 152 · Slidell, TXThe pilot's improper approach planning, which resulted in a downwind landing. A factor was the loss of engine power for undetermined reasons.