Skip to content

NTSB investigations: Cessna 150M, UT

13 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

19752026

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" = 'UT' 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\" = 'UT' 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" = 'UT' 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 WPR15LA103Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Layton, UTThe total loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate preflight and in-flight fuel planning, which did not account for the increased headwind.Feb 14, 2015 · N827CH · Substantial damage NTSB WPR10CA337Accident · Minor injuriesData collectionFinal reportCessna 150M · Neola, UTA partial loss of engine power for undetermined reasons and the pilot's failure to maintain clearance from a power line.Jul 3, 2010 · N3143V · Substantial damage NTSB SEA07LA131Accident · No injuriesLimited investigationFinal reportCessna 150M · Spanish Fork, UTThe student pilot's inadequate compensation for gusty crosswind conditions, and his failure to maintain directional control during the landing roll. Factors include gusty crosswinds, and a ditch near the runway environment.May 18, 2007 · N9397U · Substantial damage NTSB DEN04LA056Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Orem, UTthe pilot's improper in-flight planning and decision making, resulting in fuel exhaustion and the loss of engine power. Contributing factors include the dark night light conditions, and the trees.Apr 2, 2004 · N66758 · Substantial damage NTSB SEA91LA047Accident · No injuriesLimited investigationFinal reportCessna 150M · Salt Lake City, UTAn undetermined loss of engine power.Feb 4, 1991 · N63644 · Substantial damage NTSB DEN89LA204Accident · No injuriesLimited investigationFinal reportCessna 150M · Delta, UTFailure of the pilot to maintain directional control which resulted in a ground swerve. Soft terrain beside the runway was a related factor.Sep 1, 1989 · N6372K · Substantial damage NTSB DEN89LA158Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Bountiful, UTThe pilot failed to maintain adequate speed for the turning maneuver (to avoid an obstacle) and inadvertently allowed the aircraft to stall. Contributing factors were: improper uuse of the flaps, high density altitude, and a high obstruction.Jul 7, 1989 · N6318K · Destroyed NTSB DEN88LA056Accident · No injuriesLimited investigationFinal reportCessna 150M · Delta, UTDuring the landing roll, the acft swerved to the right into a snowbank and nosed over. The plt said he found snow packed between the landing gear wheel and wheel pants restricting the wheel from rotating. In his recommendation for prevention, the plt stated…Jan 20, 1988 · N6372K · Substantial damage NTSB DEN83FA090Accident · 2 fatalField investigationFinal reportCessna 150M · Kanab, UTThe acft departed page at about 1150. At about 1238 the acft struck the south slope of a 6,280-FT canyon wall at about 6,000 ft MSL. The canyon is one of a series of about five 'finger' canyons forming the vermilion cliffs group. Sigment lima 15 in effect…Mar 31, 1983 · N714ML · Destroyed NTSB DEN82FTM03Accident · No injuriesClosedCessna 150 · Stockton, UTNov 8, 1981 · N704AY · Substantial damage NTSB DEN77FTM03Accident · No injuriesClosedCessna 150 · Salt Lake City, UTSep 30, 1976 · N45230 · Substantial damage NTSB DEN76FTM04Accident · No injuriesClosedCessna 150 · Cedar City, UTAug 19, 1975 · N66670 · Destroyed NTSB DEN75FTM13Accident · Serious injuriesClosedCessna 150F · Vernal, UTMar 15, 1975 · N66184 · Destroyed