NTSB investigations: Lycoming 0-320 series, 1985, 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
| 1964 | 5 |
|---|---|
| 1965 | 8 |
| 1966 | 11 |
| 1967 | 13 |
| 1968 | 3 |
| 1969 | 7 |
| 1970 | 12 |
| 1971 | 9 |
| 1972 | 7 |
| 1973 | 8 |
| 1974 | 10 |
| 1975 | 7 |
| 1976 | 3 |
| 1977 | 6 |
| 1978 | 8 |
| 1979 | 7 |
| 1980 | 9 |
| 1981 | 4 |
| 1982 | 10 |
| 1983 | 4 |
| 1984 | 7 |
| 1985 | 5 |
| 1986 | 5 |
| 1987 | 3 |
| 1988 | 3 |
| 1989 | 4 |
| 1990 | 1 |
| 1991 | 4 |
| 1992 | 4 |
| 1993 | 6 |
| 1994 | 2 |
| 1995 | 4 |
| 1996 | 2 |
| 1997 | 5 |
| 1998 | 3 |
| 1999 | 5 |
| 2000 | 9 |
| 2001 | 1 |
| 2002 | 11 |
| 2003 | 3 |
| 2004 | 3 |
| 2005 | 6 |
| 2006 | 2 |
| 2007 | 2 |
| 2008 | 6 |
| 2009 | 1 |
| 2010 | 2 |
| 2011 | 1 |
| 2012 | 2 |
| 2013 | 2 |
| 2014 | 3 |
| 2015 | 2 |
| 2016 | 3 |
| 2017 | 3 |
| 2018 | 3 |
| 2019 | 3 |
| 2020 | 2 |
| 2022 | 1 |
| 2023 | 3 |
| 2024 | 3 |
| 2025 | 1 |
Where
Open the mapLatest 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\") = 1985
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.
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") = 1985
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" DESCRun 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 NYC86LA033Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Colts Neck, NJThe acft was being used to fly an advertising banner for the jersey shore marathon. The flt took off in a westerly direction, following the traffic pattern, climbing to aprx 1500 ft. a pullup maneuver was made to simulate a banner pickup. The plt checked for…NTSB NYC85LA202Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Wildwood, NJN21521 taxied onto runway 10 at the intersection of runway 14 after observing another aircraft taxi and take off from that point. N21521 did not attain sufficient airspeed for takeoff prior to running out of available runway. The pilot did not apply hard…NTSB NYC85LA180Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Bedminster, NJN4319F heard NG138J announce its position in the traffic pattern throughout the approach and landing. N4319F landed on runway 30 and was taxiing back to the ramp on the parallel taxiway. The occupant of N4319F observed N6139J land about midway down the runway…NTSB NYC85FA162Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Cape May, NJThe tow plane came in for a banner pickup. The ground handler holding the tail of the double banner had his left foot caught by the banner as it went airborne. The ground handler was carried 50 to 100 ft in the air prior to falling to the ground. The ground…NTSB NYC85LA084Accident · No injuriesLimited investigationFinal reportCessna 172P · Princeton, NJThe acft experienced nose gear damage following a loss of control during touchdown. The plt stated the acft touched down on the main gear and bounced as the nose gear was being lowered. After the acft porpoised several times the plt was able to regain control…