NTSB investigations, 2000, TX
16 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.
Cases per year
| 1982 | 14 |
|---|---|
| 1983 | 15 |
| 1984 | 10 |
| 1985 | 17 |
| 1986 | 6 |
| 1987 | 10 |
| 1988 | 10 |
| 1989 | 5 |
| 1990 | 12 |
| 1991 | 10 |
| 1992 | 5 |
| 1993 | 7 |
| 1994 | 5 |
| 1995 | 15 |
| 1996 | 10 |
| 1997 | 8 |
| 1998 | 4 |
| 1999 | 4 |
| 2000 | 16 |
| 2001 | 10 |
| 2002 | 2 |
| 2003 | 3 |
| 2004 | 3 |
| 2005 | 2 |
| 2006 | 2 |
| 2007 | 3 |
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\" = 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") = 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" = 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 FTW01LA036Accident · No injuriesLimited investigationFinal reportBell 206B · Rockport, TXthe loss of engine power during cruise flight due to the fatigue fracture of the compressor coupling adapter. A contributing factor was the high sea condition existing for the forced landing.NTSB FTW01LA026Accident · Minor injuriesLimited investigationFinal reportPiper PA-46-310P · Gainesville, TXthe loss of engine power due to improper splicing of the TIT thermocouple leads by unknown persons, which led to over temperature operation of the engine due to inaccurate TIT gauge readings. Contributing factors were the manufacturer's stamp on the top of…NTSB FTW01LA016Accident · Serious injuriesLimited investigationFinal reportSteven R. Jackson Harmon Rocket 2 · Houston, TXThe collapsing of the inner liner of the induction air hose, resulting in a restriction of airflow to the engine and subsequent loss of engine power. A factor was the lack of suitable terrain for the forced landing.NTSB FTW01LA009Accident · Minor injuriesLimited investigationFinal reportBellanca BL17-30 · Waller, TXthe loss of engine power during climb to cruise due to the failure of the crankshaft counterweight. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA256Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Saspamco, TXthe failure of the #3 and #4 connecting rods. A contributing factor was the lack of suitable terrain condition for the forced landing.NTSB FTW00FA245Accident · 1 fatalField investigationFinal reportCessna 421C · Hunt, TXthe loss of left engine power as a result of the owner's failure to overhaul the engine before further flight after the lubrication system was found contaminated with metal. Contributing factors were the pilot's decision to fly the aircraft with a…NTSB FTW00LA207Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Columbus, TXthe failure of both magnetos of the dual-magneto single-drive unit. A factor contributing to the accident was the lack of suitable terrain for the forced landing.NTSB FTW00LA200Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164B · Moscow, TXthe failure of the power output reduction gear to the propeller. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA168Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Garwood, TXthe loss of engine power in cruise flight as a result of the failure of the right magneto. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA159Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Garwood, TXThe failure of the supercharger seal resulting in the loss of engine power. A factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA127Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Tomball, TXEngine seizure due to the rupture of an oil cooler line.NTSB FTW00FA080Accident · 1 fatalField investigationFinal reportBeech B23 · New Braunfels, TXthe seizure of the engine while maneuvering due to the oil pressure relief valve plug ball seat becoming contaminated with metal. Contributing factors were the inadequate engine maintenance, and the lack of suitable terrain for the forced landing.NTSB FTW00LA068Accident · No injuriesLimited investigationFinal reportMooney M20K · Tyler, TXThe failure of the crankshaft drive gear as a result of fatigue, which resulted in a forced landing. A factor was the lack of suitable terrain for the forced landing.NTSB FTW00TA065Accident · No injuriesFinal reportCessna 150F · Livingston, TXThe total loss of engine power resulting from an exhaust valve failure. A factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA061Accident · No injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Sherman, TXA jammed carburetor needle which resulted in fuel starvation and the subsequent hard forced landing after takeoff. Contributing factors were the fence, trees, and pilot's maneuver to avoid these objects.NTSB FTW00LA057Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Odessa, TXThe separation of the #1 piston pin due to fatigue, which resulted in a total loss of engine power. A factor was the lack of suitable terrain for the forced landing.