NTSB investigations: Continental IO-520 series, 1982, NJ
3 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
| 1965 | 1 |
|---|---|
| 1966 | 2 |
| 1967 | 1 |
| 1969 | 1 |
| 1972 | 1 |
| 1973 | 1 |
| 1977 | 2 |
| 1979 | 1 |
| 1982 | 3 |
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 2 |
| 1987 | 1 |
| 1990 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 2003 | 1 |
| 2006 | 1 |
| 2007 | 2 |
| 2008 | 1 |
| 2011 | 1 |
| 2014 | 1 |
| 2016 | 2 |
| 2017 | 1 |
| 2018 | 1 |
| 2021 | 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.\"eventStateOrRegion\" = 'NJ' 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 year(c."eventDate") = 1982
AND c."eventStateOrRegion" = 'NJ' 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 NYC83LA025Accident · No injuriesLimited investigationFinal reportCessna 210D · Morristown, NJPilot was flying with a mechanic to check avionics. Tower called to warn of helicopters. Mechanic asked him to change from right to left traffic. Pilot said the corrections disrupted his senses and he forgot to lower the landing gear.NTSB NYC82DA118Accident · No injuriesFinal reportBeech V35B · Toms River, NJDuring landing, the aircraft swerved off the left side of the runway and encountered soft terrain. The nose and left main landing gear were substantially damaged and there was minor damage to the right wing, flap, and aileron. The pilot reported that during…NTSB NYC82FHD12Accident · No injuriesFinal reportCessna 188A · Winslow, NJThe acft ran out of fuel while returning to the arpt. The acft landed into a plowed field & then on into an orchard.