Skip to content

NTSB investigations: Cessna 150L, MO

40 cases on aircraft the registry lists as Cessna 150L. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19712026

Where

Latest cases

Query with SQL

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."eventStateOrRegion" = 'MO' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071826')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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.\"eventStateOrRegion\" = 'MO' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071826'))
  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."eventStateOrRegion" = 'MO' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071826'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 CEN09CA092Accident · No injuriesData collectionFinal reportCessna 150 · Auxvasse, MOthe pilot's improper engine recovery procedures after a power-off stall which resulted in a loss of engine power. Contributing factors were the pilot's improper off-field landing procedures, and the lack of suitable terrain for the forced landing.Dec 5, 2008 · N1521Q · Substantial damage NTSB CHI96LA297Accident · No injuriesLimited investigationFinal reportCessna 150 · Columbia, MOthe improper recovery from a bounced landing by the pilot in command. Factors were the gusty wind conditions, and the failure of the pilot to maintain aircraft control.Aug 14, 1996 · N10645 · Substantial damage NTSB CHI96LA244Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Versailles, MOthe student pilot's failure to maintain airplane control during a go-around.Jul 16, 1996 · N11303 · Substantial damage NTSB CHI96LA128Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Sikeston, MOThe pilot's delay in applying carburetor heat, which resulted in carburetor icing and subsequent loss of engine power. Factors relating to the accident were: carburetor icing (weather) conditions, and the pilot's lack of recent experience in the make and…Apr 9, 1996 · N6689G · Substantial damage NTSB CHI95LA173Accident · Minor injuriesLimited investigationFinal reportCessna 150L · St. Charles, MOthe student pilot's inadvertent interference with flight controls which resulted in a stall. A factor associated with the accident was the student's excessive use of the elevator control.Jun 7, 1995 · N6605G · Substantial damage NTSB CHI94LA183Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Bolivar, MOThe partial blockage of the carburetor's induction air opening by a plastic bag.May 31, 1994 · N11286 · Substantial damage NTSB CHI93LA168Accident · No injuriesLimited investigationFinal reportCessna 150L · Washington, MOThe pilot's failure to maintain proper runway alignment.May 13, 1993 · N10011 · Substantial damage NTSB CHI93FA042Accident · 2 fatalField investigationFinal reportCessna 150L · Waldron, MOThe pilot's failure to maintain aircraft control.Nov 28, 1992 · N18528 · Destroyed NTSB CHI92LA001Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Taylor, MOThe pilot-in-command's failure to attain proper compensation for the crosswind. A factor contributing to the accident was the crosswind.Oct 2, 1991 · N11540 · Substantial damage NTSB CHI91LA079Accident · No injuriesLimited investigationFinal reportCessna 150 · Chesterfield, MODirectional control was not maintained by the pilot. Factors related to the accident were: a lack of total experience by the pilot and the presence of a snowbank adjacent to the runway.Jan 20, 1991 · N5363Q · Substantial damage NTSB CHI90LA207Accident · No injuriesLimited investigationFinal reportAircoupe F-1 · Washington, MOFailure of the other aircraft's pilot to maintain an adequate visual lookout prior to turning to final. A factor in the accident was the restricted visual lookout for this aircraft's pilot.Jul 23, 1990 · N93905 · 2 aircraft · Minor damage NTSB CHI90LA179Accident · No injuriesLimited investigationFinal reportCessna 150 · Columbia, MOInadequate visual outlook by the PIC.Jul 20, 1990 · N16088 · Substantial damage NTSB MKC89LA097Accident · No injuriesLimited investigationFinal reportCessna 150 · Creve Couer, MOThe pilot's misjudgement of altitude and distance to the runway, and his failure to attain the proper touchdown point for landing. A factor related to the accident was: the soft/uneven terrain short of the runway.Apr 22, 1989 · N19220 · Substantial damage NTSB MKC87LA117Accident · No injuriesLimited investigationFinal reportCessna 150L · East Lynne, MOThe PIC had been practicing t&g lndgs for the previous hour or so and decided to stop briefly to wait out rain showers in the area. After waiting the PIC fueled the acft with 10 gal of avn fuel and taxied to the active rwy to return to his originating arpt.…Jun 20, 1987 · N17297 · Substantial damage NTSB MKC85FA175Accident · Serious injuriesField investigationFinal reportCessna 150L · Lee'S Summit, MOThe plt discharged one passenger without stopping the eng & motioned to the next passenger (his wife) to come around from the front of the airplane. Subsequently, his wife walked into the propeller & received a serious injury to her arm.Jul 20, 1985 · N11152 · No damage NTSB MKC85LA023Accident · No injuriesLimited investigationFinal reportCessna 150L · Joplin, MOPlt departed with estimated 16 gals of fuel on board for brief flight. Approaching arpt for landing, engine lost power. Plt set up for forced lndg in open field. Acft overran available open space and collided with brush. Plt stated acft had been modified for…Nov 20, 1984 · N6584G · Substantial damage NTSB MKC84LA267Accident · No injuriesLimited investigationFinal reportCessna 150L · Marshall, MOThe acft engine lost power while descending after 1 hr of flt. During the ensueing forced lndg the plt said he changed his selection of landing site because of an auto on the selected site (a highway). The acft was landed beside the road &a collision with a…Sep 1, 1984 · N16220 · Substantial damage NTSB MKC84LA039Accident · No injuriesLimited investigationFinal reportCessna 150 · Clinton, MOThe plt took off from pleasant hill, MO to look for relatives who may have been survivors of an overturned boat. After searching a lake, he elected to land at Clinton, MO. The arpt at Clinton was closed for construction & the rwy was covered with snow & ice.…Dec 17, 1983 · N17297 · Substantial damage NTSB MKC81DCG38Accident · No injuriesClosedCessna 150L · Tiff City, MOJun 7, 1981 · N11542 · Substantial damage NTSB MKC81FCG34Accident · No injuriesClosedCessna 150L · Booneville, MOMay 11, 1981 · N10795 · Substantial damage NTSB MKC79DCG72Accident · No injuriesClosedCessna 150 · Odessa, MOAug 19, 1979 · N16025 · Substantial damage NTSB MKC79DCG18Accident · No injuriesClosedCessna 150 · Butler, MOJan 12, 1979 · N1236Q · Substantial damage NTSB MKC78FCA40Accident · Minor injuriesClosedCessna 150 · St Charles, MOJul 29, 1978 · N19552 · Substantial damage NTSB MKC78FCG46Accident · No injuriesClosedCessna 150 · Richmond, MOJul 6, 1978 · N11013 · Substantial damage NTSB MKC77FCG18Accident · No injuriesClosedCessna 150L · Springfield, MOApr 8, 1977 · N19275 · Substantial damage NTSB MKC76DCG81Accident · No injuriesClosedCessna 150 · Springfield, MOJun 26, 1976 · N10107 · Substantial damage NTSB MKC76DCG44Accident · No injuriesClosedCessna 150 · Springfield, MOJan 14, 1976 · N7731G · Substantial damage NTSB MKC76FCG42Accident · No injuriesClosedCessna 150L · Point Lookout, MOJan 8, 1976 · N6552G · Substantial damage NTSB MKC76FCG35Accident · No injuriesClosedCessna 150L · Springfield, MONov 13, 1975 · N7286G · Substantial damage NTSB MKC76FCA13Accident · No injuriesClosedCessna 150L · Fenton, MOOct 19, 1975 · N10922 · Substantial damage NTSB MKC76DCA06Accident · No injuriesClosedCessna 150L · Festus, MOJul 31, 1975 · N19134 · Destroyed NTSB MKC75FCA24Accident · Minor injuriesClosedCessna 150L · Troy, MOApr 5, 1975 · N17255 · Substantial damage NTSB MKC75FCG34Accident · No injuriesClosedCessna 150 · Springfield, MOMar 13, 1975 · N7952G · Substantial damage NTSB MKC75DCA04Accident · No injuriesClosedCessna 150 · Chesterfield, MOJul 9, 1974 · N11952 · Substantial damage NTSB MKC75FCA05Accident · Serious injuriesClosedCessna 150L · Cuba, MOJul 3, 1974 · N10781 · Substantial damage NTSB MKC74FCA22Accident · No injuriesClosedCessna 150L · St Charles, MOJan 29, 1974 · N10681 · Substantial damage NTSB MKC73DCG34Accident · No injuriesClosedCessna 150 · Point Lookout, MOMar 22, 1973 · N1599Q · Substantial damage NTSB MKC72DCA31Accident · No injuriesClosedCessna 150 · Scott City, MOJun 15, 1972 · N1282Q · Substantial damage NTSB MKC72AK025Accident · 1 fatalClosedCessna 150L · Stover, MOOct 7, 1971 · N1600Q · Destroyed NTSB MKC71DCA36Accident · No injuriesClosedCessna 150 · Creve Couer, MOMay 28, 1971 · N6601G · Substantial damage