NTSB investigations: Continental 0-200 series

164 cases on aircraft whose registry engine model is Continental 0-200 series, where the first occurrence was “Loss of engine power”. 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')
      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\" = 350))
  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.

NTSB CHI01LA170Accident · No injuriesLimited investigationFinal reportCessna 150L · Munster, INEngine failure during takeoff due to water contaminating the fuel, the pilot's inadequate preflight planning/preparation, and the low altitude. Factors relating to this accident were the attempted emergency landing after takeoff and the fence.Jun 17, 2001 · N6557G · Substantial damageNTSB NYC01LA149Accident · No injuriesLimited investigationFinal reportCessna 150 · Lincoln, MEA loss of engine power for an undetermined reason.Jun 14, 2001 · N1525Q · Substantial damageNTSB ATL01LA056Accident · No injuriesLimited investigationFinal reportCessna 150 · Griffin, GAThe pilot's inadequate preflight fuel planning for the flight that resulted in the fuel exhaustion and the subsequent loss of engine power.May 19, 2001 · N5854E · Substantial damageNTSB LAX01LA133Accident · No injuriesLimited investigationFinal reportCessna 150J · Fortuna, CALoss of engine power in cruise flight for undetermined reasons and subsequent forced landing in water.Mar 31, 2001 · N60051 · Substantial damageNTSB SEA01LA057Accident · No injuriesLimited investigationFinal reportCassutt II · Moses Lake, WAFailure of a wrist pin plug in the engine, resulting in partial blockage of the engine lubrication system and partial failure of the engine connecting rod bearings; and the pilot's subsequent failure to maintain adequate airspeed during a forced landing…Mar 4, 2001 · N1431 · Substantial damageNTSB ATL01LA028Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Concord, NCThe pilots failure to follow the auxiliary fuel tank procedures, which resulted in the fuel starvation and the loss of engine power.Feb 1, 2001 · N60336 · Substantial damageNTSB CHI01LA074Accident · No injuriesLimited investigationFinal reportCessna 150H · Burlington, WIAircraft control not maintained by the pilot during the landing roll. Factors to the accident were the loss of engine power for undetermined reasons, the end of the runway being snow-covered, and the snowbank.Jan 28, 2001 · N22026 · Substantial damageNTSB FTW01FA014Accident · 1 fatalField investigationFinal reportCessna 150L · Rockport, TXthe loss of engine power for undetermined reasons, and the pilot's subsequent failure to maintain control of the airplane during the ensuing forced landing.Oct 26, 2000 · N6968G · DestroyedNTSB CHI01LA029Accident · Minor injuriesLimited investigationFinal reportFowler Varieze · Iowa City, IAthe inadequate preflight by the pilot which resulted in the fuel drain remaining partially open. Factors to the accident were the loss of engine power due to fuel starvation, the partially open fuel drain, the unsuitable terrain for landing encountered by the…Oct 22, 2000 · N82JF · Substantial damageNTSB SEA00LA176Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Ontario, ORThe pilot-in-command/flight instructor's failure to adequately refuel the aircraft, resulting in fuel exhaustion, and his subsequent high flare in a forced landing attempt, resulting in a stall and touchdown/impact on the nose gear.Sep 13, 2000 · N22237 · Substantial damageNTSB FTW00LA248Accident · No injuriesLimited investigationFinal reportCessna 150F · Guthrie, OKThe partial loss of engine power due to undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Sep 4, 2000 · N8783S · Substantial damageNTSB CHI00LA260Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Chapin, ILthe pilot's failure to refuel the aircraft prior to the flight and exhaustion of the fuel supply. A factor to the accident was the embankment.Aug 17, 2000 · N304JF · Substantial damageNTSB ATL00LA045Accident · No injuriesLimited investigationFinal reportCessna 150 · Waycross, GAThe student pilot's inaccurate fuel consumption calculation that resulted in the total loss of engine power due to fuel exhaustion and the subsequent collision with a utility pole.Apr 22, 2000 · N60763 · Substantial damageNTSB LAX00LA081Accident · No injuriesLimited investigationFinal reportCessna 150F · Windsor, CAThe pilot's inadequate preflight planning in that he did not perform a fuel calculation, and his failure to verify the fuel quantity on board the airplane, which resulted in fuel exhaustion and subsequent collision with the ground.Jan 29, 2000 · N8281F · Substantial damageNTSB FTW00LA054Accident · No injuriesLimited investigationFinal reportCessna 150H · Sinton, TXThe pilot's failure to refuel the airplane, which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.Dec 27, 1999 · N7290S · Substantial damageNTSB CHI00LA046Accident · No injuriesLimited investigationFinal reportCessna 150B · Omaha, NEThe pilots failure to use carburetor heat during takeoff in weather conducive for serious carburetor ice. Factors were the weather that was conducive for carburetor icing and the presence of the truck that the aircraft impacted.Dec 14, 1999 · N7339X · Substantial damageNTSB MIA00LA022Accident · No injuriesLimited investigationFinal reportCessna 150M · Jacksonville, NCThe flight instructor's improper supervision of the student pilot during preflight and improper fuel management ensuring there was sufficient fuel for the planned flight. This resulted in a total loss of engine power due to fuel exhaustion.Nov 5, 1999 · N714RA · Substantial damageNTSB CHI99LA352Accident · No injuriesLimited investigationFinal reportCessna 150M · Lebanon, MOA loss of engine power due to a fractured shaft supporting the number three cylinder rocker arm. A factor relating to this accident was the trees.Sep 6, 1999 · N63668 · Substantial damageNTSB MIA99LA201Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Ormond Beach, FLa loss of engine power due to a stuck exhaust valve which resulted in a forced landing, the subsequent impact with the ground, and nose over.Jul 24, 1999 · N19222 · Substantial damageNTSB CHI99LA212Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Lyons, KSThe pilot's inadequate fuel management leading to fuel exhaustion.Jul 5, 1999 · N45078 · Substantial damageNTSB ATL99LA096Accident · No injuriesLimited investigationFinal reportRutan VERI-EZE · Enterprise, ALThe pilot's failure to remove covers from the fuel tank vent which resulted in fuel starvation.May 21, 1999 · N80SH · Substantial damageNTSB ANC99LA034Accident · No injuriesLimited investigationFinal reportCessna 150 · Fairbanks, AKThe loss of engine power for an undetermined reason.Mar 16, 1999 · N8620S · Substantial damageNTSB FTW99LA066Accident · No injuriesLimited investigationFinal reportCessna 150H · Conway, ARThe loss of engine power due to carburetor ice during the approach to land. A factor was the lack of suitable terrain for the forced landing.Jan 10, 1999 · N23303 · Substantial damageNTSB FTW99LA065Accident · No injuriesLimited investigationFinal reportCessna 150M · Madisonville, TXThe loss of engine power due to fuel exhaustion as result of the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.Jan 8, 1999 · N66464 · Substantial damageNTSB ATL99LA029Accident · No injuriesLimited investigationFinal reportCessna 150B · Adjuntas, PRThe loss of engine power due to the restricted movement of the intake and exhaust valves on number 3 cylinder.Dec 5, 1998 · N5957T · Substantial damageNTSB SEA98LA190Accident · No injuriesLimited investigationFinal reportCessna 150L · Bonners Ferry, IDImproper maintenance by an outsourcing facility which resulted in a lack of identification of scoring of the interior of the #3 cylinder rocker shaft bosses. The scoring resulted in a fatigue fracture and subsequent permanent closure of both intake and…Sep 29, 1998 · N19427 · Substantial damageNTSB CHI98LA267Accident · No injuriesLimited investigationFinal reportCessna 150M · Litchfield, ILLoss of engine power due to an open exhaust valve and low cylinder compression. A related factor was the tailwind.Jul 21, 1998 · N9251U · Substantial damageNTSB LAX98FA219Accident · Minor injuriesField investigationFinal reportCessna 150 · Apple Valley, CAThe improper installation of unvented fuel caps that resulted in fuel starvation and loss of engine power. A factor was the lack of suitable terrain for a forced landing.Jul 12, 1998 · N1706Q · Substantial damageNTSB MIA98LA189Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Perry, FLThe improper repair of the no. 2 engine cylinder, which resulted in the loss of engine power.Jun 27, 1998 · N2622J · Substantial damageNTSB FTW98LA204Accident · No injuriesLimited investigationFinal reportCessna 150 · Mentone, TXa partial loss of engine power for undetermined reasons, and the pilot's failure to maintain directional control during landing.Jun 2, 1998 · N6486T · Substantial damageNTSB CHI98LA185Accident · No injuriesLimited investigationFinal reportCessna 150M · Newton, KSthe pilot's inadequate preflight planning/preparation which led to fuel exhaustion and subsequent loss of engine power. Related factors were the pilot became disoriented and a dark night.Jun 1, 1998 · N714FB · Substantial damageNTSB ATL98LA033Accident · 1 fatalLimited investigationFinal reportCessna 150L · Guntersville, ALThe pilot's intentional shut down of the engine in flight that resulted in the total loss of engine power. A factor was the failure of both magnetos.Jan 18, 1998 · N7443G · Substantial damageNTSB SEA98LA022Accident · No injuriesLimited investigationFinal reportCessna 150J · Silverdale, WAIce accumulation in the carburetor throat. Factors include conditions conducive to serious carburetor icing, an inoperative starter due to a separated pull-to-start knob, and soft terrain at the location of the forced landing.Dec 10, 1997 · N51369 · Substantial damageNTSB MIA98LA030Accident · No injuriesLimited investigationFinal reportCessna 150M · Ormond Beach, FLa loss of engine power for undetermined reasons.Nov 13, 1997 · N6062K · Substantial damageNTSB SEA97LA124Accident · No injuriesLimited investigationFinal reportCessna 150H · Redmond, ORthe pilot's improper decision to depart on a flight without first ensuring the aircraft held sufficient fuel to reach his destination, which resulted in fuel exhaustion. Factors were the high vegetation and rocks at the location of the forced landing.Jun 1, 1997 · N50348 · Substantial damageNTSB NYC97FA043Accident · 2 fatalField investigationFinal reportCessna 150L · Collegeville, PAThe loss of engine power for undetermined reasons, and the pilot's failure to maintain adequate airspeed during the forced landing, which resulted in a stall and collision with the ground. A contributing factor was wind gusts.Jan 12, 1997 · N10809 · DestroyedNTSB ANC96LA151Accident · No injuriesLimited investigationFinal reportCessna 150 · Willow, AKThe loss of engine power for an undetermined reason. Factors associated with the accident are the soft terrain and brush in the airstrip overrun area.Sep 9, 1996 · N7909Z · Substantial damageNTSB IAD96LA065Accident · No injuriesLimited investigationFinal reportCessna 150H · Clinton, MDa loss of engine power for undetermined reasons.Apr 19, 1996 · N6508S · Substantial damageNTSB ANC96LA047Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Wasilla, AKA loss of engine power for an undetermined reason.Apr 14, 1996 · N50529 · DestroyedNTSB IAD96LA060Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Akron, OHa loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.Apr 12, 1996 · N16188 · Substantial damageNTSB ANC96LA031Accident · No injuriesLimited investigationFinal reportCessna 150H · Anchorage, AKloss of engine power for an undetermined reason.Mar 3, 1996 · N22053 · Substantial damageNTSB MIA96LA023Accident · No injuriesLimited investigationFinal reportCessna 150 · Saltillo, MSThe failure of the pilot-in-command to perform fuel comsumption calculations before and during the flight.Nov 13, 1995 · N61040 · Substantial damageNTSB NYC95LA228Accident · No injuriesLimited investigationFinal reportCessna 150M · Rutland, VTthe loss of engine power for an undetermined reason.Sep 28, 1995 · N9289U · Substantial damageNTSB ANC95LA105Accident · No injuriesLimited investigationFinal reportCessna 150 · Kalskag, AKThe loss of engine power for an undetermined reason.Jul 16, 1995 · N7892E · Substantial damageNTSB FTW95LA068Accident · No injuriesLimited investigationFinal reportCessna A150L · Newark, TXThe loss of engine power due to undetermined reasons. Factors were the dark night and lack of suitable terrain to execute a forced landing.Dec 18, 1994 · N6030J · Substantial damageNTSB NYC95LA006Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Farmington, MELoss of engine power for undetermined reasons.Oct 11, 1994 · N2450V · Substantial damageNTSB CHI94LA331Accident · No injuriesLimited investigationFinal reportCessna 150 · Winnetka, ILThe loss of engine power due to an undetermined reason. The lack of suitable terrain for the forced landing was a factor.Sep 17, 1994 · N9456U · Substantial damageNTSB LAX94LA324Accident · No injuriesLimited investigationFinal reportCessna 150M · Mettler, CAa loss of engine power due to inadequate and improper maintenance procedures and practices. A factor in the accident was the dark night lighting conditions which inhibited the pilot's ability to select a suitable forced landing area.Aug 16, 1994 · N714GV · Substantial damageNTSB BFO94LA081Accident · Serious injuriesLimited investigationFinal reportCessna 150K · Hollis, NHThe pilot's inadequate preflight inspection which failed to detect contaminated fuel which resulted in fuel starvation.Apr 30, 1994 · N5907G · Substantial damageNTSB BFO94LA012Accident · No injuriesLimited investigationFinal reportAngel Elbert S JR Quickie 200 · North Kingston, RILoss of engine power due to undetermined reasons.Nov 16, 1993 · N687EA · Destroyed