Skip to content

NTSB investigations: Cessna 150L, KS

29 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" = 'KS' 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\" = 'KS' 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" = 'KS' 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 CHI01LA196Accident · No injuriesLimited investigationFinal reportCessna 150L · Randolph, KSThe unsuitable terrain encountered by the pilot during the forced landing. Factors to the accident were the loss of engine power for undetermined reasons and the rough/uneven terrain condition.Jun 27, 2001 · N5272Q · Substantial damage NTSB CHI99LA250Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Udall, KSthe failure of maintenance personnel to properly safety the aileron control cable during installation, the disconnected aileron control cable, and the unavailability of aileron control to the pilot.Jul 23, 1999 · N6726G · Substantial damage NTSB CHI99LA138Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Bonner Springs, KSthe pilot's failure to obtain sufficient altitude during the aborted landing to clear obstacles at the end of the field. Factors associated with the accident were poor preflight planning/preparation, the tailwind, the telephone pole, and the trees.May 2, 1999 · N11143 · Substantial damage NTSB CHI96LA112Accident · No injuriesLimited investigationFinal reportCessna 150 · Howard, KSthe student pilot's failure to obtain timely assistance after encountering adverse weather during a cross-country flight which led to fuel exhaustion.Mar 17, 1996 · N1532Q · Substantial damage NTSB CHI92LA178Accident · No injuriesLimited investigationFinal reportCessna 150L · Colby, KSA jammed exhaust valve in the number one cylinder of the engine assembly.Jun 15, 1992 · N19317 · Substantial damage NTSB CHI92LA149Accident · No injuriesLimited investigationFinal reportCessna 150 · Olathe, KSThe student pilot's improper recovery from a bounced landing, and the instructor's inadequate remedial action(s).May 13, 1992 · N1668Q · Substantial damage NTSB MKC85LA050Accident · No injuriesLimited investigationFinal reportCessna 150L · Beloit, KSThe student pilot stated he was practicing touch and go landings on rwy 35. After touchdown, the airplane veered left, hit a snowbank off the side of the runway & flipped forward to the inverted position. Winds were from 300 degrees at 5 knots, gusting to 10…Jan 23, 1985 · N10894 · Substantial damage NTSB MKC84LA085Accident · No injuriesLimited investigationFinal reportCessna 150L · Ft Riley, KSThe student plt stated he landed hard, bounced and impacted the rwy again, collapsing the nose gear.Feb 25, 1984 · N10144 · Substantial damage NTSB MKC83FA069Accident · 1 fatalField investigationFinal reportCessna 150L · Ellsworth, KSThe pilot departed red cloud, NE for a VFR, no-flight-plan flight to kingman, KS. Witnesses reported an aircraft flying in flight conditions that appeared to deteriorate from a weather stand standpoint in the direction of flight. One witness stated that he…Feb 21, 1983 · N18204 · Destroyed NTSB MKC80FCG46Accident · No injuriesClosedCessna 150 · Desoto, KSSep 8, 1980 · N5452Q · Substantial damage NTSB MKC80FCQ22Accident · Minor injuriesClosedCessna 150L · Mcpherson, KSJun 24, 1980 · N11319 · Destroyed NTSB MKC80DCG12Accident · No injuriesClosedCessna 150 · Sabetha, KSFeb 11, 1980 · N7191G · Substantial damage NTSB MKC79FCG70Accident · No injuriesClosedCessna 150L · Bonner Springs, KSAug 9, 1979 · N19030 · Substantial damage NTSB MKC78FCQ02Accident · No injuriesClosedCessna 150 · Emporia, KSOct 27, 1977 · N10996 · Substantial damage NTSB MKC77DCQ51Accident · No injuriesClosedCessna 150 · Greensburg, KSAug 8, 1977 · N11619 · Substantial damage NTSB MKC77DCQ38Accident · Minor injuriesClosedCessna 150 · Maize, KSMay 29, 1977 · N11550 · Substantial damage NTSB MKC77DCQ21Accident · No injuriesClosedCessna 150 · Manhattan, KSMar 7, 1977 · N16014 · Substantial damage NTSB MKC76DCQ72Accident · No injuriesClosedCessna 150 · Clyde, KSAug 7, 1976 · N19443 · Substantial damage NTSB MKC76DCQ68Accident · No injuriesClosedCessna 150 · Flush, KSAug 1, 1976 · N19380 · Substantial damage NTSB MKC76DCQ60Accident · No injuriesClosedCessna 150 · Colby, KSJun 9, 1976 · N16025 · Substantial damage NTSB MKC76DCG57Accident · No injuriesClosedCessna 150L · Lawrence, KSMar 16, 1976 · N6095J · Substantial damage NTSB MKC76DCQ15Accident · No injuriesClosedCessna 150 · Council Grove, KSSep 7, 1975 · N6095J · Substantial damage NTSB MKC75FCG47Accident · Minor injuriesClosedCessna 150 · Kansas City, KSMay 24, 1975 · N18600 · Destroyed NTSB MKC75DCQ39Accident · Minor injuriesClosedCessna 150 · Colby, KSApr 5, 1975 · N10916 · Destroyed NTSB MKC75FCQ38Accident · No injuriesClosedCessna 150 · Pratt, KSMar 20, 1975 · N11139 · Substantial damage NTSB MKC74DCG19Accident · No injuriesClosedCessna 150 · Lawrence, KSJan 16, 1974 · N6095J · Substantial damage NTSB MKC74DCG16Accident · No injuriesClosedCessna 150L · Pleasanton, KSDec 18, 1973 · N18640 · Substantial damage NTSB MKC72FCQ52Accident · Minor injuriesClosedCessna 150L · Augusta, KSMay 13, 1972 · N1662Q · Substantial damage NTSB MKC72DCQ37Accident · No injuriesClosedCessna 150L · Clay Center, KSDec 16, 1971 · N1248Q · Substantial damage