NTSB investigations: Continental IO-550 series, 2002
6 cases on aircraft whose registry engine model is Continental IO-550 series, where the first occurrence was “Loss of control - in flight”. 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
| 1986 | 1 |
|---|---|
| 1991 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 2001 | 3 |
| 2002 | 6 |
| 2003 | 4 |
| 2004 | 3 |
| 2005 | 5 |
| 2006 | 6 |
| 2007 | 2 |
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\") = 2002
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17042')
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\" = 250))
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") = 2002
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17042')
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" = 250))
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 MIA03FA025Accident · 2 fatalField investigationFinal reportRaytheon 58 · Fort Myers, FLthe pilot's spatial disorientation during instrument meteorological conditions, which resulted in his failure to maintain aircraft control. Contributing factors included the pilot's distraction to the low fuel status and the low cloud conditions.NTSB NYC03LA019Accident · 2 fatalLimited investigationFinal reportMooney M20R · Vineyard Haven, MAThe pilot's spatial disorientation during a missed approach, which resulted in a loss of control, and the airplane's subsequent impact with water. Factors included clouds, rain, and night lighting conditions.NTSB ATL02FA171Accident · 2 fatalField investigationFinal reportMooney M20R · Burnsville, NCThe pilot's failure to maintain airspeed during final approach, which resulted in an inadvertent stall and uncontrolled descent into trees and terrain. Factors were wind gusts and terrain-induced turbulence.NTSB MIA02LA125Accident · No injuriesLimited investigationFinal reportMooney M20R · Mt. Pleasant, SCThe pilot's failure to maintain airspeed resulting in a stall, an uncontrolled descent, and an impact with the ground during the attempted go-around.NTSB ATL02LA100Accident · 2 fatalLimited investigationFinal reportTaber Lancair Super ES · Hattiesburg, MSThe pilot's failure to maintain airspeed during takeoff which resulted in an inadvertent stall and subsequent collision with the ground.NTSB NYC02FA089Accident · 2 fatalField investigationFinal reportCirrus SR-22 · Parish, NYThe pilots' failure to maintain airspeed, which resulted in an inadvertent stall/spin. The continued spin to the ground was a result of the pilots' failure to deploy the onboard parachute recovery system, for undetermined reasons.