NTSB investigations: Continental 0-200 series
68 cases on aircraft whose registry engine model is Continental 0-200 series, where the defining event 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
| 2008 | 1 |
|---|---|
| 2009 | 7 |
| 2010 | 2 |
| 2011 | 8 |
| 2012 | 8 |
| 2013 | 5 |
| 2014 | 2 |
| 2015 | 7 |
| 2016 | 1 |
| 2017 | 3 |
| 2018 | 2 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 3 |
| 2022 | 3 |
| 2023 | 8 |
| 2024 | 3 |
| 2025 | 1 |
| 2026 | 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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17020')
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\" = '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 ('17020')
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" = '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 CEN26LA299Accident · No injuriesClass 4 · LimitedInvestigation openCessna 150M · Greenwood, ILNTSB ERA26LA131Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Okeechobee, FLThe pilot’s failure to maintain airplane control during takeoff, which resulted in a runway excursion and collision with terrain.NTSB CEN25LA147Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Zeeland, MIThe flight instructor’s failure to maintain control of the airplane during the go-around which led to the airplane exceeding its critical angle-of-attack and entering an aerodynamic stall at a low altitude. Contributing to the accident was the flight…NTSB CEN24LA297Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Castroville, TXThe pilot’s inadequate recovery from a bounced landing and his failure to maintain proper airplane pitch control and airspeed during the go-around, which resulted in the airplane exceeding its critical angle-of-attack and an aerodynamic stall at a low…NTSB CEN24FA188Accident · 1 fatalClass 3 · FieldFinal reportCessna 150L · Godley, TXThe student pilot’s failure to maintain airplane control while practicing a power-on stall, which resulted in an inadvertent spin at an altitude from which he was unable to recover.NTSB ERA24LA182Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150L · Sussex, NJThe student pilot’s failure to maintain airplane control during a go-around attempt in a gusting left crosswind, resulting in an aerodynamic stall and collision with terrain.NTSB ERA23LA371Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150G · Cross Keys, NJThe pilot’s failure to maintain adequate airspeed during the banner pickup, which resulted in a low altitude aerodynamic stall/spin.NTSB WPR23LA335Accident · No injuriesClass 4 · LimitedFinal reportCessna 150M · Marble Canyon, AZThe pilot’s loss of airplane control after an encounter with windshear during takeoff which resulted in collision with terrain.NTSB WPR23FA323Accident · 1 fatalClass 3 · FieldFinal reportHensler Howard Cassutt · West Jordan, UTA loss of control during the initial climb for reasons that could not be determined.NTSB CEN23FA352Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · Caddo Mills, TXThe pilot’s loss of airplane control during an attempted forced landing following a loss of engine power.NTSB CEN23FA315Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · Houston, TXThe student pilot’s loss of airplane control in dark night conditions.NTSB CEN23LA191Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150F · Genoa, ILThe pilot’s failure to maintain airplane control during a go-around.NTSB ERA23LA169Accident · No injuriesClass 4 · LimitedFinal reportCessna 150H · Mattituck, NYThe pilot’s failure to maintain control of the airplane during the landing, which resulted in a hard landing and runway excursion.NTSB CEN23FA077Accident · 2 fatalClass 3 · FieldFinal reportCessna 150H · Auburn, NEThe flight instructor’s failure to maintain control after a loss of engine power due to carburetor icing while maneuvering for forced landing in dark night visual meteorological conditions.NTSB CEN23LA004Accident · Minor injuriesClass 4 · LimitedFinal reportTaylorcraft F19 · Waconia, MNThe pilot's failure to maintain aircraft control during a touch-and-go landing.NTSB ANC22LA032Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D · Wasilla, AKThe pilot's failure to maintain a proper glidepath while on final approach to landing which resulted in an impact with a snow berm and a nose over.NTSB CEN22FA109Accident · 1 fatalClass 3 · FieldFinal reportChristavia MK1 · Oral, SDThe noncertificated pilot’s failure to maintain control of the airplane, which led to the airplane exceeding its critical angle-of-attack and subsequent aerodynamic stall. Contributing to the accident was the pilot’s decision to attempt a flight with no…NTSB ERA22FA056Accident · 1 fatalClass 3 · FieldFinal reportZenith CH601 · Oak Hill, FLA loss of airplane control while maneuvering at low altitude.NTSB CEN21LA335Accident · No injuriesClass 3 · LimitedFinal reportCessna 150F · Rock Falls, ILThe right seat pilot’s improper decision to perform a low approach with full flaps and the failure of the flaps to retract during the attempted go-around, which resulted in a forced landing.NTSB ERA21FA258Accident · 2 fatalClass 3 · FieldFinal reportCessna 150 · Yulee, FLThe flight instructor’s decision to conduct slow flight training at an altitude below the flight school’s minimum recovery altitude and his delayed remedial action when an aerodynamic stall occurred.NTSB CEN20FA108Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · Port Isabel, TXThe pilot’s loss of control during the initial takeoff climb for reasons that could not be determined based on available evidence.NTSB ANC19LA015Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Talkeetna, AKA loss of pitch control for an undetermined reason, which resulted in a collision with terrain during an emergency landing.NTSB CEN18LA205Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Union, ILThe pilot’s medical impairment at the time of the accident, which resulted in a collision with power lines off the end of the runway.NTSB GAA18CA235Accident · No injuriesData collectionFinal reportCessna 150 · Statesville, NCThe pilot’s failure to maintain crosswind correction during landing and the flight instructor’s delayed remedial action. Contributing to the accident was the pilot’s and flight instructor’s decision to land with gusting tailwinds.NTSB CEN18LA015Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Willmar, MNThe pilot’s improper conduct of the soft-field takeoff, which led to his failure to attain adequate airspeed, and the flight instructor’s subsequent improper landing flare, which resulted in a hard, forced landing.NTSB ERA17FA330Accident · 1 fatalField investigationFinal reportCessna 150G · Rhine, GAThe student pilot's decision to take off from a partially-lit grass runway in dark night, marginal visual flight rules conditions, which resulted in spatial disorientation, an exceedance of the airplane's critical angle of attack, and an aerodynamic stall.NTSB WPR17FA118Accident · 1 fatalField investigationFinal reportCessna 150M · Banning, CAThe flight instructor's decision to continue the takeoff in gusting tailwind and high density altitude conditions, which significantly reduced airplane performance, and his subsequent exceedance of the airplane's critical angle of attack during the initial…NTSB GAA16CA198Accident · No injuriesData collectionFinal reportCessna 150 · Sterling City, TXThe pilot's failure to establish a climb and maintain directional control during takeoff in quartering tailwind conditions, which resulted in a loss of directional control, aborted takeoff, collision with a wire fence, and nose over.NTSB GAA16CA033Accident · No injuriesData collectionFinal reportCessna 150 · Millbrook, NYThe pilot's loss of heading control during the go-around in gusty crosswind conditions, which resulted in a collision with trees.NTSB ANC16FA001Accident · 1 fatalField investigationFinal reportCessna 150F · Big Lake, AKThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack while maneuvering, which resulted in a stall at too low an altitude to allow recovery.NTSB ERA15FA352Accident · 1 fatalField investigationFinal reportCessna 150 · Atco, NJThe student pilot's improper decision to intentionally maneuver at low altitude while waving to people on the ground, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.NTSB GAA15CA216Accident · No injuriesData collectionFinal reportCessna 150M · Ellijay, GAThe pilot's failure to attain and maintain sufficient airspeed during takeoff which resulted in a descent, loss of directional control, and a runway excursion.NTSB CEN15FA307Accident · 4 fatalField investigationFinal reportCessna T310R · Cody, WYThe pilot's loss of airplane control following the loss of power in the left engine; the reason for the loss of power could not be determined during postaccident engine examination.NTSB GAA15CA077Accident · No injuriesData collectionFinal reportCessna 150M · Wellington, KSThe student pilot's improper flare and loss of control which resulted in a hard landing.NTSB ERA15CA101Accident · No injuriesData collectionFinal reportCessna 150L · Stow, MAThe flight instructor's delayed remedial action in response to the student pilot's improper go-around, which resulted in the airplane exceeding its critical angle of attack, experiencing an aerodynamic stall, and impacting a parked airplane.NTSB ERA14FA387Accident · 2 fatalField investigationFinal reportCessna 150 · Mount Pleasant, SCThe commercial pilot’s exceedance of the airplane’s critical angle-of-attack during the initial climb, which resulted in an aerodynamic stall and impact with terrain. Contributing to the commercial pilot’s failure to recognize and remediate the stall were his…NTSB WPR14CA204Accident · No injuriesData collectionFinal reportCessna 150C · Wellington, NVThe pilot's failure to maintain aircraft control while departing from a wet runway.NTSB ERA14CA065Accident · No injuriesData collectionFinal reportCessna 150D · Portland, METhe failure of the pilot to maintain directional control during landing.NTSB WPR14CA016Accident · No injuriesData collectionFinal reportChampion 7ECA · Willows, CAThe pilot's failure to maintain sufficient altitude while flying low over a field which resulted in a loss of aircraft control and collision with terrain.NTSB ERA13CA383Accident · No injuriesData collectionFinal reportCessna 150L · Chestertown, MDThe student pilot's improper control inputs which resulted in a loss of control and aerodynamic stall. Contributing to the accident was the flight instructor's delayed remedial action.NTSB ANC13FA084Accident · 2 fatalField investigationFinal reportCessna 150L · Anchorage, AKA loss of engine power due to fuel starvation as a result of a low fuel state and a nose-high attitude during a go-around, which unported the fuel tank feed line, and the pilot's decision to make a low-altitude turn back to the airport, which resulted in an…NTSB WPR13CA170Accident · No injuriesData collectionFinal reportDiamond DA 20-C1 · Provo, UTThe student pilot’s failure to maintain airspeed and airplane control during an attempted go-around.NTSB CEN13CA087Accident · No injuriesData collectionFinal reportCessna 150F · Red Oak, IAThe loss of control while landing due to the solo student pilot's delay to execute a go-around and his improper control inputs during a bounced landing.NTSB ERA13CA051Accident · No injuriesData collectionFinal reportCessna 150L · Seneca Falls, NYThe pilot’s inadequate compensation for wind conditions during landing, which resulted in an impact with a drainage ditch.NTSB ERA12FA583Accident · 2 fatalField investigationFinal reportCessna 150M · Fredericksburg, VAThe pilot's failure to maintain airplane control during initial climb. Contributing to the accident was the pilot's impairment due to alcohol.NTSB CEN12LA552Accident · Serious injuriesLimited investigationFinal reportCessna A150L · Tribune, KSThe pilot's failure to maintain clearance from a corn crop.NTSB ERA12CA390Accident · No injuriesData collectionFinal reportCessna 150H · Alabaster, ALThe pilot's failure to maintain directional control while landing in gusting wind conditions.NTSB ANC12LA031Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Fairbanks, AKThe student pilot did not control the airplane’s pitch attitude, which resulted in an aerodynamic stall during the takeoff initial climb. Contributing to the accident was the pilot’s failure to use the pre-takeoff checklist.NTSB ERA12FA151Accident · 1 fatalField investigationFinal reportCessna 150G · Quincy, FLThe non-instrument-rated pilot’s spatial disorientation in night instrument meteorological conditions, which resulted in his inability to maintain controlled flight. Contributing to the accident was the pilot’s improper decision to take off in deteriorating…NTSB CEN12LA133Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Denmark, WIThe pilot’s loss of control due to his alcohol impairment. Contributing to the accident was the pilot's decision to fly at night with a known interior lighting malfunction.