NTSB investigations: Continental IO-520 series, 2007
5 cases on aircraft whose registry engine model is Continental IO-520 series, where the first occurrence was “In flight collision with object”. 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
| 1982 | 8 |
|---|---|
| 1983 | 10 |
| 1984 | 3 |
| 1985 | 8 |
| 1986 | 7 |
| 1987 | 4 |
| 1988 | 4 |
| 1989 | 7 |
| 1990 | 5 |
| 1991 | 3 |
| 1992 | 12 |
| 1993 | 5 |
| 1994 | 4 |
| 1995 | 4 |
| 1996 | 7 |
| 1997 | 3 |
| 1998 | 4 |
| 1999 | 7 |
| 2000 | 6 |
| 2001 | 7 |
| 2002 | 4 |
| 2003 | 7 |
| 2004 | 5 |
| 2005 | 5 |
| 2006 | 6 |
| 2007 | 5 |
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\") = 2007
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220))
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") = 2007
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220))
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 DFW07CA181Accident · Serious injuriesData collectionFinal reportCessna A188B · Garden City, TXThe pilot's failure to maintain clearance with the ground equipment while maneuvering. A contributing factor was the power lines along the pilot's application path.NTSB CHI07CA218Accident · No injuriesData collectionFinal reportCessna 188A · New Hartford, MOThe pilot's failure to maintain clearance from the tree line during the turn between aerial application passes. The low altitude, the downdraft encountered by the pilot, and the trees were contributing factors.NTSB CHI07CA180Accident · Minor injuriesData collectionFinal reportCessna 188B · Wyaconda, MOThe pilot's failure to maintain clearance from the trees. A factor in the accident was the trees.NTSB MIA07LA081Accident · 2 fatalLimited investigationFinal reportCessna U206G · Welaka, FLThe pilot's continued visual flight into instrument meteorological conditions and his failure to maintain clearance from utility poles. Contributing to the accident were the fog and haze.NTSB NYC07FA056Accident · 1 fatalField investigationFinal reportBeech A36 · Wayne, NJThe pilot's failure to comply with the published instrument approach procedure, which resulted in controlled flight into terrain.