NTSB investigations: Lycoming 0-320 series, 1988, MN
3 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 | 6 |
| 1966 | 6 |
| 1967 | 14 |
| 1968 | 12 |
| 1969 | 5 |
| 1970 | 6 |
| 1971 | 4 |
| 1972 | 5 |
| 1973 | 7 |
| 1974 | 5 |
| 1975 | 12 |
| 1976 | 7 |
| 1977 | 16 |
| 1978 | 13 |
| 1979 | 5 |
| 1980 | 7 |
| 1981 | 8 |
| 1982 | 5 |
| 1983 | 4 |
| 1984 | 4 |
| 1985 | 1 |
| 1986 | 2 |
| 1987 | 6 |
| 1988 | 3 |
| 1989 | 6 |
| 1990 | 4 |
| 1991 | 2 |
| 1992 | 4 |
| 1993 | 4 |
| 1994 | 3 |
| 1995 | 2 |
| 1996 | 3 |
| 1997 | 2 |
| 1998 | 4 |
| 1999 | 4 |
| 2000 | 3 |
| 2001 | 6 |
| 2002 | 2 |
| 2003 | 2 |
| 2004 | 7 |
| 2005 | 4 |
| 2006 | 4 |
| 2007 | 2 |
| 2008 | 4 |
| 2009 | 3 |
| 2010 | 3 |
| 2011 | 2 |
| 2012 | 4 |
| 2013 | 3 |
| 2015 | 1 |
| 2017 | 2 |
| 2018 | 1 |
| 2019 | 2 |
| 2020 | 5 |
| 2021 | 1 |
| 2023 | 3 |
| 2024 | 2 |
| 2025 | 2 |
Where
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\") = 1988
AND c.\"eventStateOrRegion\" = 'MN' 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") = 1988
AND c."eventStateOrRegion" = 'MN' 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 MKC89LA032Accident · No injuriesLimited investigationFinal reportCessna 172 · Little Falls, MNWhile attempting a touch and go ldg during a student solo cross country flt, directional control was lost during the takeoff phase on the snow packed runway. The student pilot said he had never landed and taken off under those runway conditions. The acft…NTSB CHI88LA132Accident · No injuriesLimited investigationFinal reportCessna 172 · Fairmont, MNThe student pilot was attempting to land. Just prior to touchdown a gust of wind pushed the aircraft to the left of the runway. The pilot was unable to maintain control of the aircraft resulting in the aircraft encountering a stall and colliding with the…NTSB CHI88DER02Accident · 2 fatalFinal reportBellanca 7GCBC · Warroad, MNThe aircraft experienced a loss of control and rapid descent onto the ice in what witnesses described as a spin type maneuver from a low altitude. The purpose of the flight was a low level photo mission. The aircraft was destroyed. The pilot and passenger…