NTSB investigations: Continental IO-550 series
12 cases on aircraft whose registry engine model is Continental IO-550 series, where the defining event was Aerodynamic stall/spin. 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
| 2008 | 1 |
|---|---|
| 2010 | 1 |
| 2011 | 2 |
| 2012 | 1 |
| 2013 | 1 |
| 2017 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 2 |
| 2024 | 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 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_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '241'))
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_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '241'))
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 ERA24FA206Accident · 1 fatalClass 3 · FieldFinal reportRaytheon A36 · Augusta, GAThe pilot’s excessive turn rate and bank angle while at low airspeed and altitude, resulting in an accelerated aerodynamic stall, loss of airplane control, and collision with terrain.NTSB ERA22LA059Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Burnsville, NCThe pilot’s failure to compensate for the high density altitude and the tailwind component while landing at a mountaintop airport, which resulted in an aerodynamic stall and a loss of aircraft control.NTSB CEN21FA199Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Port Aransas, TXThe pilot’s failure to maintain adequate airspeed during the go-around, which resulted in the airplane exceeding its critical angle of attack and a subsequent aerodynamic stall.NTSB ANC20LA043Accident · Serious injuriesClass 3 · LimitedFinal reportCessna A185E · Eagle River, AKThe pilot’s failure to ensure adequate fuel onboard prior to the planned flight, resulting in a total loss of engine power due to fuel exhaustion and an aerodynamic stall during the subsequent emergency landing. Contributing to the accident was the pilot’s…NTSB WPR19FA212Accident · 2 fatalClass 3 · FieldFinal reportWheeler Express Series 2000 · Camarillo, CAThe pilot’s failure to maintain adequate airspeed on final approach, which resulted in exceedance of the airplane’s critical angle of attack and an aerodynamic stall at an altitude that precluded recovery.NTSB CEN17FA084Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · San Antonio, TXThe pilot's uncoordinated flight control inputs and subsequent inadvertent cross-control aerodynamic stall in the airport traffic pattern that resulted in a loss of control and uncontrolled descent with insufficient altitude for recovery.NTSB ERA13LA252Accident · No injuriesLimited investigationFinal reportBeech A36 · Atlanta, GAThe pilot's inadequate preflight planning, which resulted in the airplane being loaded in excess of its maximum gross weight at an aft center of gravity for a takeoff with a quartering tailwind and high-density altitude conditions, all of which degraded the…NTSB WPR12LA410Accident · 1 fatalLimited investigationFinal reportSchoepflin DA-4-550 · Viola, IDThe pilot's failure to maintain airplane control while maneuvering, resulting in an aerodynamic stall/spin with insufficient altitude to recover.NTSB ERA11CA460Accident · No injuriesData collectionFinal reportMooney M20R · West Chester, PAThe pilot did not maintain adequate airspeed during a go-around, which resulted in an aerodynamic stall.NTSB CEN11LA373Accident · No injuriesLimited investigationFinal reportMooney M20R · Lake In The Hills, ILThe pilot's improper landing flare and recovery from a bounced landing, which resulted in a loss of control. Contributing to the accident was the certified flight instructor’s inadequate supervision.NTSB ERA10FA259Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Tuscaloosa, ALThe pilot's failure to maintain adequate airspeed while maneuvering to land, which resulted in an aerodynamic stall/spin and collision with the ground.NTSB ERA09FA053Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Tallahassee, FLThe pilot's failure to maintain adequate airspeed on final approach, which resulted in a low-altitude aerodynamic stall and spin. Contributing to the accident was the pilot's failure to fly the published instrument approach and his subsequent failure to…