NTSB investigations, LA
104 cases where the first occurrence was “Loss of engine power”.
Cases per year
| 1982 | 10 |
|---|---|
| 1983 | 3 |
| 1984 | 2 |
| 1985 | 4 |
| 1986 | 5 |
| 1987 | 3 |
| 1988 | 6 |
| 1989 | 8 |
| 1990 | 7 |
| 1991 | 3 |
| 1992 | 2 |
| 1993 | 2 |
| 1994 | 3 |
| 1995 | 2 |
| 1996 | 2 |
| 1997 | 1 |
| 1998 | 6 |
| 1999 | 3 |
| 2000 | 2 |
| 2001 | 4 |
| 2002 | 5 |
| 2003 | 3 |
| 2004 | 9 |
| 2005 | 5 |
| 2006 | 2 |
| 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\" = 'LA' 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" = 'LA' 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 DFW07LA138Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Oak Grove, LAA complete loss of power due to failure of the impeller drive gear train and displacement of the blower spring drive mechanism, which resulted in seizure of the propeller shaft/crankshaft. Also causal was the failure of the phenolic separator bracket of the…NTSB DFW07LA116Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Morgan City, LAThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06LA135Accident · No injuriesLimited investigationFinal reportBoeing A75 · Jennings, LAThe partial loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06FA083Accident · 2 fatalField investigationFinal reportBell 206L-1 · Patterson, LAThe improper installation of an engine fuel line fitting by other maintenance personnel, which resulted in a loose fitting and a loss of engine power during cruise flight. Factors associated with the accident are a tailwind, and the lack of a suitable site…NTSB DFW06CA015Accident · Minor injuriesData collectionFinal reportChamberlain Vans RV6 · Eunice, LAThe loss of engine power for undetermined reason. A contributing factor was lack of suitable terrain for the forced landing.NTSB DFW05LA183Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Pollock, LAThe loss of engine power due to a loose engine lubrication system component in the crankcase. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05FA145Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Jeanerette, LAThe pilot's failure to obtain/maintain sufficient airspeed to maintain control. A contributing factor was the loss of engine power for undetermined reason.NTSB DFW05LA116Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Fenton, LAThe loss of engine power due to fuel starvation as a result of blockage of the firewall fuel filter with an unknown contaminant. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05FA055Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Patterson, LAThe pilot's failure to follow check-list procedures and the required placard instructions, which resulted in the fuel selectors being selected to the improper fuel tanks for take-off, resulting in a loss of engine power to the left engine. Also causal was the…NTSB DFW05IA048Incident · No injuriesIncident investigationFinal reportBeech A36 · Natchitoches, LAThe loss of engine power due to pre-ignition and detonation. Contributing factors were the lack of suitable terrain available for the forced landing and the unapproved installation of a turbocharger.NTSB DFW05FA038Accident · 2 fatalField investigationFinal reportCessna T210N · Abita Springs, LAThe loss of engine power for undetermined reasons. Also causal was the pilot's improper in-flight emergency planning when he misjudged his available altitude and made a 360 degree turn away from the airport instead of proceeding directly to it, which resulted…NTSB DFW05FA028Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Hammond, LAA loss of engine power due to the pilot's in-flight mismanagement of the available fuel supply by his failure to switch fuel tank position, which resulted in fuel starvation. Factors were the low ceilings and the prevailing dark night conditions.NTSB FTW04LA221Accident · Serious injuriesLimited investigationFinal reportBeech C23 · Shreveport, LAThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04LA166Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Crowley, LAThe loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04LA125Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Oil City, LAA loss of engine power for undetermined reasons, and the student pilot's failure to maintain airspeed resulting in a stall..NTSB FTW04CA106Accident · No injuriesData collectionFinal reportCessna 172K · Bogalusa, LAThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04LA091Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Plain Dealing, LAA loss of engine power due to undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04LA082Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Ville Platte, LAThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04LA063Accident · No injuriesLimited investigationFinal reportCessna 172K · Lake Charles, LAThe disintegration of the piston, which resulted in the catastrophic failure of the engine. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW03LA216Accident · No injuriesLimited investigationFinal reportBell 206B-3 · Kisatchie, LAA loss of engine power due to water contamination in the fuel system.NTSB FTW03LA204Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Winnsboro, LAThe pilot's inadequate inflight planning, which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB FTW02LA258Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-302 · Lacompte, LAThe loss of engine power for undetermined reason. A contributing factor was the lack of suitable terrain available to the pilot for the forced landing, and low altitude maneuvering.NTSB FTW02LA216Accident · No injuriesLimited investigationFinal reportBell TH-13T · New Iberia, LAThe loss of engine power for undetermined reasons. High vegetation was a factor.NTSB FTW02LA194Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Basile, LAthe loss of engine power as a result of fuel starvation. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW02LA191Accident · Minor injuriesLimited investigationFinal reportBeech BE-V35B · Baton Rouge, LAthe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW02LA152Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Hathaway, LAthe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW02LA010Accident · No injuriesLimited investigationFinal reportAir Tractor 402 · Angie, LAthe loss of engine power during takeoff for undetermined reasons.NTSB FTW01LA189Accident · No injuriesLimited investigationFinal reportDonald A Chiasson FP-404 · Port Allen, LAThe loss of engine power for undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW01LA177Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Bunkie, LAThe loss of engine power for undetermined reasons while maneuvering. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW01LA152Accident · 1 fatalLimited investigationFinal reportMottier RV-6 · Hammond, LAthe pilot's failure to maintain aircraft control following a loss of engine power. A factor was the loss of engine power during takeoff initial climb for undetermined reasons.NTSB FTW00LA209Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Kaplan, LAThe loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA096Accident · No injuriesLimited investigationFinal reportSiai-Marchetti S.205/22R · Rayville, LAThe loss of engine power for an undetermined reason, which resulted in a forced landing. A factor was the dark night light condition.NTSB FTW99LA186Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Gheens, LAThe loss of engine power due to fuel starvation as result of a blocked fuel vent. A factor was the lack of suitable terrain for the forced landing.NTSB FTW99LA115Accident · Minor injuriesLimited investigationFinal reportDavis/Cleaver Renegade 2 · Port Allen, LAThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW99LA113Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Franklinton, LALoss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB FTW99LA031Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400A · Bunkie, LAThe total loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB FTW98LA261Accident · Minor injuriesLimited investigationFinal reportGisclair Murphy Renegade SP · Galliano, LAA loss of engine power for undetermined reasons. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB FTW98LA249Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Iowa, LApartial loss of engine power during takeoff for undetermined reason(s). The obstructions (trees & dirt bank) were related factors.NTSB FTW98LA232Accident · Serious injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Eunice, LAThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW98LA193Accident · Serious injuriesLimited investigationFinal reportLerille P & W 1937 · Lafayette, LAThe fuel exhaustion due to the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB FTW98LA187Accident · No injuriesLimited investigationFinal reportBell 206B · Cameron, LAThe loss of engine power for undetermined reasons and the pilot's improper flare which resulted in a hard landing.NTSB FTW98LA034Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Roanoke, LAloss of engine power for an undetermined reason(s). A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB FTW96LA285Accident · No injuriesLimited investigationFinal reportHiller UH12 · Franklin, LAloss of engine power for undetermined reasons, and the pilot's failure to maintain rotor RPM. A factor was the unsuitable terrain available for the precautionary landing.NTSB FTW96LA166Accident · No injuriesLimited investigationFinal reportCessna 182RG · Welsh, LAa loss of engine power for undetermined reasons. A factor was the unsuitable terrain for the emergency landing.NTSB FTW95LA246Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18 Dromader · Jennings, LAThe partial power loss for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB FTW95LA159Accident · Serious injuriesLimited investigationFinal reportRobinson S-12 Airaile · Sugartown, LAA partial loss of engine power for reasons undetermined. A factor was the lack of suitable terrain on which to make a forced landing.NTSB FTW95LA032Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Ruston, LAThe pilot's improper handling of the helicopter after an apparent loss of power during a practice autorotation.NTSB FTW94LA109Accident · No injuriesLimited investigationFinal reportCessna 175 · Leesville, LAThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB FTW94LA095Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Olla, LAThe loss of engine power due to a blocked fuel line. A factor was the lack of suitable terrain for the forced landing.NTSB FTW93LA153Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Arnaudville, LAThe loss of engine power for undetermined reasons. A factor was the unsuitable terrain