NTSB investigations: Lycoming 0-320 series, 2000, NY

6 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.

Cases per year

19642026
NTSB investigations: Lycoming 0-320 series, 2000, NY per year, 1964–2026: 438 cases
19649
196514
196620
196716
196816
196912
197018
197121
197213
197315
197415
197512
197617
197716
197817
197910
198011
19819
19827
19838
198410
19859
19868
19877
19884
19897
19905
19915
19923
19932
19943
19956
19964
19971
19982
19997
20006
20014
20024
20031
20043
20055
20063
20073
20082
20091
20109
20114
20123
20131
20142
20152
20162
20173
20183
20192
20206
20212
20223
20232
20241
20251
20261

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 year(c.\"eventDate\") = 2000
    AND 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 ('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.

NTSB NYC01LA017Accident · No injuriesLimited investigationFinal reportCessna 172 · Poughkeepsie, NYThe student pilot's improper recovery from a bounced landing.Oct 14, 2000 · N1297F · Substantial damageNTSB NYC00LA220Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Westhampton, NYThe pilot's inadequate flare during the landing. Factors were the entanglement of the tow rope with the rudder horn, and restricted rudder movement.Aug 5, 2000 · N17080 · Substantial damageNTSB IAD00LA059Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Dansville, NYthe loss of engine power during take-off for undetermined reasons.Jul 8, 2000 · N4456Z · Substantial damageNTSB IAD00LA054Accident · Serious injuriesLimited investigationFinal reportRobinson R-22B · East North Port, NYThe pilot's failure to maintain adequate rotor RPM and failure to follow published recovery procedures after the low rotor RPM warning horn and caution light activated.Jul 1, 2000 · N94RP · Substantial damageNTSB NYC00LA093Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Farmingdale, NYa power loss over unsuitable terrain, for undetermined reason(s).Mar 18, 2000 · N18AV · Substantial damageNTSB NYC00LA088Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Conesus, NYThe contamination of the aircraft's fuel. Contributing factors were the pilot's failure to maintain adequate altitude and his diversion of attention during the base turn, dark night conditions, and the tree.Mar 7, 2000 · N9040D · Destroyed