Skip to content

NTSB investigations: Cessna 150M, CO

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

19742026

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 ('2071830')) 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 ('2071830'))
  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 ('2071830'))
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 DEN03LA044Accident · No injuriesLimited investigationFinal reportCessna 150M · Gateway, COthe pilot's failure to maintain aircraft control. Contributing factors were the snow-covered runway.Mar 3, 2003 · N714NF · Substantial damage NTSB DEN00LA125Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Montrose, COAn inadvertent stall/mush. Factors were high density altitude, weight and balance exceeded, and pilot fatigue.Jul 8, 2000 · N4723 · Substantial damage NTSB DEN99LA076Accident · No injuriesLimited investigationFinal reportCessna 150M · Maybell, COThe pilot's inadvertent stall while maneuvering. Factors were the wind gusts weather conditions, and the high density altitude weather conditions.May 8, 1999 · N6128K · Substantial damage NTSB FTW98LA379Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Lamar, COThe pilot's failure to maintain climb airspeed, and inadvertently allowing the airplane to stall/mush. A factor was the embankment.Aug 28, 1998 · N704DL · Substantial damage NTSB FTW96LA376Accident · No injuriesLimited investigationFinal reportCessna 150M · Boulder, COan improper flare by the student pilot, and his improper recovery from a bounced landing. A factor relating to the accident was: the student pilot's lack of experience in the type (model) of aircraft.Sep 5, 1996 · N704QR · Substantial damage NTSB FTW94LA105Accident · No injuriesLimited investigationFinal reportCessna 150M · Steamboat Sprgs, COThe pilot's selection of too low an altitude in high mountainous terrain.Mar 19, 1994 · N233DB · Substantial damage NTSB DEN93LA072Accident · No injuriesLimited investigationFinal reportCessna 150M · Haswell, COFailure of the student pilot to maintain control of the aircraft during landing roll. Factors were: alternator failure, failure of the student pilot to follow procedures and directives, and failure of the student pilot to perform fuel consumption calculations.Jul 1, 1993 · N704QR · Substantial damage NTSB DEN92LA073Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Ft. Collins, COImproper rate of descent and lack of flare while conducting a forced landing. Factors were: partial power loss due to stuck exhaust valves caused by engine overheat from improper leaning.Jul 13, 1992 · N66315 · Substantial damage NTSB DEN88LA095Accident · No injuriesLimited investigationFinal reportCessna 150M · Garfield, COThe plt was ferrying his acft from burlington, NC to kelso, WA. After refueling his acft to capacity (26 gal.), he stayed overnight in lamar, CO. He departed lamar the next morning at 0800. He passed pueblo, CO at 7500 ft., and obtained a wx briefing from the…Apr 14, 1988 · N714BK · Substantial damage NTSB DEN82DA143Accident · No injuriesFinal reportCessna 150M · Nr. Colorado Sp, COThe acft crashed in north cheyenne wood near pikes peak at approximately 8400 ft MSL. The plt reported that after arriving at the first ridge of mountains he was caught in downdrafts. Unable to clear the top of a mountain, he turned into a box canyon.Jul 25, 1982 · N9424U · Destroyed NTSB DEN80DTE17Accident · No injuriesClosedCessna 150M · Peyton, CODec 30, 1979 · N9424U · Substantial damage NTSB DEN79FTE55Accident · Minor injuriesClosedCessna 150 · Sedalia, COJul 7, 1979 · N45324 · Substantial damage NTSB DEN79FTE18Accident · No injuriesClosedCessna 150 · Cortez, COJan 19, 1979 · N63349 · Substantial damage NTSB DEN79FTE11Accident · No injuriesClosedCessna 150 · Ft.Collins, CODec 21, 1978 · N9489U · Substantial damage NTSB DEN78FTE75Accident · Minor injuriesClosedCessna 150 · Elbert, COJul 20, 1978 · N9288U · Substantial damage NTSB DEN77FTE73Accident · Minor injuriesClosedCessna 150 · Two Buttes, COAug 15, 1977 · N714AE · Substantial damage NTSB DEN77DTE23Accident · No injuriesClosedCessna 150 · Ft Collins, COFeb 12, 1977 · N9489U · Substantial damage NTSB DEN77FTE16Accident · Serious injuriesClosedCessna 150M · Fort Collins, COJan 19, 1977 · N66100 · Destroyed NTSB DEN75DTE44Accident · No injuriesClosedCessna 150 · Salida, CODec 28, 1974 · N2920V · Substantial damage