Skip to content

NTSB investigations: Lycoming 0-320 series, DE

23 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

19652026

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" = 'DE' 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\" = 'DE' 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" = 'DE' 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 ERA24LA264Accident · Serious injuriesClass 4 · LimitedFinal reportVans RV6 · Townsend, DEAn inadvertent encounter with rough or soft terrain during landing, resulting in a bent nose landing gear leg and subsequent nose over.Jun 14, 2024 · N298Z · Substantial damage NTSB ERA20CA318Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Wilmington, DEThe student pilot’s improper landing flare, which resulted in a hard bounced landing.Sep 7, 2020 · N19813 · Substantial damage NTSB ERA20CA117Accident · Serious injuriesData collectionFinal reportPiper PA28 · Wilmington, DEThe pilot being struck in the head by the propeller before flight, which resulted in a serious injury.Feb 29, 2020 · N228JS · No damage NTSB ERA17LA097Accident · Minor injuriesLimited investigationFinal reportPiper PA22 · Georgetown, DEAn in-flight fire for reasons that could not be determined due to extensive thermal damage to the airplane.Jan 28, 2017 · N3659Z · Destroyed NTSB ERA09CA207Accident · No injuriesData collectionFinal reportPiper PA28-151 · Dover, DEThe pilot's failure to maintain directional control during landing.Mar 20, 2009 · N41568 · Substantial damage NTSB NYC05FA117Accident · 2 fatalField investigationFinal reportCarlstrom Long EZ · Lewes, DEThe Long EZ pilot's failure to maintain clearance from the RV-8 airplane, which resulted in a mid-air collision during a formation flight.Jul 10, 2005 · N78LC · 2 aircraft · Destroyed NTSB IAD05LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Dover, DEThe separated baffle which blocked the tailpipe resulting in a subsequent total loss of engine power.May 14, 2005 · N55165 · Substantial damage NTSB BFO91LA023Accident · Serious injuriesLimited investigationFinal reportHolmes Special S2C · Ellendale, DEThe pilot's failure to recover from an aerobatic manuever in time to avoid inflight collision with the ground.Jan 15, 1991 · N484MH · Destroyed NTSB NYC83LA250Accident · No injuriesLimited investigationFinal reportCessna C172M · Dover, DEThe acft ran off the end of the rwy, groundlooped, and collided with a tree during an effort to avoid a blast fence. The landing, made at night with touchdown occurring too FAR down the rwy. An approach had already been abandoned due to excessive airspeed,…Sep 20, 1983 · N64006 · Substantial damage NTSB NYC81FHD18Accident · No injuriesClosedPiper PA-28 · Wilmington, DEFeb 4, 1981 · N98247 · Substantial damage NTSB IAD78FHD25Accident · Minor injuriesClosedCessna 177 · Broadkil Beach, DESep 27, 1978 · N3471T · Destroyed NTSB IAD76FHD23Accident · Serious injuriesClosedCessna 172 · Milford, DEApr 4, 1976 · N61992 · Substantial damage NTSB IAD74DHD40Accident · No injuriesClosedPiper PA-28 · Selbyville, DEJun 14, 1974 · N40925 · Substantial damage NTSB IAD74FHD01Accident · Minor injuriesClosedBellanca 7GCBC · Selbyville, DEJul 5, 1973 · N62970 · Substantial damage NTSB NYC72DHD07Accident · No injuriesClosedPiper PA-28 · Smyrna, DEAug 7, 1971 · N98247 · Substantial damage NTSB IAD71DHD41Accident · Minor injuriesClosedPiper PA-28 · Milford, DEMar 10, 1971 · N7210F · Substantial damage NTSB IAD70F0080Accident · Minor injuriesClosedPiper PA-28 · New Castle, DESep 14, 1969 · N98297 · Substantial damage NTSB DIA70D0013Accident · No injuriesClosedPiper PA-28 · Cheswold, DEJun 20, 1969 · N8224N · Substantial damage NTSB DIA69D0148Accident · No injuriesClosedPiper PA-28 · Cheswold, DEFeb 14, 1969 · N6315R · Destroyed NTSB NYC67D0334Accident · No injuriesClosedBeech A23-19 · New Castle, DEOct 9, 1966 · N5988S · Substantial damage NTSB NYC66D0500Accident · No injuriesClosedPiper PA-28 · Cheswold, DEFeb 20, 1966 · N6331W · Substantial damage NTSB NYC66F0030Accident · No injuriesClosedMooney M20 · Milford, DEMay 30, 1965 · N5283B · Substantial damage NTSB NYC65F0225Accident · No injuriesClosedBeechcraft B-23 · Smyrna, DEMay 20, 1965 · N8720M · Substantial damage