NTSB investigations: Lycoming 0-320 series, 1999, NJ

5 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, 1999, NJ per year, 1964–2026: 292 cases
19645
19658
196611
196713
19683
19697
197012
19719
19727
19738
197410
19757
19763
19776
19788
19797
19809
19814
198210
19834
19847
19855
19865
19873
19883
19894
19901
19914
19924
19936
19942
19954
19962
19975
19983
19995
20009
20011
200211
20033
20043
20056
20062
20072
20086
20091
20102
20111
20122
20132
20143
20152
20163
20173
20183
20193
20202
20221
20233
20243
20251

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\") = 1999
    AND c.\"eventStateOrRegion\" = 'NJ' 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 NYC99LA131Accident · Minor injuriesLimited investigationFinal reportCessna 172 · West Milford, NJThe flight instructors failure to maintain climb airspeed during the go-around, which degraded climb performance, resulting in an in-flight collision with terrain. Factors in the accident were, delay in executing a go-around, retracting the flaps to 10…May 31, 1999 · N1223F · Substantial damageNTSB NYC99FA125Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Hillsborough, NJThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor in the accident was the pilot's lack of experience in the accident airplane's make and model.May 29, 1999 · N98122 · Substantial damageNTSB NYC99LA094Accident · No injuriesLimited investigationFinal reportCessna 172M · Lumberton, NJThe pilot's misjudgment of altitude and distance which resulted in a runway overrun.Apr 17, 1999 · N12469 · Substantial damageNTSB NYC99LA066Accident · No injuriesLimited investigationFinal reportCessna 172N · Berlin, NJThe pilot in command's failure to obtain the proper touch down point on the runway, and failure to perform a go-around. A factor relating to the accident was a sudden wind shift.Feb 26, 1999 · N737MJ · Substantial damageNTSB IAD99LA028Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Fairfield, NJThe flight instructor's failure to maintain rotor rpm and his failure to complete the autorotational descent. A factor in the accident was the flight instructor's failure to fully deploy carburetor heat as directed in the Pilot's Operating Handbook.Jan 15, 1999 · N8041J · Substantial damage