Skip to content

NTSB investigations: Cessna 150L, CO

24 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" = 'CO' 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\" = 'CO' 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" = 'CO' 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 CEN23LA416Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Montrose, COThe pilot’s failure to maintain directional control during the landing roll with a gusting quartering headwind.Sep 21, 2023 · N5460Q · Substantial damage NTSB CEN11FA479Accident · 2 fatalField investigationFinal reportCessna 150L · Silverton, COThe pilot's failure to maintain control of the airplane while operating it at low levels above mountainous terrain and in excess of its maximum allowable gross weight, which resulted in an aerodynamic stall. The pilot's failure to maintain control resulted…Jul 14, 2011 · N1539Q · Substantial damage NTSB DEN05LA104Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Rocky Ford, COthe pilot's misjudged distance/altitude. A contributing factor was the inadvertent flap retraction.Jul 8, 2005 · N6839G · Substantial damage NTSB DEN89FA038Accident · 1 fatalField investigationFinal reportCessna 150L · Fairplay, CONov 28, 1988 · N1464Q · Destroyed NTSB DEN86LA110Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Falcon, COThe plt stated the acft contacted a powerline pole during a go-around. The powerline pole is located aprx one-half mile off the departure end of rwy 33. According to the plt, the pole is unmarked and unlighted. The accident occurred during night hrs with no…Apr 6, 1986 · N1580Q · Substantial damage NTSB DEN86LA045Accident · No injuriesLimited investigationFinal reportCessna 150L · Aurora, COAccording to the CFI, during a touch & go landing, the student allowed the acft to drift to the left side of the rwy where it contacted a snow bank. The CFI stated she failed to correct for the drift soon enough to prevent the accident. The landing was being…Dec 15, 1985 · N19409 · Substantial damage NTSB DEN85LA124Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Glenwood Spring, COThe acft crashed into a basketball court immediately after takeoff from Glenwood springs arpt. The plt made a touch and go landing and turned off the carburetor heat 100 ft above the ground during the takeoff climb. He said the engine began to run rough when…May 2, 1985 · N18009 · Destroyed NTSB DEN84LA113Accident · No injuriesLimited investigationFinal reportCessna 150L · Springfield, COAccording to the plt he landed too FAR on the right side of the rwy & the right wheel hit a chunk of ice. The acft veered right into a snowbank collapsing the nose gear.Mar 20, 1984 · N11315 · Substantial damage NTSB DEN84LA061Accident · No injuriesLimited investigationFinal reportCessna 150L · Limon, COThe student plt on his 2nd supervised solo flt. After returning from te local practice area, he entered the traffic pattern for a touch-&-go landing. When he added power for the takeoff portion. The acft veered to the left. The left main wheel entered deeper…Jan 2, 1984 · N1667Q · Substantial damage NTSB DEN80FTE25Accident · No injuriesClosedCessna 150 · Hudson, COFeb 5, 1980 · N16194 · Substantial damage NTSB DEN79FTE61Accident · Serious injuriesClosedCessna 150 · Berthoud, COJul 21, 1979 · N18660 · Substantial damage NTSB DEN79FTE42Accident · No injuriesClosedCessna 150L · Broomfield, COJun 1, 1979 · N19077 · Substantial damage NTSB DEN78FTE89Accident · Serious injuriesClosedCessna 150 · Broomfield, COAug 21, 1978 · N18551 · Substantial damage NTSB DEN78FTE45Accident · No injuriesClosedCessna 150 · Pueblo, COApr 4, 1978 · N11315 · Substantial damage NTSB DEN77FTE09Accident · No injuriesClosedCessna 150 · Boulder, CODec 11, 1976 · N11961 · Substantial damage NTSB DEN76AD002Accident · 2 fatalClosedCessna 150L · Monument, COJul 12, 1975 · N19449 · Destroyed NTSB DEN75FTE51Accident · No injuriesClosedCessna 150L · Greeley, COJan 30, 1975 · N16009 · Substantial damage NTSB DEN75DTE39Accident · No injuriesClosedCessna 150 · Ellicott, CONov 24, 1974 · N11420 · Substantial damage NTSB DEN75DTE32Accident · No injuriesClosedCessna 150 · Greeley, COOct 26, 1974 · N5349Q · Destroyed NTSB DEN75ATE22Accident · No injuriesClosedCessna 150 · Greeley, COOct 14, 1974 · N19040 · Substantial damage NTSB DEN75AD016Accident · 2 fatalClosedCessna 150L · Parker, COSep 29, 1974 · N11945 · Destroyed NTSB DEN74DTE47Accident · No injuriesClosedCessna 150 · Greeley, COJan 10, 1974 · N1396Q · Substantial damage NTSB DEN73FTE39Accident · No injuriesClosedCessna 150 · Broomfield, CODec 12, 1972 · N18551 · Substantial damage NTSB DEN72DTE26Accident · No injuriesClosedCessna 150 · Hillrose, COAug 31, 1971 · N6859G · Substantial damage