NTSB investigations, 2010
259 cases where the sequence of events included Loss of engine power (total).
Cases, newest first
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 year(c.\"eventDate\") = 2010
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '341' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 year(c."eventDate") = 2010 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '341' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 WPR10LA130Accident · Minor injuriesLimited investigationFinal reportNanchang China CJ-6A · Mesa, AZSeparation of the cylinder from the engine during cruise flight due to fatigue in the studs attaching it to the engine casing.NTSB ERA10LA127Accident · No injuriesLimited investigationFinal reportCessna 150G · St. Augustine, FLA loss of engine power due to fuel exhaustion caused by the failure of the right wing fuel tank sending unit gasket, which resulted in a forced landing.NTSB ERA11WA269Incident · No injuriesForeign investigationEmbraer EMB-202 · Guarau, BrazilOn January 28, 2010, about 1030 coordinated universal time, an Embraer EMB-202, Brazilian registration PT-UPW, had a reported loss of power during cruise and landed in a soybean field near Guarau, Santa Catarina, Brazil. The pilot was not injured And the…NTSB WPR10LA118Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Reno, NVA total loss of engine power during cruise due to oil starvation as a result of foreign material blockage of the oil pickup tube.NTSB ERA10WA340Accident · Minor injuriesForeign investigationRobinson R44 · San Felipe, ChileOn January 21, 2010, at 2210 universal coordinated time, a Robinson R44 helicopter, Chilean registration CC-PSZ, experienced a loss of engine power while in cruise flight, and was substantially damaged during a subsequent forced landing, in San Felipe, Chile.…NTSB ERA10FA115Accident · 2 fatalField investigationFinal reportBeech B-60 · Madison, ALThe pilot's failure to divert to the nearest suitable airport following a total loss of power in the right engine during cruise flight. Contributing to the accident was the total loss of power in the right engine due to separation of its No. 2 cylinder as a…NTSB WPR10LA111Accident · No injuriesLimited investigationFinal reportErcoupe 415-D · Napa, CAA loss of engine power due to fuel starvation as a result of the unintentional movement of the fuel selector valve beyond its stops during takeoff initial climb resulting in restricted fuel flow.NTSB WPR10GA102Accident · Serious injuriesFinal reportHughes 369D · Kooskia, IDA complete loss of engine power due to the failure of the No. 2 bearing, which was precipitated by electrical arcing that occurred at an unknown time prior to the accident flight.NTSB CEN10CA087Accident · No injuriesData collectionFinal reportMaule M-4-220C · Pearsall, TXA total loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate preflight planning.