Skip to content

NTSB investigations: Lycoming IO-320 series, NY

23 cases on aircraft whose registry engine model is Lycoming IO-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

Where

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" = 'NY' 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 ('41509')) 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\" = 'NY' 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 ('41509'))
  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" = 'NY' 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 ('41509'))
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 ERA22LA138Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Farmingdale, NYThe flight crew’s failure to verify the landing gear position prior to landing. Contributing to the accident was an overload in the landing gear motor electrical circuit which resulted in the circuit breaker opening, preventing the landing gear from extending.Feb 28, 2022 · N7943Y · Substantial damage NTSB ERA13CA298Accident · No injuriesData collectionFinal reportBellanca 7KCAB · East Aurora, NYThe pilot's failure to maintain aircraft control during a rejected takeoff on a soft turf runway with a gusty wind, resulting in the airplane nosing over.Jun 20, 2013 · N11679 · Substantial damage NTSB ERA09LA158Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Lakeville, NYThe pilot's failure to maintain aircraft control following a loss of engine power on the left engine for undetermined reasons.Feb 8, 2009 · N10JR · Substantial damage NTSB NYC07CA216Accident · No injuriesData collectionFinal reportPiper PA28-161 · William-Sodus, NYThe pilot's improper flare at touchdown, which resulted in a hard landing.Sep 4, 2007 · N444CF · Substantial damage NTSB NYC06CA164Accident · Serious injuriesData collectionFinal reportBaker, Timithy Falco F8L · Montgomery, NYThe pilot's inadequate pre-flight inspection, which resulted in a loss of engine power due to fuel contamination.Jun 30, 2006 · N4TB · Substantial damage NTSB NYC96LA069Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · South Wales, NYthe pilot's improper flare and failure to maintain directional control during landing.Mar 1, 1996 · N7807S · Substantial damage NTSB BFO92LA129Accident · Serious injuriesLimited investigationFinal reportPiper PA-30K · Schaghticoke, NYThe loss of total engine power due to fuel starvation. Contributing to the accident was the loss of total electrical power.Sep 7, 1992 · N400RD · Substantial damage NTSB NYC88FA248Accident · 2 fatalField investigationFinal reportPiper PA-39-30 · Margaretville, NYThe acft departed block island, RI en route to stewart international airport, newburgh, new york, the aircraft never arrived and was reported missing August 2, 1988. The aircraft was missing until November 21, 1988 when it was found near Margaretville, NY by…Jul 31, 1988 · N2875A · Destroyed NTSB NYC83FA050Accident · Minor injuriesField investigationFinal reportPiper PA-30 · Montgomery, NYThe acft experienced a power loss on one engine during take-off initial climb. The pilot regained control of the acft and continued to fly the landing pattern. On the downwind leg the engines ran intermittently. Turning final both enginesstopped. A forced…Jan 7, 1983 · N223JN · Destroyed NTSB NYC81FA027Accident · No injuriesClosedPiper PA-30 · North Castle, NYFeb 19, 1981 · N750HK · Substantial damage NTSB NYC80FA070Accident · 1 fatalClosedPiper PA-30 · Cutchogue, NYAug 14, 1980 · N7094Y · Destroyed NTSB NYC80FHM22Accident · Minor injuriesClosedPiper PA-30 · Lagrangeville, NYAug 7, 1980 · N7103Y · Substantial damage NTSB NYC76FFA17Accident · No injuriesClosedPiper PA-30 · White Lake, NYOct 10, 1975 · N7963Y · Substantial damage NTSB NYC75FHD24Accident · No injuriesClosedChampion 7KCAB · Bridgeport, NYOct 13, 1974 · N5129X · Substantial damage NTSB NYC72FHM04Accident · No injuriesClosedPiper PA-30 · Spring Valley, NYAug 18, 1971 · N8608Y · Substantial damage NTSB NYC70FFJ18Accident · No injuriesClosedCessna 177 · Akron, NYJun 10, 1970 · N3121T · Substantial damage NTSB NYC70FFA14Accident · No injuriesClosedPiper PA-30 · Albany, NYMar 15, 1970 · N7169Y · Substantial damage NTSB NYC70AN092Accident · No injuriesClosedPiper PA-30 · Wappinger Fals, NYFeb 24, 1970 · N8555Y · Substantial damage NTSB NYC69A0003Accident · 5 fatalClosedPiper PA-30 · Gasport, NYJul 3, 1968 · N7027Y · Destroyed NTSB NYC68D0477Accident · No injuriesClosedPiper PA-30 · Montauk, NYMay 5, 1968 · N7282Y · Substantial damage NTSB NYC67A0101Accident · No injuriesClosedPiper PA-30 · Jamaica, NYJan 11, 1967 · N8006Y · Substantial damage NTSB UNK65X1102Accident · No injuriesClosedPiper PA30 · Niagara Falls, NYDec 23, 1964 · N7547Y · Substantial damage NTSB UNK65X0167Accident · No injuriesClosedPiper PA30 · Skaneateles, NYOct 6, 1964 · N7484Y · Substantial damage