NTSB investigations, Outside the U.S.
8 cases where the first occurrence was “Loss of engine power”.
Cases per year
| 1982 | 3 |
|---|---|
| 1984 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1999 | 1 |
| 2000 | 1 |
Latest 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.\"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."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 MIA00GA083Accident · Serious injuriesFinal reportRockwell OV-10D · Larandia, ColombiaA loss of power in the right engine due to undetermined reasons and the pilot's failure to maintain control of the airplane. Factors in this accident were; the pilot did not perform a weight and balance calculation, (airplane overweight at takeoff); the…NTSB LAX99LA267Accident · 1 fatalLimited investigationFinal reportCessna 152 · Agana, TaiwanThe loss or partial loss of engine power for undetermined reasons.NTSB DCA90RA025Accident · 27 fatalForeign investigationDouglas DC-6B · Guatemala City, GuatemalaNTSB MIA88LA202Accident · No injuriesLimited investigationFinal reportCessna 180 · Bimini, BahamasLow engine oil pressure and subsequent engine seizure for undetermined reasons.NTSB MIA84LA259Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Bimini, BahamasThe plt reported that he had been airborne for about 30 min when eng missed one time and stopped running. He attempted to switch fuel tanks but the selector only went to the off position and stuck. The plt ditched about 20 mi nw of Bimini island.NTSB MIA83LA030Accident · No injuriesLimited investigationFinal reportGulfstream American AA5A · Nr.Chubeay, BahamasThe pilot stated that engine lost power while over the ocean waters and the pilot was forced to ditch the plane. The pilot and passenger were rescued by a yacht in the vicinity of the crash site. The aircraft sank and the wreckage was not recovered.NTSB MIA83LA008Accident · Serious injuriesLimited investigationFinal reportBeech B24R · Near Great Inag, BahamasThe pilot reported that the engine lost power on a flight from montego bay, jamaica to Great inagua, Bahamas. He ditched in the atlantic ocean and was seriously injured. The aircraft sank in the water and was not recovered.NTSB MIA82DA182Accident · No injuriesFinal reportBeech 65 · Andros Is, BahamasWhile en route at 9000 ft MSL at night, the right engine reportedly lost power and was feathered. The pilot reported that the left engine had a partial loss of power and the aircraft would not maintain altitude. Communication was maintained with miami center…