Skip to content

NTSB investigations: Lycoming 0-320 series, PR

24 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."eventStateOrRegion" = 'PR' AND c."eventCountry" = 'USA' 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.\"eventStateOrRegion\" = 'PR' AND c.\"eventCountry\" = 'USA'
    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."eventStateOrRegion" = 'PR' AND c."eventCountry" = 'USA'
  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 ERA15LA151Accident · No injuriesLimited investigationFinal reportPiper PA23 · San Juan, PRThe total loss of right engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.Mar 9, 2015 · N1153P · Substantial damage NTSB ERA15FA096Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Catano, PRThe student pilot’s failure to maintain rotor rpm while maneuvering in the airport traffic pattern, which resulted in the helicopter’s uncontrolled descent to the water. Contributing to the accident was the student’s distraction with other aircraft operating…Jan 10, 2015 · N348VH · Destroyed NTSB ERA12FA484Accident · 1 fatalField investigationFinal reportCessna 172M · San Juan, PRMaintenance personnel’s improper lubrication of the right direct aileron control cable and failure to detect the severe corrosion of the cable during a maintenance inspection, which resulted in the in-flight failure of the cable, the pilot’s subsequent…Jul 25, 2012 · N73115 · Substantial damage NTSB ERA12CA211Accident · No injuriesData collectionFinal reportCessna 172M · Mayaquez, PRThe pilot did not maintain control of the airplane while landing in crosswind conditions.Feb 19, 2012 · N5286H · Substantial damage NTSB ERA11LA230Accident · No injuriesLimited investigationFinal reportCessna 172P · Vega Baja, PRThe failure of the No. 2 cylinder exhaust valve resulting in a loss of engine power.Apr 1, 2011 · N98FR · Substantial damage NTSB MIA05CA009Accident · Serious injuriesData collectionFinal reportRobinson R-22 · Vega Baja, PRThe pilot's failure to select a suitable landing area resulting in a tangled skid with vegetation during an aborted landing and subsequent dynamic roll over.Oct 19, 2004 · N2314T · Substantial damage NTSB MIA03LA006Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Las Palmas, PRThe pilot's failure to switch fuel tanks resulting in a partial loss of engine power due to fuel starvation during a go-around. Additionally, the pilot's failure to monitor airspeed and proper touchdown point during the emergency landing resulted in another…Oct 23, 2002 · N2838T · Substantial damage NTSB MIA02LA051Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Levittown, PRthe failure of maintenance personnel to comply with aircraft manufacturer's inspection procedures, resulting in corrosion and separation of the aileron control cable in flight and the subsequent forced landing in a swamp.Jan 26, 2002 · N99295 · Substantial damage NTSB MIA02LA031Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Barceloneta, PRThe pilot's failure to maintain control of the aircraft which resulted in an uncontrolled descent and an in flight collision with water. Contributing to the accident was the impairment of the pilot due to alcohol.Nov 23, 2001 · N61582 · Substantial damage NTSB MIA82FKA01Accident · No injuriesClosedPiper PA-28 · Caba Rojo, PROct 8, 1981 · N7503R · Substantial damage NTSB MIA81FA001Accident · 4 fatalClosedPiper PA-28 · Aguadilla, PROct 10, 1980 · N707XQ · Destroyed NTSB MIA80FKA02Accident · No injuriesClosedCessna 172 · Mona Island, PRDec 9, 1979 · N737ME · Substantial damage NTSB MIA79FA082Accident · 4 fatalClosedCessna 172M · San Juan, PRMay 13, 1979 · N707AC · Destroyed NTSB MIA79FKA01Accident · Serious injuriesClosedCessna 172 · San Juan, PROct 25, 1978 · N61567 · Substantial damage NTSB MIA72DKA08Accident · Minor injuriesClosedPiper PA-28 · Mayaguez, PRDec 14, 1971 · N5991W · Substantial damage NTSB MIA72FKA06Accident · No injuriesClosedPiper PA-23 · Culebra Town, PRNov 2, 1971 · N3495P · Substantial damage NTSB MIA71DKA10Accident · No injuriesClosedPiper PA-23 · San Juan, PRMar 1, 1971 · N1289P · Substantial damage NTSB MIA71AM070Accident · 3 fatalClosedPiper PA-28 · Aguadilla, PRFeb 7, 1971 · N3680K · Destroyed NTSB MIA68A0002Accident · 4 fatalClosedPiper PA-28 · Mayaguez, PRJul 2, 1967 · N5100W · Destroyed NTSB MIA66D0613Accident · No injuriesClosedAeronca 7ECA · Manati, PRJun 9, 1966 · N2531F · Substantial damage NTSB MIA66D0360Accident · No injuriesClosedPiper PA-28 · La Parguera, PRDec 10, 1965 · N5417W · Substantial damage NTSB UNK65X0910Accident · No injuriesClosedPiper PA23 · San Juan, PRDec 3, 1964 · N3473P · Substantial damage NTSB UNK65X0552Accident · No injuriesClosedPiper PA28 · Mayaguez, PRNov 4, 1964 · N6051W · Substantial damage NTSB UNK64X1474Accident · No injuriesClosedPiper PA28 · Lobos Is, PRApr 26, 1964 · N5657W · Substantial damage