NTSB investigations: Continental IO-520 series, NH
9 cases on aircraft whose registry engine model is Continental IO-520 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
| 1966 | 1 |
|---|---|
| 1967 | 1 |
| 1969 | 1 |
| 1976 | 1 |
| 1980 | 1 |
| 1982 | 1 |
| 2012 | 1 |
| 2013 | 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 c.\"eventStateOrRegion\" = 'NH' 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 ('17032'))
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" = 'NH' 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 ('17032'))
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 ERA25LA128Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Alton Bay, NHThe pilot’s failure to maintain an appropriate glide path during the landing approach, which resulted in in the airplane contacting a snowbank short of the runway.NTSB ERA13CA416Accident · No injuriesData collectionFinal reportCessna U206F · Rumney, NHThe pilot's failure to ensure that the amphibious airplane's landing gear was properly configured for a landing on water and his failure to properly configure the airplane during the attempted go-around.NTSB ERA13FA039Accident · 2 fatalField investigationFinal reportBeech A36 · Hooksett, NHThe pilot's total incapacitation in flight due to an acute heart attack.NTSB NYC82DA140Accident · No injuriesFinal reportCessna U206 · Nelson, NHThe pilot of the float equipped aircraft stated that during takeoff, there was a loss of power and lift. He tried to turn and land; however, the plane crashed into the lake and was destroyed. The pilot and passengers evacuated without injury.NTSB NYC80FNC36Accident · Minor injuriesClosedBeech A36 · Laconia, NHNTSB NYC76DNC35Accident · No injuriesClosedCessna 206 · N Wolfeboro, NHNTSB NYC70F0173Accident · No injuriesClosedMeyers 200D · Alstead, NHNTSB NYC68F0290Accident · No injuriesClosedBeech S35 · Nashua, NHNTSB NYC67D0242Accident · No injuriesClosedCessna 210 · Nashua, NH