NTSB investigations: Lycoming 0-540 series, 1982, MO
2 cases on aircraft whose registry engine model is Lycoming 0-540 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 | 2 |
|---|---|
| 1965 | 5 |
| 1966 | 5 |
| 1967 | 8 |
| 1968 | 1 |
| 1969 | 3 |
| 1970 | 2 |
| 1971 | 1 |
| 1972 | 4 |
| 1973 | 1 |
| 1974 | 2 |
| 1976 | 2 |
| 1977 | 1 |
| 1978 | 3 |
| 1979 | 1 |
| 1980 | 1 |
| 1981 | 2 |
| 1982 | 2 |
| 1983 | 3 |
| 1984 | 1 |
| 1985 | 1 |
| 1988 | 2 |
| 1989 | 1 |
| 1993 | 2 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2001 | 2 |
| 2004 | 1 |
| 2005 | 1 |
| 2008 | 1 |
| 2010 | 1 |
| 2011 | 2 |
| 2012 | 1 |
| 2013 | 3 |
| 2016 | 2 |
| 2017 | 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\") = 1982
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 ('41532'))
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."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 ('41532'))
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 MKC82DA154Accident · No injuriesFinal reportPiper PA-25-235 · Fisk, MOThe pilot was taking off from a small ag strip when his left wing went into milo growing beside the strip. Subsequently, the aircraft spun around and flipped over. This was the pilot's tenth takeoff on that day. He reported that the wind was from the…NTSB MKC82DA026Accident · No injuriesFinal reportPiper PA-24-250 · Liberty, MOThe instructor pilot reported encountering wind shear at about 12 to 15 ft AGL during a short field landing on runway 19. She stated that there were several obstructions that could create a wind effect. The surface wind was from the northeast at five knots.…