NTSB investigations, Outside the U.S.
10 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.
Cases per year
| 1984 | 1 |
|---|---|
| 1986 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1997 | 2 |
| 1998 | 1 |
| 2006 | 1 |
| 2007 | 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\" = 353)
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" = 353) 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 ERA13IA006Incident · No injuriesIncident investigationFinal reportLockheed WP-3D · A1Extensive salt buildup in the inlets of all four engines, which resulted in compressor stalls and tailpipe fires in three of the four engines.NTSB LAX06FA258Accident · Serious injuriesField investigationFinal reportPiper PA-32-300 · Saipan, SarkA loss of engine power during the initial climb due to fuel starvation resulting from the pilot's improper fuel selector valve position selection and his failure to select a tank containing an adequate fuel supply. Contributing to the accident was the high…NTSB ATL99LA026Accident · Minor injuriesLimited investigationFinal reportBeech 65-A90 · La Tortue, HaitiInadequate preflight planning/preparation by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor was the terrain ( water).NTSB LAX97LA193Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Rota, Sarkthe unauthorized use of automobile gasoline which led to the loss of engine power due to fuel vapor generation.NTSB LAX97FA086Accident · 2 fatalField investigationFinal reportEnstrom F28A · Saipan Island, Sarkloss of engine power due to fuel exhaustion, resulting from improper planning/decision; and the pilot's abrupt handling of the flight controls, while maneuvering to avoid swimmers, which resulted in main rotor blade contact with the tail boom. A related…NTSB LAX92LA051Accident · No injuriesLimited investigationFinal reportCessna 172M · Saipan, SarkA loss of engine power due to carburetor icing and the failure of the pilot to correctly use carburetor heat.NTSB LAX89LA129Accident · No injuriesLimited investigationFinal reportHughes 269C · Saipan, SarkFailure of maintenance personnel to assure the helicopter was serviced with the proper grade of fuel. A factor realated to the accident was: the lack of a suitable landing area, which resulted in having to ditch the helicopter in the water.NTSB LAX87LA110Accident · 2 fatalLimited investigationFinal reportCessna 150L · Ayase, JapanDuring an instructional flight, just after take-off the instructor was heard to transmit over the radio 'request emergency landing.' At an altitude of approximately 15O feet AGL the aircraft was observed to pitch up then nosed down in a shallow left turn. The…NTSB DCA86AA017Accident · 2 fatalFinal reportCessna P210N · Keflavik, IcelandAt 1146 gmt, N4906K deptd on a 5 hr flt to narssarssuaq, greenland with an estd 7 hrs of fuel. When the plt rprtd 60 mi sw of greenland, the destn vis was below IFR min & the ceiling at the altn arpt was below the mda. The plt elected to cont to reykjavik,…NTSB NYC85LA013Accident · 1 fatalLimited investigationFinal reportDe Havilland DHC-4 · Sable Island Ns, CanadaPlt ditched acft in atlantic ocean following a loss of power due to fuel exhaustion. Co-pilot stated they were aware of bad wx along the route but the plt was anxious to get to their destination. Headwinds encountered en route were stronger then expected.…