Skip to content

Final NTSB investigations: Lycoming 0-320 series, Outside the U.S.

26 cases on aircraft whose registry engine model is Lycoming 0-320 series. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Latest cases

Query with SQL

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."completionStatus" = 'Completed' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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.\"completionStatus\" = 'Completed'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508'))
  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."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508'))
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 ANC20CA014Accident · No injuriesData collectionFinal reportCessna 172 · Tokyo, JapanThe airplane’s encounter with prop wash while taxiing behind a larger airplane that was conducting a high-power engine run on the same taxiway. Contributing to the accident was the air traffic controller’s failure to inform the smaller airplane’s pilot about…Dec 15, 2019 · N22905 · Substantial damage NTSB WPR18LA092Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Obyan, SarkThe pilot's inadequate preflight fuel planning and inadequate in-flight fuel monitoring which resulted in a total loss of engine power due to fuel exhaustion and an emergency landing and subsequent impact with a ditch.Feb 19, 2018 · N7328F · Substantial damage NTSB ERA15LA091Accident · Minor injuriesLimited investigationFinal reportCessna 172M · South Bimini, BahamasThe total loss of engine power for reasons that could not be determined because examination of the engine did not reveal any anomalies that would have precluded normal operation, which resulted in a subsequent ditching in the ocean.Dec 22, 2014 · N12182 · Substantial damage 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.Nov 14, 1982 · N26287 · Destroyed NTSB MIA780KT40Accident · No injuriesClosedCessna 172 · Cay Verde, Burkina FasoJan 24, 1978 · N9391H · Substantial damage NTSB OAK76O0003Accident · No injuriesClosedTwin Engine D-16 · Bahia Concpcn, MexicoNov 28, 1975 · N377WS · Substantial damage NTSB UNK74X0116Accident · No injuriesClosedPiper PA-23 · Virgin Gorda, U.S. Virgin IslandsJul 26, 1974 · N765WC · Substantial damage NTSB MIA73OM021Incident · No injuriesClosedPiper PA-23 · Virgin Gorda, U.S. Virgin IslandsAug 21, 1972 · N4444P · Minor damage NTSB LAX73OL011Accident · No injuriesClosedAero Comdr 100 · Villa Ahumada, MexicoJun 9, 1972 · N3875X · Substantial damage NTSB UNK72X0105Accident · No injuriesClosedPiper PA-23 · Pelee Is, CanadaMar 6, 1972 · N1941 · Substantial damage NTSB FTW72DRG53Accident · No injuriesClosedCessna 172 · Puerto Penaso, MexicoMar 3, 1972 · N84308 · Substantial damage NTSB MIA72RKT28Accident · Minor injuriesClosedPiper PA-23 · Nassau, Burkina FasoNov 16, 1971 · N2226P · Substantial damage NTSB MIA71OKT64Accident · No injuriesClosedCessna 172 · Coco Solo, St. Pierre & MiquelonMay 26, 1971 · N7474G · Destroyed NTSB MEX71A0051Accident · 2 fatalClosedCessna 150A · San Quintin, MexicoAug 29, 1970 · N8916S · Destroyed NTSB CAN71AQ905Accident · Minor injuriesClosedPiper PA-22 · Furnace Falls, CanadaAug 23, 1970 · N8811D · Substantial damage NTSB UNK70X0104Accident · 4 fatalClosedPiper PA-23 · Inagua, Burkina FasoNov 27, 1969 · N4408P · Destroyed NTSB UNK69X0113Accident · No injuriesClosedPiper PA-28 · Rio Salado, MexicoMar 25, 1969 · N4295J · Substantial damage NTSB MIA68D0255Accident · No injuriesClosedAero Comdr 100 · Exhuma Is., Burkina FasoOct 9, 1967 · N2923T · Substantial damage NTSB OAK68O0004Accident · No injuriesClosedPiper PA-28 · Clark Ab, RPApr 27, 1967 · N6909W · Substantial damage NTSB MIA67S0002Accident · 2 fatalClosedMooney M20 · Vera Cruz, MexicoJul 14, 1966 · N5291B · Destroyed NTSB CAN65AF386Accident · Serious injuriesClosedPiper PA-18 · Atlin Lake, CanadaOct 5, 1965 · N5139Y · Substantial damage NTSB UNK65X1442Accident · No injuriesClosedPiper PA-22 · Puerto Ordaz, VenezuelaFeb 21, 1965 · N4438A · Substantial damage NTSB UNK65X0938Accident · 1 fatalClosedPiper PA-23 · Bimini Bwi, WNDec 6, 1964 · N1420P · Substantial damage NTSB UNK64X3386Accident · 2 fatalClosedPiper PA-28 · Lake Athabaska, CanadaAug 15, 1964 · N5343W · Destroyed NTSB UNK64X2223Accident · No injuriesClosedCessna 172 · Foremost, CanadaJun 11, 1964 · N7304A · Substantial damage NTSB UNK64X0489Accident · No injuriesClosedPiper PA-28 · Cuatehmo, MexicoFeb 8, 1964 · N5575W · Substantial damage