NTSB investigations: Continental IO-520 series, 2001
6 cases on aircraft whose registry engine model is Continental IO-520 series, where the first occurrence was “In flight collision with terrain/water”. 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 | 18 |
|---|---|
| 1983 | 18 |
| 1984 | 4 |
| 1985 | 6 |
| 1986 | 6 |
| 1987 | 2 |
| 1988 | 6 |
| 1989 | 1 |
| 1990 | 3 |
| 1991 | 6 |
| 1992 | 4 |
| 1993 | 6 |
| 1994 | 2 |
| 1995 | 3 |
| 1996 | 2 |
| 1997 | 7 |
| 1998 | 4 |
| 1999 | 6 |
| 2000 | 2 |
| 2001 | 6 |
| 2002 | 7 |
| 2003 | 6 |
| 2004 | 3 |
| 2005 | 8 |
| 2006 | 3 |
| 2007 | 5 |
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\") = 2001
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\" = 230))
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") = 2001
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" = 230))
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 CHI02FA009Accident · 1 fatalField investigationFinal reportBeech 58 · Dubuque, IAThe pilot continued flight into known adverse weather and disregarded the minimum descent altitude. Additional factors were the conditions conducive to pilot fatigue, fog, and night.NTSB ANC01LA147Accident · No injuriesLimited investigationFinal reportCessna 206 · Galena, AKThe pilot's inadequate preflight planning and preparation for takeoff from an off-airport, short field site. Factors associated with the accident are a variable wind, and the pilot's inadequate weather evaluation.NTSB SEA01FA167Accident · 3 fatalField investigationFinal reportBeech 58 · Ashland, ORThe pilot's failure to maintain clearance from the terrain after inadvertently entering an area of instrument meteorological conditions (IMC) during a visual flight rules (VFR) flight. Factors include mountainous/hilly terrain and low ceilings in the area…NTSB LAX01FA279Accident · 2 fatalField investigationFinal reportBeech F-33A · Mobile, AZThe flying pilot's initiation of an intentional maneuver at an altitude inadequate to maintain terrain clearance. Low altitude flight was a contributing factor.NTSB ANC01LA070Accident · No injuriesLimited investigationFinal reportCessna 207A · Deadhorse, AKThe pilot's failure to maintain altitude/clearance while maneuvering. Factors associated with the accident were flat light conditions, and snow-covered terrain.NTSB DEN01FA064Accident · 3 fatalField investigationFinal reportBeech V35 · Wendover, UTThe pilot flying at an altitude insufficient to clear surrounding terrain. Contributing factors were the pilot becoming lost/disoriented, his subsequent spatial disorientation, and dark night conditions.