OpenAirDocs.org

NTSB investigations: Lycoming 0-320 series, MD

6 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “In flight collision with object”. 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.

Cases per year

19822026

Where

Open the map

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.\"eventStateOrRegion\" = 'MD' 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')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220))
  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.

NTSB NYC05CA076Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Indian Head, MDThe pilot's failure to maintain adequate altitude/clearance while on final approach, which resulted in an in-flight collision with trees. A factor in this accident was the gusty wind conditions.Apr 27, 2005 · N8730E · Substantial damageNTSB BFO91LA064Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Berlin, MDThe unsuitable placement of two banners (improper planning) by other personnel causing an unintentional pickup of both banners.Jul 5, 1991 · N5BJ · Substantial damageNTSB BFO87FA050Accident · Minor injuriesField investigationFinal reportCessna 172P · Whitemarsh, MDThe pilot stated that he touched down near the end of the 22OO foot runway. However, witnesses said he landed so FAR down the runway that they did not believe he could stop on the runway. The pilot delayed his go around attempt to the point where it was not…Aug 2, 1987 · N54905 · Substantial damageNTSB BFO87DIG08Accident · Minor injuriesFinal reportPiper PA-28 · Mitchellville, MDDuring takeoff, the acft hit the tops of trees near the departure end of the rwy. The plt stated that after clipping the treetops, he knew the acft was 'going in,' so he pulled the yoke back to slow it as much as possible. Also, the plt stated that during…Jul 31, 1987 · N55757 · Substantial damageNTSB BFO87FA006Accident · Minor injuriesField investigationFinal reportPiper PA-28-140 · Bloomington, MDWitnesses observed 2 aircraft flying near treetop level and reported that one appeared to be about 10 feet behind the other. The lead aircraft collided with trees when the pilot delayed his pullup to a point where he was unable to climb over a ridge on his…Nov 1, 1986 · N5897U · Substantial damageNTSB ATL82FA087Accident · 4 fatalField investigationFinal reportPiper PA-28-140 · Westminster, MDThe aircraft crashed after takeoff from a 2930 ft runway with four occupants on board. The aircraft weight was not known, but was estimated to be 2334 lbs during takeoff. There was a light wind from the west and the temperature was 42 degrees fahrenheit.…Mar 28, 1982 · N2490T · Destroyed