NTSB investigations: Lycoming IO-320 series, PA
19 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 | 1 |
| 1966 | 3 |
| 1967 | 2 |
| 1969 | 1 |
| 1970 | 1 |
| 1971 | 2 |
| 1972 | 2 |
| 1980 | 1 |
| 1984 | 1 |
| 2008 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2023 | 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 c.\"eventStateOrRegion\" = 'PA' 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 c."eventStateOrRegion" = 'PA' 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 ERA23FA270Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-30 · Ebensburg, PAThe pilot’s spatial disorientation and subsequent loss of airplane control, which resulted in an uncontrolled descent and collision with terrain.NTSB ERA14LA133Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Allentown, PAThe flight instructor’s failure to maintain directional control during the landing.NTSB ERA14FA077Accident · 2 fatalField investigationFinal reportPiper PA-30 · Biglerville, PAThe noninstrument-rated pilot's spatial disorientation after inadvertently encountering instrument meteorological conditions at night and his subsequent loss of airplane control.NTSB ERA09LA098Accident · Minor injuriesLimited investigationFinal reportHess John L Spezio II · Newville, PAA loss of engine power due to carburetor ice as a result of the pilot's delayed use of carburetor heat.NTSB NYC84LA210Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Mahaffey, PAThe acft veered off the prepared landing area in tall weeds and rocks where it nosed over. The plt had changed from a gravel rwy to the dirt one because of downdrafts. The 1st landing on the dirt rwy was made on the wheels and when the tail lowered the plt…NTSB NYC80FGM12Accident · No injuriesClosedPiper PA-30 · Waynesburg, PANTSB NYC73FHD17Accident · No injuriesClosedPiper PA-30 · Philadelphia, PANTSB NYC73FHA03Accident · No injuriesClosedChampion 7KCAB · Kutztown, PANTSB NYC72FHD15Accident · No injuriesClosedPiper PA-39 · Ambler, PANTSB NYC71DHG09Accident · No injuriesClosedPiper PA-30 · Hershey, PANTSB NYC70IN119Incident · No injuriesClosedPiper PA-30 · State College, PANTSB NYC69D0287Accident · No injuriesClosedPiper PA-30 · Toughkenamon, PANTSB NYC68F0049Accident · No injuriesClosedPiper PA-30 · Selinsgrove, PANTSB NYC67F0583Accident · No injuriesClosedPiper PA-30 · Allentown, PANTSB NYC67F0326Accident · No injuriesClosedPiper PA-30 · Morrisville, PANTSB NYC67D0158Accident · No injuriesClosedPiper PA-30 · Philadelphia, PANTSB NYC66F0478Accident · No injuriesClosedPiper PA-28 · Friedens, PANTSB UNK65X1271Accident · No injuriesClosedPiper PA30 · Reading, PANTSB UNK65X0119Accident · No injuriesClosedPiper PA30 · Reading, PA