NTSB investigations, LA
19 cases where the defining event was Loss of engine power (partial).
Cases per year
| 2009 | 1 |
|---|---|
| 2010 | 2 |
| 2011 | 1 |
| 2012 | 2 |
| 2014 | 3 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 2 |
| 2020 | 4 |
| 2024 | 1 |
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '342')
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '342') 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 CEN25LA021Accident · No injuriesClass 3 · LimitedFinal reportMooney M20K · Elizabeth, LAThe pilot’s failure to set the engine fuel mixture to the required setting, which resulted in reduced engine power during a go-around and subsequent impact with trees. Contributing to the accident, the failure of the mechanic to perform a current fuel…NTSB CEN21LA072Accident · No injuriesClass 3 · LimitedFinal reportGrumman G164 · Elton, LAThe loss of engine power, which resulted in a forced landing on unsuitable terrain. The reason for the loss of engine power could not be determined based on available evidence.NTSB CEN20LA361Accident · No injuriesClass 3 · LimitedFinal reportCessna R182 · Crowley, LAThe failure of the No. 4 cylinder exhaust valve that resulted in a partial loss of engine power. Based on available evidence, the reason for the failed valve was not determined.NTSB CEN20LA282Accident · No injuriesClass 3 · LimitedFinal reportRobinson R22 · Venice, LAA partial loss of engine power for reasons that could not be determined based on available evidence.NTSB CEN20LA286Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson R44 · Welsh, LAA partial loss of engine power while in flight due to corrosion of engine components, which resulted in a loss of control and a subsequent impact with terrain.NTSB CEN19LA206Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 140 · Reeves, LAThe pilot's failure to secure the oil filler cap, which resulted in oil starvation and a precautionary off-airport landing, during which the airplane was substantially damaged.NTSB CEN19LA130Accident · No injuriesClass 3 · LimitedFinal reportCessna L19 · Milton, LAA loss of engine power for reasons that could not be determined based on the available information.NTSB CEN18LA281Accident · No injuriesLimited investigationFinal reportPiper PA28 · Shreveport, LAThe partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN17LA328Accident · No injuriesLimited investigationFinal reportBeech A36 · Gonzales, LAA partial loss of engine power due to inadequate maintenance, including worn spark plugs and a leaking fuel hose fitting.NTSB CEN16LA143Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Alexandria, LAThe partial loss of engine power for reasons that could not be determined based on the available information.NTSB CEN14LA450Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Natchez, LAThe loss of power due to the failure of the No. 2 exhaust valve and rocker boss during takeoff.NTSB CEN14FA435Accident · 1 fatalField investigationFinal reportCessna 172N · Natchitoches, LAThe partial loss of engine power due to the exhaust valve rocker retaining stud backing out of the cylinder head, which resulted in the exhaust valve being stuck in the closed position. Contributing to the accident was the pilot’s failure to configure the…NTSB CEN14LA229Accident · No injuriesLimited investigationFinal reportAir Tractor AT 301 · Hessmer, LAA partial loss of engine power for reasons that could not be determined because a full examination of the engine could not be performed.NTSB CEN12LA388Accident · No injuriesLimited investigationFinal reportCessna A150K · Mamou, LAThe pilot's inadequate preflight inspection, which resulted in a partial loss of engine power due to fuel contamination.NTSB CEN12FA250Accident · No injuriesField investigationFinal reportSikorsky S-76B · Gulf of Mexico, LAThe intermittent loss of engine power due to a "stuck" stepper motor in the No. 2 engine's fuel control as a result of an inadequate overhaul. Contributing to the accident was the pilot's decision to continue flying the helicopter with a known defect, his…NTSB CEN11FA292Accident · Minor injuriesField investigationFinal reportPiper PA-22/20 · New Orleans, LAThe pilot’s inadequate in-flight fuel management, which resulted in fuel starvation and a total loss of engine power.NTSB CEN11CA062Accident · No injuriesData collectionFinal reportCessna 172 · Pineville, LAThe pilot/mechanic’s improper inspection of the airplane following the engine installation.NTSB CEN10CA426Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Alexandria, LAThe loss of engine power for undetermined reasons.NTSB CEN09LA308Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Baton Rouge, LAThe partial loss of engine power due to the instructor pilot's failure to use carburetor heat while operating in conditions conducive to carburetor icing. Contributing to the accident was the instructor pilot's decision to attempt a return to the departure…