NTSB investigations: Lycoming IO-720 series, 1982
3 cases on aircraft whose registry engine model is Lycoming IO-720 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 | 1 |
| 1966 | 4 |
| 1967 | 2 |
| 1968 | 2 |
| 1970 | 3 |
| 1971 | 2 |
| 1972 | 1 |
| 1974 | 4 |
| 1975 | 4 |
| 1976 | 1 |
| 1977 | 4 |
| 1978 | 1 |
| 1979 | 2 |
| 1980 | 1 |
| 1981 | 1 |
| 1982 | 3 |
| 1984 | 2 |
| 1985 | 2 |
| 1986 | 3 |
| 1987 | 3 |
| 1988 | 1 |
| 1989 | 2 |
| 1990 | 2 |
| 1991 | 3 |
| 1992 | 1 |
| 1996 | 2 |
| 1997 | 3 |
| 1998 | 1 |
| 2000 | 1 |
| 2003 | 2 |
| 2004 | 3 |
| 2005 | 2 |
| 2007 | 2 |
| 2008 | 2 |
| 2009 | 1 |
| 2010 | 3 |
| 2011 | 1 |
| 2013 | 1 |
| 2019 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 1 |
| 2026 | 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\") = 1982
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41546'))
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") = 1982
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41546'))
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 MIA82DA183Accident · No injuriesFinal reportPiper PA-36-375 · Astatula, FLThe plt stated the acft failed to become airborne at the usual takeoff point & did not climb when forced into the air. The acft then settled into soft sand.NTSB FTW82FRJ12Accident · 1 fatalFinal reportPiper PA-36-375 · Wildsville, LAThe pilot took off on a local flight to spray a bean field. About 1000 ft from the end of the field was a 300 ft radio tower. The aircraft was observed to circle the bean field and circle the radio tower twice. During a procedure turn, the aircraft struck the…NTSB FTW82FQG15Accident · 1 fatalFinal reportPiper PA-36 · Floydada, TXThe aircraft crashed about 500 ft north of the field that was being sprayed. After impact, it traveled about 90 ft on a heading of 060 degrees. Green glass fragments were found at the initial impact point as well as propeller slash marks that were nearby. No…