NTSB investigations: Continental IO-550 series
13 cases on aircraft whose registry engine model is Continental IO-550 series, where the first occurrence was “In flight encounter with weather”. 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
| 2001 | 1 |
|---|---|
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 4 |
| 2005 | 3 |
| 2006 | 3 |
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.\"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\" = 240))
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."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" = 240))
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 LAX07FA021Accident · 4 fatalField investigationFinal reportCirrus SR22 · Meadview, AZThe pilot's inadequate weather evaluation and continued flight into forecasted icing conditions. Contributing to the severity of the accident was the pilot's failure to follow proper operating procedures and deploy the CAPS when the airplane entered a spin.…NTSB ANC06LA119Accident · Serious injuriesLimited investigationFinal reportCessna U206G · Whittier, AKThe pilot's continued VFR flight into instrument meteorological conditions, which resulted in a collision with terrain while maneuvering to reverse direction in a pass. A factor contributing to the accident was clouds in the pass.NTSB ATL06LA035Accident · No injuriesLimited investigationFinal reportCirrus SR22 · Childersburg, ALThe pilot's inadequate preflight planning, failure to obtain a current weather briefing, and his decision to operate the airplane into a known area of icing outside the airplanes certification standards resulting in the aircraft accumulating ice, a loss of…NTSB ATL06FA029Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Sylva, NCThe pilot's continued VFR flight into IMC conditions resulting in a collision with mountainous terrain.NTSB CHI06FA043Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Arco, MNThe pilot's inadvertent cruise flight into instrument meteorological conditions, and his failure to maintain control of the aircraft after experiencing spatial disorientation. Factors associated with the accident are the pilot's improper planning/decision…NTSB LAX05FA088Accident · 1 fatalField investigationFinal reportCirrus Design SR22 G2 · Norden, CAthe pilot's in-flight loss of control following an inadvertent encounter with unforecast severe icing conditions. A factor in the accident was the inaccurate icing forecast developed by the NWS Aviation Weather Center.NTSB CHI05FA020Accident · 3 fatalField investigationFinal reportBeech A36 · Downing, MOThe pilot not maintaing airplane control during cruise flight. Factors present were night and thunderstorm conditions.NTSB FTW04CA177Accident · No injuriesData collectionFinal reportMooney M20R · Kerrville, TXThe pilot's failure to compensate for existing wind conditions. Contributing factors were the gusty high winds.NTSB CHI04LA129Accident · 3 fatalLimited investigationFinal reportHall Lancair IV-P · Vermontville, MIThe failure of Air Route Traffic Control Center controllers to provide adverse weather avoidance assistance as required by FAA directives, which led to the airplane's encounter with a thunderstorm and subsequent loss of control. Contributing to the accident…NTSB ATL04LA097Accident · 1 fatalLimited investigationFinal reportDurr Lancair Legacy · Oakland, TNThe pilot loss control of the airplane when he continued flight into known thunderstorm and convective activity. A factor is insufficient information provided by ATC personnel.NTSB ATL03LA094Accident · 4 fatalLimited investigationFinal reportKerner Lancair IV · Allendale, SCThe pilot's inadvertent flight into adverse weather ,thunderstorms, that resulted in the design limits of the airplane being exceeded.NTSB LAX02FA278Accident · 1 fatalField investigationFinal reportBeech A36 · Grand Canyon, AZthe pilot's inadequate in-flight planning/decision and his failure to maintain adequate airspeed which resulted in an encounter with adverse weather conditions and the loss of control due to a stall. Contributing factors were thunderstorm related turbulence,…NTSB DEN01FA070Accident · 4 fatalField investigationFinal reportBeech A36 · Jackson Hole, WYthe pilot's continued VFR flight into instrument meteorological conditions which resulted in an inflight collision with terrain during cruise flight. Factors were the pilot's inadequate preflight planning in that he failed to familiarize himself with the…