NTSB investigations: Lycoming 0-320 series, 2002, MO
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 | 7 |
|---|---|
| 1965 | 12 |
| 1966 | 6 |
| 1967 | 12 |
| 1968 | 3 |
| 1969 | 2 |
| 1970 | 8 |
| 1971 | 13 |
| 1972 | 5 |
| 1973 | 4 |
| 1974 | 6 |
| 1975 | 5 |
| 1976 | 10 |
| 1977 | 8 |
| 1978 | 14 |
| 1979 | 6 |
| 1980 | 8 |
| 1981 | 8 |
| 1982 | 11 |
| 1983 | 6 |
| 1984 | 6 |
| 1985 | 5 |
| 1986 | 3 |
| 1987 | 6 |
| 1988 | 3 |
| 1989 | 4 |
| 1990 | 2 |
| 1991 | 1 |
| 1992 | 3 |
| 1993 | 6 |
| 1994 | 2 |
| 1995 | 6 |
| 1996 | 2 |
| 1997 | 1 |
| 1998 | 4 |
| 1999 | 4 |
| 2000 | 6 |
| 2001 | 2 |
| 2002 | 3 |
| 2003 | 3 |
| 2004 | 2 |
| 2005 | 1 |
| 2006 | 2 |
| 2007 | 4 |
| 2009 | 1 |
| 2010 | 3 |
| 2011 | 2 |
| 2012 | 3 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 3 |
| 2016 | 3 |
| 2018 | 2 |
| 2020 | 1 |
| 2022 | 2 |
| 2023 | 2 |
| 2024 | 1 |
| 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\") = 2002
AND c.\"eventStateOrRegion\" = 'MO' 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") = 2002
AND c."eventStateOrRegion" = 'MO' 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 CHI03LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Cuba, MOThe pilots inadequate flare and recovery from a bounced landing. Contributing factors to this accident were the crosswind and the ditch.NTSB CHI02CA296Accident · No injuriesData collectionFinal reportRobinson R-22 · Maryland Height, MODynamic rollover due to the flight instructor's improper control inputs and the flight instructor's unsuccessful remedial actions. A contributing factor is the passenger's inadvertent movement of the cyclic control.NTSB CHI02LA205Accident · Serious injuriesLimited investigationFinal reportPiper PA28-140 · El Dorado Sprgs, MOThe failure by the flight crew to abort the takeoff, as well as a failure by the flight instructor to properly monitor takeoff performance. Contributing factors to the accident were the flight crew's failure to calculate required takeoff distance, considering…