NTSB investigations, TX
208 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
Open the mapLatest 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 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 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 ENG08IA002Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · Greenville, TXA total loss of engine power due to the No. 2 engine experiencing a release of its fan spinner through the fan cowl as a result of an unidentified object striking the spinner, separating it from the fan disk and causing the spinner to be ingested into the fan…NTSB DFW07CA098Accident · No injuriesData collectionFinal reportFlagg Kitfox IV · Centerville, TXThe loss of engine power due to the failure of the air induction ducting. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07LA078Accident · Serious injuriesLimited investigationFinal reportCessna T182T · Athens, TXThe loss of engine power as result of the failure of a mechanic to properly check the torque on the input and output fuel lines to the fuel transducer during the manufacturing process. A contributing factor was the lack of suitable terrain for the forced…NTSB DFW07LA027Accident · No injuriesLimited investigationFinal reportBell BH 206L-3 · Brownwood, TXThe fracture of the turbine-to-compressor coupling and subsequent overspeed failure of the first stage turbine wheel as result of the improper re-assembly of the engine by maintenance personnel. A contributing factor was the lack of suitable terrain for the…NTSB DFW06CA050Accident · No injuriesData collectionFinal reportCessna T210 · Midland, TXThe loss of engine power due to a connecting rod failure. Contributing factors were the dark night conditions and the lack of suitable terrain for the forced landing.NTSB DFW05CA238Accident · No injuriesData collectionFinal reportCessna A188B · Paris, TXThe loss of engine power due the failure of a connecting rod. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05IA222Incident · No injuriesIncident investigationFinal reportAir Tractor AT-401 · Winnie, TXThe loss of engine power due to the failure of the second-stage turbine wheel as a result of low cycle fatigue.NTSB DFW05LA009Accident · No injuriesLimited investigationFinal reportCessna 150L · Denton, TXThe loss of engine power due to the separation of the accessory drive gear bolts, and the failure of the starter-clutch assembly. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04LA238Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Sweeny, TXThe fracture failure of the left engine crankshaft for undetermined reasons.NTSB FTW04LA227Accident · No injuriesLimited investigationFinal reportGrumman 164B · East Bernard, TXThe loss of engine power as result of the failure of the number four cylinder. A factor was the lack of suitable terrain for the forced landing.NTSB FTW04LA042Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Clarendon, TXthe loss of engine power due the separation of the number six cylinder as a result of a fatigue failure from the loosening of the cylinder attachment hardware.NTSB FTW04LA027Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Sweetwater, TXthe loss of engine power due to a failure of the crankshaft bolt. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX03LA183Accident · Minor injuriesLimited investigationFinal reportBell 206B · Malone, TXa fuel starvation induced loss of engine power due to fuel contamination.NTSB FTW02LA108Accident · No injuriesLimited investigationFinal reportMooney M20F · Grapeland, TXThe loss of engine power due to the #2 connecting rod cap separating from the connecting rod. A contributing factor was the limited forward visibility due to oil on the windscreen.NTSB FTW02FA106Accident · 1 fatalField investigationFinal reportBeech D35 · Nacogdoches, TXThe failure of the engine driven fuel pump drive pin resulted in a total loss of engine power. Contributing factors were inadequate maintenance, the pilot's inadequate use of the manual auxillary fuel pump (wobble pump), and the night conditions.NTSB FTW02LA030Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Anton, TXThe total loss of engine power while maneuvering due to a cracked cylinder, which resulted in a forced landing. A factor was lack of suitable terrain for the forced landing.NTSB FTW01LA210Accident · No injuriesLimited investigationFinal reportCessna T188C · Aiken, TXthe application of silicon sealant to the crankcase mating surfaces by maintenance personnel, which resulted in improper torque on the bolts which mate the crankcase halves, vibration, and the subsequent failure of the #2 main crankshaft bearing. A factor was…NTSB FTW01LA208Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Waco, TXthe mechanic's failure to perform an airworthiness directive, which resulted in the loss of engine oil through a partially failed oil filter converter plate gasket, and subsequent engine failure during takeoff climb. A contributing factor was the lack of…NTSB FTW01LA156Accident · Minor injuriesLimited investigationFinal reportRockwell International S-2R · Sabinal, TXa loss of engine power due to a crack in the #9 cylinder, which result in the failure of the connecting rod during the aerial application flight. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW01LA131Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Georgetown, TXthe pilot's failure to refuel the aircraft resulting in fuel exhaustion during cruise flight. A contributing factor was the gusty wind encountered during the forced landing.NTSB FTW01FA111Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-40 · The Woodlands, TXThe pilot's failure to maintain airplane control following a loss of right engine power, which resulted in impact with terrain in an uncontrolled descent. A contributing factor was the loss of right engine power as a result of the fatigue failure of the…NTSB FTW01LA085Accident · No injuriesLimited investigationFinal reportCessna 172RG · Waco, TXthe failure of the number four cylinder exhaust valve which resulted in a total loss of engine power during cruise. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW01LA072Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Brenham, TXthe in-flight separation of the throttle linkage, which resulted in the loss of engine power.NTSB FTW01LA068Accident · Serious injuriesLimited investigationFinal reportPiper PA32-R-301T · Haslet, TXthe improper installation of the oil filter bypass valve by an unknown person, which resulted in the loss of engine oil and subsequent loss of total power during a normal descent. A contributing factor to the accident was the lack of suitable terrain for the…NTSB FTW01LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Lancaster, TXmaintenance personnel's improper installation of the throttle lever lock nut. A contributory factor was the lack of suitable terrain for the forced landing.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.NTSB FTW00FA046Accident · 1 fatalField investigationFinal reportGlobe GC-1B · Edgewood, TXthe pilot's failure to maintain aircraft control during a forced landing which resulted in a stall/spin. Contributing factors were the failure of the engine driven fuel pump, the engine manufacturer's use of an inadequate fuel pump which was only intended for…NTSB FTW99LA227Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Rockwall, TXThe mechanic's improper machining of the crankshaft during a major overhaul, which resulted in a fatigue crack and subsequent failure of the crankshaft. A factor was the lack of suitable terrain for the forced landing.NTSB FTW99LA128Accident · Serious injuriesLimited investigationFinal reportLuscombe 8E · Conroe, TXThe loss of engine power due to fuel starvation as a result of a blocked fuel vent. A factor was the lack of suitable terrain for the forced landing.NTSB FTW99LA088Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Denton, TXThe total loss of engine power on takeoff resulting from the failure of an incorrect throttle control cable clamp, which was installed by an unknown person. A factor was the lack of suitable terrain for the forced landing.NTSB FTW98FA307Accident · Serious injuriesField investigationFinal reportCessna 172N · Lincoln, TXThe #3 cylinder exhaust valve rocker arm fulcrum retaining stud backing out of its stud-tapped hole due to the improper tapping of the stud hole by unknown maintenance personnel. Contributing factors were the transmission wire, sign and gasoline pump.NTSB FTW98LA302Accident · No injuriesLimited investigationFinal reportKeith Team Mini MAX 1600R · Santa Fe, TXThe loss of engine power as result of the failure of the cooling fan belt. A factor was the lack of suitable terrain for the pilot to execute the forced landing.NTSB FTW98FA216Accident · 3 fatalField investigationFinal reportBeagle B-206 · Vernon, TXThe pilot's failure to maintain the airplane's minimum controllable airspeed following a loss of left engine power after takeoff, which resulted in a loss of control. Contributing factors were the fractured exhaust valve guide on the left engine's # 2…NTSB FTW98FA092Accident · 2 fatalField investigationFinal reportAero Commander 500-B · Ennis, TXfailure of the flight crew to maintain minimum control speed (Vmc) during go-around from a single-engine approach, which resulted in loss of control and collision with power lines and the ground. Related factors were: a ruptured diaphragm in the distributor…NTSB FTW98LA062Accident · Minor injuriesLimited investigationFinal reportCessna 175A · Houston, TXThe total loss of engine power resulting from detonation and the ensuing failure of the engine piston and connecting rod components. Factors were: the instructor's decision to take off with a known deficiency (magneto drop over limit), the flight instructor's…