NTSB investigations: Continental 0-200 series

370 cases on aircraft whose registry engine model is Continental 0-200 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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\" = 353))
  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 MIA02LA028Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Stuart, FLThe pilot's improper fuel consumption calculations resulting in a loss of engine power due to fuel exhaustion and collision with trees during a forced landing.Nov 20, 2001 · N590AM · Substantial damageNTSB LAX01LA289Accident · No injuriesLimited investigationFinal reportCessna 150J · Sonoma, CAFuel exhaustion due to the pilot's inadequate preflight fuel consumption calculations and failure to ensure that adequate fuel was onboard the airplane prior to departure. A factor in the accident was the pilot's continued use of the airplane with known…Sep 5, 2001 · N51256 · Substantial damageNTSB IAD01LA098Accident · No injuriesLimited investigationFinal reportCessna 150M · Cincinnati, OHThe pilot's inadequate preflight planning which resulted in fuel exhaustion and subsequent loss of engine power.Aug 15, 2001 · N704SE · Substantial damageNTSB LAX01TA233Accident · No injuriesFinal reportCessna 150 · Delano, CAA bent mixture control valve stem shaft in the carburetor which made pilot control of the mixture inoperative resulting in excessive fuel consumption, and subsequent loss of engine power..Jul 3, 2001 · N6475T · Substantial damageNTSB ANC01LA074Accident · Serious injuriesLimited investigationFinal reportCessna 150D · Soldotna, AKThe loss of engine power due to fuel exhaustion and the pilot's failure to refuel the airplane.Jun 26, 2001 · N73CC · Substantial damageNTSB LAX01LA213Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Burbank, CAFuel exhaustion while maneuvering during a banner tow flight due to an inadequate fuel supply. A factor was the pilot's improper preflight preparation.Jun 17, 2001 · N3937U · Substantial damageNTSB LAX01LA192Accident · No injuriesLimited investigationFinal reportCessna 150H · Mariposa, CAThe pilot's failure to properly refuel the aircraft which resulted in departure with an inadequate quantity of fuel onboard. A factor in the accident was the pilot's inadequate preflight preparation and planning, which failed to provide an adequate fuel…May 25, 2001 · N23474 · Substantial damageNTSB FTW01LA099Accident · No injuriesLimited investigationFinal reportCessna 150L · Iowa Park, TXfuel exhaustion during takeoff due to the pilot's failure to refuel.Apr 12, 2001 · N19045 · Substantial damageNTSB FTW01LA093Accident · No injuriesLimited investigationFinal reportEmpson F4UCorsair · Baton Rouge, LAthe pilot's inadequate preflight planning resulting in fuel exhaustion during approach. A contributing factor was the lack of suitable terrain for the forced landing.Apr 5, 2001 · N914DA · Substantial damageNTSB IAD01LA037Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Huntington, WVThe pilot's inadequate preflight inspection, which resulted in residual fuel contamination and a subsequent engine failure. Factors included corroded fuel filler necks and rain the previous evening.Mar 14, 2001 · N6584F · Substantial damageNTSB CHI01LA068Accident · No injuriesLimited investigationFinal reportCessna 150G · La Rose, ILthe pilot's inadequate airplane preflight and the snow covered terrain. A factor was the fuel exhaustion.Jan 18, 2001 · N6281S · Substantial damageNTSB CHI01LA053Accident · No injuriesLimited investigationFinal reportCessna 150M · New Underwood, SDThe pilot's inadequate planning and preparation, which resulted in fuel exhaustion. A factor relating to this accident was the plowed field.Dec 26, 2000 · N63067 · Substantial damageNTSB FTW01LA028Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Valley Spring, TXthe loss of engine power due to fuel exhaustion after the pilot became lost during cruise flight. A contributing factor was the dark night condition.Nov 27, 2000 · N18609 · Substantial damageNTSB SEA01LA010Accident · No injuriesLimited investigationFinal reportCessna 150C · Sunnyslope, WAThe pilot's decision not to deviate to an alternate airport for fuel after encountering strong headwinds, resulting in fuel exhaustion. Factors contributing to the accident were the unfavorable winds and the sign impacted during the forced landing rollout.Oct 28, 2000 · N7886Z · Substantial damageNTSB NYC01LA003Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Haverford Twp., PAA loss of engine power due to fuel exhaustion. Also causal was the pilot's inability to locate the airport. A factor in this accident was the dark night conditions.Oct 5, 2000 · N704ST · Substantial damageNTSB FTW01LA001Accident · No injuriesLimited investigationFinal reportCessna 150L · Nashville, ARThe pilot's failure to refuel resulting in loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.Oct 1, 2000 · N11390 · Substantial damageNTSB LAX00LA332Accident · No injuriesLimited investigationFinal reportCessna 120 · Sacramento, CAThe pilot's inadequate preflight planning and his improper use of carburetor heat that resulted in a loss of engine power due to carburetor icing following a delayed takeoff in conditions that were conducive to carburetor icing. A factor was the nonsuitable…Sep 9, 2000 · N76261 · Substantial damageNTSB NYC00LA235Accident · No injuriesLimited investigationFinal reportCessna 150F · Friendly, MDThe pilot's inability to locate the airport, which resulted in fuel exhaustion. A factor related to the accident was the night light conditions.Aug 22, 2000 · N8709G · Substantial damageNTSB LAX00LA290Accident · No injuriesLimited investigationFinal reportCessna 150H · Corona, CAThe student pilot's inadequate preflight planning which included improper fuel consumption calculations that led to fuel exhaustion and loss of engine power during takeoff.Aug 9, 2000 · N7011S · Substantial damageNTSB CHI00LA241Accident · No injuriesLimited investigationFinal reportCessna 150 · Eastport, MIthe maneuver, performed by the pilot, to avoid obstructions on highway US.31. Factors were the carburetor icing weather condition, no suitable terrain conditions, the ground terrain condition, and the impacted fence.Aug 4, 2000 · N6712F · Substantial damageNTSB SEA00LA122Accident · No injuriesLimited investigationFinal reportCessna 150L · Nampa, IDThe pilot's improper use of the mixture control.Jul 3, 2000 · N6875G · Substantial damageNTSB CHI00LA159Accident · No injuriesLimited investigationFinal reportCessna 150M · Bethalto, ILthe improper in-flight decision of the pilot to fly past the Vandalia airport onto Saint Louis Regional and the fuel exhaustion. A factor was the ditch.Jun 11, 2000 · N66081 · DestroyedNTSB MIA00LA162Accident · No injuriesLimited investigationFinal reportCessna A150M · Gainesville, GAThe pilot's failure to use proper soft field landing technique while attempting a forced landing to an open field following a loss of engine power which resulted in a hard landing. Factors in the accident were weather conditions conducive to formation of…May 18, 2000 · N9834J · Substantial damageNTSB FTW00LA092Accident · No injuriesLimited investigationFinal reportCessna 150K · Davis, OKFuel exhaustion due to the student pilot becoming lost/disoriented. A factor was the lack of suitable terrain for the forced landing.Mar 11, 2000 · N8435M · Substantial damageNTSB SEA00LA045Accident · No injuriesLimited investigationFinal reportCessna 150H · Spangle, WAExhaustion of the fuel supply due to a leaking fuel tank system. Factors contributing to the accident were, inaccurate fuel quantity sensors, the lack of suitable terrain in the area of the forced landing, and a fence alongside the dirt upon which the pilot…Feb 18, 2000 · N50348 · Substantial damageNTSB LAX00LA037Accident · No injuriesLimited investigationFinal reportCessna 150K · Phoenix, AZFuel exhaustion due to the pilot's improper preflight planning, and failure to ensure that an adequate fuel supply was onboard the airplane.Nov 19, 1999 · N6199G · Substantial damageNTSB FTW00LA034Accident · No injuriesLimited investigationFinal reportCessna 150M · Carrolton, TXThe pilot's failure to refuel, which resulted in fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.Nov 19, 1999 · N63077 · Substantial damageNTSB NYC00LA030Accident · No injuriesLimited investigationFinal reportCessna 150 · New Hope, PAThe pilot's failure to identify during the preflight that both fuel vents were blocked, resulting in a total loss of engine power.Nov 9, 1999 · N8323G · Substantial damageNTSB SEA00LA008Accident · No injuriesLimited investigationFinal reportCessna 150B · Sweet Home, ORCarburetor heat was not used prior to takeoff. Carburetor icing conditions and high vegetation were factors.Oct 23, 1999 · N1252Y · Substantial damageNTSB FTW99LA257Accident · No injuriesLimited investigationFinal reportCessna 150J · Frisco, TXFuel exhaustion due to the pilot's inadequate preflight and his failure to refuel the airplane. A factor was the lack of suitable terrain for the forced landing.Sep 13, 1999 · N50495 · Substantial damageNTSB FTW99LA233Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Zachary, LAThe total loss of engine power due to fuel exhaustion resulting from the pilot's failure to refuel and his disorientation. Factors were the dusk light conditions and the lack of suitable terrain for the forced landing.Aug 22, 1999 · N6243R · Substantial damageNTSB NYC99LA167Accident · No injuriesLimited investigationFinal reportCessna 150 · Woodstock, VAThe pilot's failure to adequately calculate required fuel for the flight, which resulted in a total loss of engine power.Jul 6, 1999 · N22600 · Substantial damageNTSB LAX99LA183Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Lucerne Valley, CAthe pilot's failure to refuel the airplane and improper fuel consumption calculations.May 12, 1999 · N66487 · Substantial damageNTSB MIA99LA112Accident · No injuriesLimited investigationFinal reportCessna 15OF · Columbia, SCThe pilots failure to maintain a visual lookout during a forced landing to a highway. This resulted in the left main landing gear colliding with a rain grate separating the left main landing gear. Contributing to the accident was a total loss of engine power…Mar 24, 1999 · N8397G · Substantial damageNTSB CHI99LA081Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Paxton, ILthe inadequate preflight planning by the pilot in command and the exhaustion of usable fuel. Factors were the tailwind landing condition and the rough terrain at the landing site.Feb 3, 1999 · N704BF · Substantial damageNTSB FTW98LA268Accident · No injuriesLimited investigationFinal reportCessna 150L · Taft, TXThe pilot's failure to ensure that there was adequate fuel for the planned flight on board the airplane during the preflight inspection which resulted in a loss of engine power due to fuel exhaustion. A factor was the pilot's misjudgment of the glide distance…Jun 13, 1998 · N10519 · Substantial damageNTSB NYC98LA116Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Blakeslee, PAThe pilot's inadequate preflight resulting in fuel exhaustion. A factor was the pilot's failure to refuel the aircraft prior to departing.May 24, 1998 · N6562G · Substantial damageNTSB CHI98LA138Accident · No injuriesLimited investigationFinal reportCessna 150H · Benton, KSthe pilot's failure to assure an adequate fuel supply to complete the flight by refueling the airplane en route resulting in fuel exhaustion. A factor was the hedgerow which was contacted during the landing and the dark night conditions.May 3, 1998 · N6977S · Substantial damageNTSB FTW98FA024Accident · 1 fatalField investigationFinal reportCessna 150M · Deming, NMThe loss of engine power due to fuel contamination. Contributing was unsuitable terrain consisting of high vegetation and sand.Oct 20, 1997 · N6206K · DestroyedNTSB LAX98LA016Accident · No injuriesLimited investigationFinal reportCessna 150 · Temple Bar, AZthe pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power. A factor relating to the accident was: the terrain condition (ditch) in the emergency landing area.Oct 13, 1997 · N71VL · Substantial damageNTSB LAX97LA322Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Hilo, HIfailure of the pilot to verify the quantity of fuel before departure, and to monitor fuel consumption during the flight, which led to fuel exhaustion, loss of engine power, and a forced landing. Tall grass in the emergency landing was a related factor.Sep 12, 1997 · N18503 · Substantial damageNTSB CHI97LA276Accident · No injuriesLimited investigationFinal reportCessna 150J · Romeo, MIthe pilot's improper use of carburetor heat, which resulted in carburetor ice and loss of engine power. Factors relating to the accident were: carburetor icing conditions, and the crop (corn) in the emergency landing area.Aug 31, 1997 · N60200 · Substantial damageNTSB FTW97LA303Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Los Alamos, NMThe fuel exhaustion due to the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.Aug 10, 1997 · N22286 · Substantial damageNTSB LAX97LA278Accident · No injuriesLimited investigationFinal reportCessna 150G · Palos Verdes, CALoss of engine power due to fuel starvation and the pilot's mismanagement of the aircraft's fuel supply.Aug 9, 1997 · N3084S · Substantial damageNTSB NYC97LA161Accident · No injuriesLimited investigationFinal reportCessna A150L · Waynesburg, PAthe pilot's inadequate preflight by failing to ensure there was adequate fuel on board, which resulted in fuel exhaustion during takeoff.Aug 6, 1997 · N23JR · Substantial damageNTSB FTW97LA290Accident · No injuriesLimited investigationFinal reportCessna A150K · Elgin, OKfuel contamination, and the pilot's inadequate preflight of the airplane. Trees in the emergency landing area were considered a related factor.Jul 30, 1997 · N8332M · Substantial damageNTSB NYC97LA111Accident · No injuriesLimited investigationFinal reportCessna 150K · Jay, MEthe pilot's inaccurate fuel consumption calculations which resulted in fuel exhaustion.Jun 8, 1997 · N6218G · Substantial damageNTSB MIA97LA121Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Miami, FLThe student pilot's inadequate preflight planning and improper fuel consumption calculations which resulted in fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.Apr 6, 1997 · N50918 · Substantial damageNTSB NYC97LA070Accident · No injuriesLimited investigationFinal reportCessna 150E · Wolfeboro, NHThe pilot's improper preflight, and failure to refuel the airplane, which resulted in fuel exhaustion during the initial climb after takeoff, and the subsequent forced landing and collision with a mound of dirt.Apr 5, 1997 · N6106T · Substantial damageNTSB IAD97LA056Accident · No injuriesLimited investigationFinal reportCessna 150 · Pittsburgh, PAthe student pilot inadvertently became lost/disoriented during a cross-country flight, and failed to use his radio for assistance, which led to fuel exhaustion, loss of engine power, and a forced landing.Apr 2, 1997 · N3616J · Substantial damage