NTSB investigations: Continental 0-200 series
6,416 cases on aircraft whose registry engine model is Continental 0-200 series. 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, newest first
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'))
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'))
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 CHI03LA126Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Cedar Springs, MIThe pilot's inadequate glidepath and his failure to maintain obstacle clearance. A factor to the accident was the semi-trailer.NTSB ATL03LA096Accident · No injuriesLimited investigationFinal reportCessna 150G · Morris, ALThe pilot's selection of unsuitable terrain for a precautionary landing, which resulted in a ground collision with terrain, and subsequent collapse of the nose gear.NTSB ATL03LA086Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Montgomery, ALThe in-flight collision with birds that resulted in a partial loss of engine power, and subsequent in-flight collision with trees while maneuvering for an emergency landing.NTSB NYC03LA090Accident · 1 fatalLimited investigationFinal reportStarnes Quickie Q-200 · Henderson, KYThe pilot's improper recovery from a bounced landing and his failure to maintain directional control, after experiencing an in-flight loss of control for undetermined reasons.NTSB ATL03LA083Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Trenton, TNThe pilot's loss of control in flight and failure to maintain adequate airspeed which resulted in a stall, and subsequent collision with the ground.NTSB CHI03LA111Accident · No injuriesLimited investigationFinal reportCessna 150F · Three Rivers, MIThe directional control not maintained by the student pilot. The student pilot's lack of experience was a contributing factor.NTSB SEA03LA064Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Coos Bay, ORThe pilot's improper remedial action during takeoff and his failure to maintain airspeed. Contributing factors included the binding of the left brake and the trees.NTSB NYC03LA073Accident · No injuriesLimited investigationFinal reportCessna 150G · Medina, OHThe pilot's failure to follow published procedures while starting the engine, and his failure to maintain control of the airplane.NTSB ANC03LA033Accident · Serious injuriesLimited investigationFinal reportHughes Stol King · Seldovia, AKThe loss of engine power during initial climb for an undetermined reason, which resulted in a hard landing.NTSB FTW03LA109Accident · No injuriesLimited investigationFinal reportCessna 150G · Hope, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW03LA107Accident · No injuriesLimited investigationFinal reportCessna 150K · Sherman, TXThe flight instructor's failure to refuel the airplane which resulted in fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW03LA119Accident · No injuriesLimited investigationFinal reportCessna 150 · Pearland, TXThe pilot's failure to maintain runway alignment. Contributing factors were the pilot's diverted attention to the banner staging area, and the ditch.NTSB DEN03LA044Accident · No injuriesLimited investigationFinal reportCessna 150M · Gateway, COthe pilot's failure to maintain aircraft control. Contributing factors were the snow-covered runway.NTSB IAD03LA034Accident · No injuriesLimited investigationFinal reportCessna 150J · Williamson, NYThe pilot's failure to maintain proper runway alignment during the takeoff roll. A factor was the snow-covered runway.NTSB ATL03LA048Accident · No injuriesLimited investigationFinal reportCessna 150F · Rome, GAThe maintenance personnel failure to secure the throttle linkage during the installation of the carburetor that resulted in the loss of engine power.NTSB NYC03LA038Accident · No injuriesLimited investigationFinal reportCessna 150F · Crestline, OHThe pilot's improper decision to takeoff from unsuitable terrain. A factor related to the accident was the plowed, snow covered field.NTSB CHI03LA054Accident · No injuriesLimited investigationFinal reportCessna 150M · Charleston, MOthe inadequate flare by the pilot. Factors were the loose trim tab cable for undetermined reasons.NTSB MIA03CA041Accident · Serious injuriesData collectionFinal reportCessna 150K · Everglades City, FLThe instructor's failure to maintain airspeed during climb after lift off from an aborted landing, resulting in the airplane stalling, entering a spin, and crashing into water at the departure end of the runway. Contributing to the accident was the…NTSB CHI03LA049Accident · No injuriesLimited investigationFinal reportCessna 150J · Garner, IAThe students pilots improper in-flight fuel planning resulting in exhaustion of the fuel supply, and the collapse of the nose gear during the forced landing. Factors were unsuitable landing are encountered by the pilot, the plowed field and the fuel…NTSB MIA03LA044Accident · No injuriesLimited investigationFinal reportCessna 150K · Jessup, GAThe loss of engine power for undetermined reasons. A contributing factor was unsuitable terrain.NTSB MIA03CA030Accident · No injuriesData collectionFinal reportCessna A150M · Crystal River, FLThe student pilot's improper application of brakes during the landing rollout, which resulted in a loss of directional control and the airplane running off of the runway, impacting a runway light structure, and nosing over.NTSB ATL03FA023Accident · 2 fatalField investigationFinal reportCessna 150L · Arecibo, PRThe pilots failure to follow the normal takeoff checklist (Wing Flaps-Up) and failure to maintain airspeed after takeoff that resulted in an inadvertent stall.NTSB MIA03LA020Accident · No injuriesLimited investigationFinal reportCessna 150L · Powells Point, NCa loss of engine power for undetermined reason resulting in damage to the airplane during the subsequent forced landing.NTSB DEN03LA015Accident · No injuriesLimited investigationFinal reportCessna 150F · Logan, UTThe pilot's premature flare and his failure to maintain airspeed, resulting in a stall. A contributing factor was the dusk light conditions.NTSB LAX03FA025Accident · 1 fatalField investigationFinal reportCessna 150E · Anaheim Hills, CAthe pilot's continued VFR flight into instrument meteorological conditions and his subsequent failure to maintain clearance from power lines. A contributing factor was the pilot's impairment by medication.NTSB CHI03LA019Accident · Minor injuriesLimited investigationFinal reportCessna 150M · New Town, NDThe pilot's failure to maintain terrain clearance and his inadequate in-flight planning/decision. Contributing factors are the pilot becoming lost/disoriented and night conditions.NTSB LAX03FA008Accident · 1 fatalField investigationFinal reportCessna 150F · Julian, CAan in-flight loss of control for undetermined reasons.NTSB CHI02CA287Accident · No injuriesData collectionFinal reportCessna 150G · Dodge Center, MNThe pilot's misjudgment of distance resulting in an undershoot of the runway.NTSB FTW02LA248Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Deming, NMThe loss of engine power due to carburetor ice as a result of the pilot's failure to apply carburetor heat. A contributing factor was the weather conducive to carburetor icing conditions.NTSB NYC02LA180Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Louisa, VAA loss of engine power for an undetermined reason.NTSB ANC02LA120Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Gakona, AKThe pilot's failure to maintain directional control of the airplane, and his excessive use of the airplane's brakes during the landing roll, which resulted in the airplane nosing down. A contributing factor in the accident was wet, high grass along the runway…NTSB MIA02FA152Accident · 1 fatalField investigationFinal reportCessna 150J · Brunswick, GAthe pilot's failure to maintain an adequate airspeed during takeoff, which resulted in an inadvertent stall. A contributing factor was the pilot's decision to takeoff in an over gross weight condition.NTSB MIA02LA149Accident · No injuriesLimited investigationFinal reportCessna 150M · La Belle, FLThe student pilot's improper in-flight planning and failure to use carburetor heat while conditions existed that were conductive to carburetor icing.NTSB CHI02LA240Accident · No injuriesLimited investigationFinal reportCessna 150H · Dyersville, IAThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion and subsequent loss of engine power. A related factor was the bean field.NTSB ATL02LA152Accident · No injuriesLimited investigationFinal reportCessna 150 · Lakeland, FLThe pilot's failure to maintain a visual lookout while taxiing to parking resulting in an on-ground collision with a pole. A related factor was the diverted attention to the lineman.NTSB FTW02LA226Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Manvel, TXThe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI02LA241Accident · No injuriesLimited investigationFinal reportCessna 150 · Belleville, ILDirectional control not obtained/maintained by the pilot during landing.NTSB ATL02LA145Accident · No injuriesLimited investigationFinal reportCessna 150H · Senoia, GAThe certificated flight instructor's failure to follow published procedures for the application of carburetor heat, which resulted in a loss of engine power due to carburetor ice formation, and subsequent collision with trees during the forced landing. A…NTSB SEA02LA133Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Pe Ell, WAThe fatigue failure of the number two engine cylinder for undetermined reasons during cruise flight. Factors include high vegetation in the area where the pilot found it necessary to make a forced landing.NTSB DEN02LA079Accident · No injuriesLimited investigationFinal reportCessna 150F · Grants, NMthe pilot's inadequate preflight preparation, and his failure to maintain airspeed which resulted in an inadvertent stall. Contributing factors were the high density altitude conditions, the terrain barrier (berm).NTSB ATL02FA143Accident · 2 fatalField investigationFinal reportCessna 150G · Duncanville, ALThe pilot's failure to maintain airspeed , which resulted in an inadvertent stall, and subsequent collision with the ground. A contributing factor was low level flight.NTSB FTW02LA204Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Omaha, ARthe pilot's failure to maintain adequate airspeed during the go-around resulting in an inadvertent stall. A contributing factor was haze.NTSB CHI02CA191Accident · No injuriesData collectionFinal reportCessna 150H · Mecosta, MIThe airplane encountered unsuitable terrain and the pilot applied excessive braking during the aborted takeoff. A factor contributing to the accident was the sandy terrain.NTSB CHI02LA190Accident · No injuriesLimited investigationFinal reportCessna 150F · Ft. Wayne, INThe corroded throttle cable resulting in a loss of engine power. Factors were the inadequate annual inspection, the unsuitable terrain encountered during the forced landing, the ditch, and the fence.NTSB IAD02LA068Accident · No injuriesLimited investigationFinal reportCessna 150 · Griswold, CTthe pilot's improper pre-flight planning and decision to depart a field with insufficient runway. Factors were the rough/uneven terrain, high obstructions and the tailwind.NTSB MIA02LA124Accident · No injuriesLimited investigationFinal reportMckean Varieze · Covington, TNThe pilot's improper planned approach following loss of engine power due to fuel starvation resulting in damage to the airplane during an off-airport landing. Contributing to the accident was the pilot's lack of familiarity with the accident airplane.NTSB ANC02LA058Accident · Serious injuriesLimited investigationFinal reportCessna 150 · South Naknek, AKThe pilot's failure to refuel the airplane resulting in fuel exhaustion in cruise flight, and his inadvertently stalling the airplane during the ensuing emergency landing.NTSB NYC02LA114Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Seaman, OHThe pilot's failure to maintain airspeed during a precautionary landing, which resulted in an inadvertent stall/mush, and uncontrolled descent to the ground. A factor was the pilots' lack of recent experience.NTSB ANC02LA046Accident · No injuriesLimited investigationFinal reportCessna 150 · Hope, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a collision with a ditch. A contributing factor in the accident was the presence of a ditch in the landing area.NTSB FTW02LA174Accident · No injuriesLimited investigationFinal reportCessna 150 · Fort Worth, TXthe partial loss of engine power due to the mixture control rod separating from the carburetor. A contributing factor was the lack of suitable terrain for the forced landing.