NTSB investigations, TX
430 cases where the first occurrence was “Loss of engine power”.
Cases per year
| 1982 | 26 |
|---|---|
| 1983 | 19 |
| 1984 | 11 |
| 1985 | 17 |
| 1986 | 15 |
| 1987 | 9 |
| 1988 | 12 |
| 1989 | 7 |
| 1990 | 10 |
| 1991 | 9 |
| 1992 | 16 |
| 1993 | 8 |
| 1994 | 15 |
| 1995 | 16 |
| 1996 | 17 |
| 1997 | 13 |
| 1998 | 22 |
| 1999 | 15 |
| 2000 | 16 |
| 2001 | 23 |
| 2002 | 28 |
| 2003 | 23 |
| 2004 | 20 |
| 2005 | 23 |
| 2006 | 18 |
| 2007 | 22 |
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\" = 350)
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" = 350) 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 DFW08LA046Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXThe loss of engine power during cruise flight due to the pilot's failure to refuel the airplane prior to fuel exhaustion.NTSB DFW08LA025Accident · Serious injuriesLimited investigationFinal reportBeech J35 · Fort Worth, TXFailure of the operator to ensure that the metering unit's throttle arm and throttle cable were secured using manufacturer approved hardware. A contributing factor to the pilot's injuries was the lack of shoulder retraints.NTSB DFW08LA035Accident · No injuriesLimited investigationFinal reportAyres S2-R · Lenora, TXThe loss of engine power due to separation of the "P3" line from the engine's fuel control.NTSB DFW08LA013Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-260 · Houston, TXThe pilot's failure to properly position the fuel tank selector before takeoff. Contributing to the accident were the non suitable terrain for the forced landing and fuel starvation.NTSB DFW08FA004Accident · 2 fatalField investigationFinal reportCessna 150L · Castroville, TXLoss of engine power for undetermined reasons and the pilot receiving instruction's failure to maintain aircraft control resulting in the stall. A factor contributing to the accident was the instructor pilot's delayed remedial action.NTSB DFW07LA203Accident · No injuriesLimited investigationFinal reportAir Tractor AT 602 · Floydada, TXA leak in the outer ply of the BeCu bellows. This hole appeared to be the result of pitting corrosion, but the corroding agent was not determined.NTSB DFW07LA191Accident · Serious injuriesLimited investigationFinal reportBeech B35 · Borger, TXA loss of engine power while on approach due to fuel starvation. Contributing to the accident were a corroded carburetor fuel needle valve, inlet fuel screen and no suitable terrain for the forced landing.NTSB DFW07LA173Accident · Serious injuriesLimited investigationFinal reportBell 206B · Grand Prairie, TXThe loss of engine power as result of the failure of one or more of the compressor blades for the 5th stage compressor for undetermined reasons. A contributing factor was the lack of suitable terrain for the pilot to execute a successful autorotation.NTSB DFW07CA161Accident · No injuriesData collectionFinal reportRodgers Zodiac 601XL · Levelland, TXThe loss of engine power for undermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07CA150Accident · No injuriesData collectionFinal reportAyres S2R-G10 · Colorado City, TXThe loss of engine power due to an oil leak. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07CA121Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Lubbock, TXThe failure of the engine fuel supply line and the separation of the number one cylinder exhaust pipe resulting in an engine fire.NTSB DFW07LA118Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5B · Hilltop Lakes, TXThe loss of engine power due to carburetor ice. Contributing factors were the lack of suitable terrain for a forced landing and the weather conditions that were conducive to carburetor ice.NTSB DFW07LA103Accident · 2 fatalLimited investigationFinal reportLivpt Lancair IV-P · McAllen, TXA loss of power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07CA093Accident · No injuriesData collectionFinal reportDwayne Smith RV-6 · Fort Worth, TXThe loss of engine power during cruise flight for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07TA089Accident · Minor injuriesFinal reportPiper PA-18 · Sweetwater, TXThe loss of engine power due to the failure of the throttle lever/linkage. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07LA088Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Laredo, TXThe loss of engine power for undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07CA086Accident · No injuriesData collectionFinal reportBrantly Helicopter B2 · Vernon, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07CA066Accident · No injuriesData collectionFinal reportBell ARH-70 Exp. · Mansfield, TXFuel starvation due to blockage in a fuel system check valve which was the result of the improper assembly of fuel boost pump by company maintenance personnel.NTSB DFW07CA070Accident · Minor injuriesData collectionFinal reportCessna 172B · Stephenville, TXThe loss of engine power during the landing approach due to the pilot's failure to follow the appropriate procedures to preclude carburetor ice in known carburetor icing conditions.NTSB DFW07CA064Accident · No injuriesData collectionFinal reportBeech F35 · McKinney, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07LA061Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Fulshear, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07CA060Accident · No injuriesData collectionFinal reportTanker DR-107 One Design · Rockwall, TXA loss of engine power for an undetermined reason during a go-around, which resulted in a forced landing. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07CA044Accident · No injuriesData collectionFinal reportCessna 150M · Eastland, TXThe partial loss of engine power for an undetermined reason during cruise flight, which resulted in a forced landing and an overrun. A factor associated with the accident was the pilot's misjudged distance/speed while landing.NTSB DFW07LA017Accident · No injuriesLimited investigationFinal reportMooney M20E · Nacogdoches, TXThe loss of engine power for undetermined reasons.NTSB DFW07LA016Accident · No injuriesLimited investigationFinal reportBeech F33 · Houston, TXThe loss of engine power due to fuel starvation as a result of the pilot's improper fuel management.NTSB DFW07LA010Accident · No injuriesLimited investigationFinal reportTaylor Zodiac 601 · San Antonio, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07LA009Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Wimberley, TXthe pilot's inadequate pre-flight planning which resulted in fuel starvation and the subsequent the loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06CA212Accident · Minor injuriesData collectionFinal reportVans RV4 · Springtown, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06LA208Accident · No injuriesLimited investigationFinal reportMorton Mustang II · Conroe, TXThe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06LA199Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Houston, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06LA188Accident · 1 fatalLimited investigationFinal reportCessna P210N · Amarillo, TXThe loss of engine power as result of the failure by maintenance personnel to install oil pump support bushings, which resulted in the fracture of the driven-gear and subsequent loss of oil pressure. Contributing factors were the lack of suitable terrain for…NTSB DFW06LA183Accident · No injuriesLimited investigationFinal reportGrumman AA-1 · Floydada, TXThe loss of fuel pressure and subsequent loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06CA176Accident · No injuriesData collectionFinal reportCessna 210A · Denver City, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06LA141Accident · Serious injuriesLimited investigationFinal reportRobinson R44 · Payne Springs, TXThe loss of engine power for undetermined reasons.NTSB DFW06CA126Accident · Minor injuriesData collectionFinal reportPiper J3C-65 · Paris, TXThe reported loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain available for the forced landing.NTSB DFW06CA125Accident · No injuriesData collectionFinal reportBellanca 17-A30 · Georgetown, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06LA122Accident · Serious injuriesLimited investigationFinal reportBeech C23 · Bishop, TXThe delayed landing flare by the pilot which resulted in a hard landing. A contributing factor was the loss of engine power for undetermined reasons.NTSB DFW06LA121Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-802A · Jasper, TXThe loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable landing for the pilot to execute the forced landing.NTSB DFW06LA101Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Kerrville, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB DFW06LA071Accident · Serious injuriesLimited investigationFinal reportHodge Express · Tyler, TXA loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06LA041Accident · 1 fatalLimited investigationFinal reportBoeing A75N1 (PT17) · Fort Worth, TXThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin. Contributing factors were the reported loss of engine power for undetermined reasons and the low altitude maneuver.NTSB DFW06LA040Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Columbus, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06CA022Accident · No injuriesData collectionFinal reportPiper PA38 · Decatur, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06CA011Accident · No injuriesData collectionFinal reportBell B206 L-3 · Marble Falls, TXA hard landing as result of a loss of engine power for undetermined reasons.NTSB DFW06LA010Accident · Minor injuriesLimited investigationFinal reportCessna 208 · Round Rock, TXThe loss of engine power due to the failure of the engine-driven fuel pump. A contributing factor was the inadequate inspection of the engine driven fuel pump.NTSB DFW05FA241Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Houston, TXThe pilot's improper in-flight decision to maneuver back to the departure airport following a loss of engine power on initial climb. Contributing factors were the loss of engine power for undetermined reasons, and the dark night conditions.NTSB DFW05MA230Accident · Serious injuriesMajor investigationFinal reportSikorsky S76 · Gulf of Mexico, TXThe pilots' delayed response to the No. 1 engine fire warning and the loss of power to both engines, which occurred for undetermined reasons. The pilots' delayed response was most likely due to stress and fatigue. Contributing to the delay of the initiation…NTSB DFW05CA210Accident · No injuriesData collectionFinal reportMcCain RV-8 · Stephenville, TXThe loss of fuel pressure and subsequent loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05CA209Accident · No injuriesData collectionFinal reportRockwell S-2R · Lyford, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05CA201Accident · Minor injuriesData collectionFinal reportSmith Aerostar 601P · Sinton, TXThe pilot's failure to abort the takeoff and the subsequent loss of engine power for undetermined reasons. Contributing factors were the attempted operation of the airplane with known deficiencies in the equipment and the lack of suitable terrain for the…