NTSB investigations, TX
110 cases where the first occurrence was “Loss of engine power(partial) - mech failure/malf”.
Cases per year
| 1982 | 5 |
|---|---|
| 1983 | 4 |
| 1984 | 9 |
| 1985 | 6 |
| 1986 | 6 |
| 1987 | 3 |
| 1988 | 5 |
| 1989 | 7 |
| 1990 | 7 |
| 1991 | 3 |
| 1992 | 4 |
| 1993 | 9 |
| 1994 | 4 |
| 1995 | 5 |
| 1996 | 2 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 3 |
| 2000 | 7 |
| 2001 | 2 |
| 2002 | 2 |
| 2003 | 2 |
| 2004 | 5 |
| 2005 | 2 |
| 2006 | 3 |
| 2007 | 2 |
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\" = 352)
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" = 352) 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 DFW07LA165Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Slaton, TXAn uncontained failure of the turbine engine's power section for undetermined reasons.NTSB DFW07CA126Accident · Minor injuriesData collectionFinal reportGray Jack Tean Rocket F1 · Seabrook, TXThe loss of engine power for undetermined reason. A contributing factor was the lack of suitable terrain for the precautionary landing.NTSB DFW06CA217Accident · No injuriesData collectionFinal reportBrantly Helicopter B-2B · Carrizo Springs, TXThe loss of engine power due to a malfunction of the electric fuel pump. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06LA172Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Midland, TXThe partial loss of engine power as result of the maintenance personnel's failure to comply with a manufacture's Service Bulletin (SB). A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06IA171Incident · No injuriesIncident investigationFinal reportMooney M20J · Beaumont, TXThe improper installation of the propeller governor by maintenance personnel, which resulted in a partial loss of engine power and subsequent forced landing. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06CA008Accident · Minor injuriesData collectionFinal reportCessna 172P · Hitchcock, TXA loss of engine power due to a cracked cylinder.NTSB DFW05CA225Accident · No injuriesData collectionFinal reportAyres S2R-T15 · Taylor, TXThe pilot's misjudgement while landing resulting in an overrun. A factor was fluctuating engine power.NTSB DFW05CA021Accident · No injuriesData collectionFinal reportBellanca BL-17-30A · Roanoke, TXThe disconnection of the engine mixture control cable due to improper maintenance which resulted in a loss of engine power.NTSB DCA04IA066Incident · No injuriesIncident investigationFinal reportBoeing B-777 · Houston, TXthe failure of a high pressure turbine blade which damaged an oil seal and allowed smoke to enter the cabin. Contributing to the blade failure was the mis-labeling of the blade's part number by the manufacturer, which allowed the blade to remain in service…NTSB FTW04LA131Accident · No injuriesLimited investigationFinal reportCooke Rotorway Exec · Willis, TXThe partial loss of engine power due to the failure of the #1 cylinder valve retainer clip. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04LA109Accident · No injuriesLimited investigationFinal reportSpannagel RV-8A · Borger, TXA partial loss of engine power as a result of inadequate clearance between the journals and bearings.NTSB FTW04LA059Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Fort Worth, TXThe pilot's failure to maintain control and the partial loss of engine power as a result of an improperly installed mixture control linkage.NTSB FTW03LA188Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Kerrville, TXThe loss of engine power due to the failure of the number three cylinder as the result of undertorqued cylinder bolts. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW03FA118Accident · 2 fatalField investigationFinal reportBell 407 · Broadus, TXThe partial loss of engine power due to erratic fuel flow metering to the engine resulting from the single point failure of the PLA potentiometer in the hydro-mechanical fuel control unit. A contributing factor was the lack of suitable terrain to execute a…NTSB FTW03LA066Accident · No injuriesLimited investigationFinal reportHughes 369E · Fritch, TXThe loss of engine power due to the failure of the generator input drive-end bearing, which resulted in excessive vibrations that induced a fatigue fracture of the Pc line leading to the engine fuel control unit. A contributing factor was the lack of suitable…NTSB FTW02LA174Accident · No injuriesLimited investigationFinal reportCessna 150 · Fort Worth, TXthe partial loss of engine power due to the mixture control rod separating from the carburetor. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW02IA027Incident · No injuriesIncident investigationFinal reportAirbus Industrie A319-132 · Midland, TXthe #1 engine's fatigue failure of the #3 bearing due to the manufacturer's inadequate design of the high-pressure compressor stubshaft coating, which resulted in a loss of engine power and an emergency landing.NTSB FTW01LA047Accident · Serious injuriesLimited investigationFinal reportNord 1101 · McKinney, TXthe loss of engine power during takeoff resulting from the inadequate engagement of the throttle torque tube rod end into the support bushing by unknown maintenance personnel.NTSB FTW00LA190Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Whitney, TXThe partial loss of engine power, which resulted from the worn carburetor.NTSB FTW00LA175Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Nacogdoches, TXthe loss of engine power during a go-around resulting from the failure of the worn carburetor heat control cable. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA160Accident · Minor injuriesLimited investigationFinal reportCessna 195 · Kaufman, TXThe failure of the left magneto, which resulted in a partial loss of engine power. Factors were the fouled number 3, 4, and 5 rear spark plugs and the lack of suitable terrain for the precautionary landing.NTSB FTW00TA116Accident · Minor injuriesFinal reportHughes OH-6A · El Paso, TXThe failure of the pilot to maintain rotor rpm during an autorotation, which resulted in a hard landing. A factor was the partial loss of engine power resulting from the separation of the power control line due to fatigue, as a consequence of improper…NTSB FTW00LA108Accident · Minor injuriesLimited investigationFinal reportNorth American T-28B · Bridgeport, TXThe partial loss of engine power for an undetermined reason.NTSB FTW00LA098Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Garwood, TXThe failure of the left magneto, which resulted in the partial loss of engine power during takeoff.NTSB FTW00LA058Accident · No injuriesLimited investigationFinal reportCessna A185F · Houston, TXthe loss of engine power during climb as a result of fatigue cracking of the #4 cylinder head and its subsequent separation from its barrel.NTSB FTW99LA241Accident · Minor injuriesLimited investigationFinal reportCessna 414 · Alpine, TXThe pilot's improper use of the emergency fuel boost pump, which resulted in excessive fuel flow to the engine and subsequent total loss of left engine power. Factor's were the high density altitude, the pilot exceeding the airplane's weight and balance, the…NTSB FTW99LA168Accident · No injuriesLimited investigationFinal reportCessna T188C · Panhandle, TXThe partial loss of engine power as a result of the low compression in the number 5 cylinder. A factor was the lack of suitable terrain for the forced landing.NTSB FTW99LA085Accident · Minor injuriesLimited investigationFinal reportEurocopter Colibri EC120B · Springtown, TXThe improper touchdown executed by the pilot. Factors were the tail wind condition, and the manufacturer's inadequate design of the P3 pipe supports, which resulted in a fatigue fracture of the P3 pipe.NTSB FTW99LA036Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Greenville, TXThe partial loss of engine power due to a blocked muffler exhaust pipe/manifold as a result of a loose internal baffle. Factors were the improper maintenance by other maintenance personnel and the lack of suitable terrain for the forced landing.NTSB FTW97LA258Accident · Serious injuriesLimited investigationFinal reportAero Commander 500-B · Dallas, TXThe pilot-in-command's failure to follow emergency procedures to reduce drag and maintain best climb airspeed. Factors were the partial loss of engine power due to the cracks in the #1 and #4 cylinders as the result of an unapproved modification of their…NTSB FTW97LA086Accident · Serious injuriesLimited investigationFinal reportMahan Starduster II · Atlanta, TXimproper maintenance by unknown person(s), which resulted in the failure of the throttle cable and a substantial loss of engine power. A factor relating to the accident was: the lack of suitable terrain for the forced landing.NTSB FTW96LA343Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Midlothian, TXmaintenance personnel's improper engine overhaul procedures resulting in the installation of the rocker arms in reversed positions, which led to improper lubrication and binding of the exhaust valves. A related factor was the lack of suitable terrain for the…NTSB FTW96LA134Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Austin, TXthe partial loss of engine power due to the failure of the #3 connecting rod. A factor was the lack of suitable terrain for the forced landing.NTSB FTW96LA078Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Kaufman, TXThe loss of engine power due to a bent push rod and the resultant loss of oil. Factors were the cockpit smoke and the lack of suitable terrain for the forced landing.NTSB FTW96LA077Accident · Minor injuriesLimited investigationFinal reportStinson ST-108-2 · Lake Dallas, TXthe failure of the #6 connecting rod assembly. A factor was the lack of suitable terrain for a forced landing which resulted in a water landing.NTSB FTW95FA270Accident · Serious injuriesField investigationFinal reportChampion 7ECA · Lake Dallas, TXThe pilot's failure to maintain airspeed and the resulting inadvertent stall/spin. A factor was inadequate maintenance resulting in the partial loss of engine power due to the number one cylinder exhaust valve being stuck open.NTSB FTW95LA211Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Lissie, TXThe partial loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB FTW95LA161Accident · Minor injuriesLimited investigationFinal reportGardner Varieze · Addison, TXThe jammed throttle. Factors were the knob becoming loose and separating from the throttle lever, and the lack of suitable terrain available for the forced landing.NTSB FTW94FA282Accident · Minor injuriesField investigationFinal reportCessna 402 · Harlingen, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall. Factors were a partial loss of power on all engines due to worn and fouled spark plugs and inadequate maintenance by company maintenance personnel, aircraft weight beyond limitations,…NTSB FTW94GA204Accident · Minor injuriesFinal reportHughes 269C · London, TXThe partial power loss due to a sticking valve. Factors were the remaining worn lobes on the camshaft and the lack of suitable terrain onto which a successful forced landing could be executed.NTSB FTW94LA145Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · El Campo, TXThe partial loss of engine power due to one magneto being weak and the other magneto arcing inside its case. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · San Angelo, TXThe partial loss of engine power. A factor was the lack of suitable terrain.NTSB FTW93LA268Accident · No injuriesLimited investigationFinal reportCessna 182G · Baytown, TXThe fuel starvation power loss due to a sticking carburetor float. A factor was the lack of suitable terrain onto which a forced landing could be executed.NTSB FTW93FA251Accident · 3 fatalField investigationFinal reportCessna 182C · Porter, TXPartial loss of engine power for undetermined reasons. Factors in the accident which may have contributed were the distorted and separated muffler components resulting from improper maintenance by an unknown person.NTSB FTW93LA239Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Garwood, TXThe partial power loss for undetermined reasons. A factor was the lack of suitable terrain onto which a forced landing could be executed.NTSB FTW93FA229Accident · 1 fatalField investigationFinal reportCessna 152 · Houston, TXCompany management's dispatch of an airplane with known deficiencies, their failure to correct the deficiencies, and the student pilot's inadvertent entry into a stall. Factors which contributed to the accident were: chafed wiring, fouled spark plugs, a…NTSB FTW93LA201Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Spring, TXThe pilot's improperly planned approach and the resultant overshoot of the intended landing area. Factors were the partial power loss due to internal corrosion, and the inadvertent stall.NTSB FTW93LA191Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Navasota, TXPartial power loss due to left magneto fluctuating due to loose coil. A factor was the lack of suitable terrain for the forced landingNTSB FTW93LA152Accident · No injuriesLimited investigationFinal reportElliott B-80 · Amarillo, TXThe pilot's failure to compensate for wind conditions. Factors were the loss of engine power and the tailwindNTSB FTW93LA116Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Fort Worth, TXPartial power loss due to improper maintenance and resultant discrepancies. A factor was the lack of suitable terrain.