NTSB investigations: Lycoming 0-320 series, 1988, VT
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 | 1 |
|---|---|
| 1967 | 2 |
| 1968 | 1 |
| 1969 | 2 |
| 1970 | 2 |
| 1971 | 2 |
| 1972 | 2 |
| 1973 | 1 |
| 1976 | 3 |
| 1977 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1982 | 1 |
| 1988 | 3 |
| 1989 | 1 |
| 1991 | 1 |
| 1998 | 1 |
| 2002 | 1 |
| 2004 | 1 |
| 2009 | 1 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 1 |
| 2016 | 1 |
| 2018 | 2 |
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\") = 1988
AND c.\"eventStateOrRegion\" = 'VT' 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" = 'VT' 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 NYC88FA202Accident · 2 fatalField investigationFinal reportCessna 172P · Post Mills, VTThe plt flew the acft to an arpt with two turf rwys. Rwy 5/23 was 2300' long & rwy 4/22 was 2600' long. After attending a meeting which ended at 1600 EDT, the plt elected to wait until later in the day to takeoff after the air had cooled. Subsequently, he…NTSB NYC88LA111Accident · Minor injuriesLimited investigationFinal reportBeech 23 · Rutland, VTPrior to leaving the aircraft to hand prop the engine, the pilot checked the throttle setting and set the brakes. He told his passenger (his wife) to pull back on the throttle when the engine started, however she was unable to do so and the aircraft began…NTSB NYC88LA098Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · West Dover, VTThe PA-28 landed short of the runway and struck a snowbank receiving substantial damage. The pilot when interviewed by the FAA said the engine did not miss and wasn't cutting out and that he would have to 'take the majority of the blame'. On NTSB form 6120.1,…