NTSB investigations: Lycoming IO-320 series, 1986, FL
3 cases on aircraft whose registry engine model is Lycoming IO-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 | 1 |
|---|---|
| 1965 | 2 |
| 1966 | 2 |
| 1967 | 4 |
| 1969 | 1 |
| 1970 | 2 |
| 1971 | 2 |
| 1972 | 4 |
| 1973 | 4 |
| 1974 | 4 |
| 1976 | 1 |
| 1977 | 3 |
| 1978 | 3 |
| 1980 | 3 |
| 1982 | 4 |
| 1983 | 2 |
| 1984 | 3 |
| 1985 | 1 |
| 1986 | 3 |
| 1988 | 1 |
| 1989 | 2 |
| 1990 | 2 |
| 1995 | 2 |
| 1997 | 1 |
| 1999 | 2 |
| 2000 | 2 |
| 2002 | 3 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2007 | 3 |
| 2009 | 1 |
| 2011 | 2 |
| 2013 | 1 |
| 2015 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2021 | 1 |
| 2023 | 1 |
| 2025 | 1 |
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\") = 1986
AND c.\"eventStateOrRegion\" = 'FL' 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 ('41509'))
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") = 1986
AND c."eventStateOrRegion" = 'FL' 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 ('41509'))
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 MIA87LA028Accident · No injuriesLimited investigationFinal reportGlasair Glasair · Ft. Lauderdale, FLThe plt stated that while in the pattern, the engine started to run rough and then quit. He attempted to return to the runway, but the aircraft crashed into trees about one mile from the airport. No reason was found for the loss of power as described by the…NTSB MIA86LA141Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · New Smyrna Bch, FLDuring a pickup of an aerial advertising banner the acft struck the pickup bridle with the left main landing gear. He stated that he was unable to climb. The acft then stalled and crashed along the arpt boundary in a swamp.NTSB MIA86LA090Accident · Minor injuriesLimited investigationFinal reportBellanca 7KCAB · New Smyrna Bch, FLThe plt stated that just after picking up a banner, the acft stalled and started to roll to the left. The plt was unable to recover before the acft impacted the ground.