NTSB investigations: Cessna 150L, MT

13 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

NTSB investigations: Cessna 150L, MT per year, 1971–2026: 13 cases
1971	1
1976	3
1978	2
1979	1
1980	1
1982	2
1985	1
2004	1
2005	1

Where

Open the map

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" = 'MT' 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\" = 'MT' 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" = 'MT' 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 SEA05CA088Accident · No injuriesData collectionFinal reportCessna 150L · Eureka, MTThe pilot's failure to adequately compensate for the wind conditions during the landing roll. Factors include a 10 knot crosswind, with gusts up to 15 knots, and a taxiway sign near the point where the aircraft exited the runway.Apr 27, 2005 · N1387Q · Substantial damage NTSB SEA04LA168Accident · 1 fatalLimited investigationFinal reportCessna 150L · Angela, MTThe failure of the pilot to maintain clearance while maneuvering. A factor contributing to the accident was the physical impairment of the pilot due to an elevated blood alcohol level.Aug 19, 2004 · N17062 · Destroyed NTSB DEN85LA063Accident · No injuriesLimited investigationFinal reportCessna 150 · Missoula, MTOn jan 14, 1985, a Cessna 150 nosed over after landing on a highway near Missoula, MT. The pilot stated he lost partial engine power due to carburetor icing conditions encountered enroute from great falls, MT. The pilot and his passenger were not injured. The…Jan 15, 1985 · N1416Q · Substantial damage NTSB DEN82FTI18Accident · Serious injuriesFinal reportCessna 150 · Conrad, MTPilot had engine lose power momentarily on a previous flight but did not concern himself about it. During this flight power was lost at 4100 feet. Pilot tried restart without success. During landing nose was lowered prior to touchdown and it caught on an…Sep 17, 1982 · N1299Q · Substantial damage NTSB DEN82DA095Accident · No injuriesFinal reportCessna 150 · Dillon, MTWhile the student pilot was landing, the aircraft bounced and nosed over. The pilot had only 4 hours of solo time.May 20, 1982 · N18120 · Substantial damage NTSB DEN80FTA12Accident · No injuriesClosedCessna 150 · Winnett, MTJun 3, 1980 · N11499 · Substantial damage NTSB SEA79FTI06Accident · No injuriesClosedCessna 150L · Stevensville, MTJan 31, 1979 · N10903 · Substantial damage NTSB SEA78DTA16Accident · No injuriesClosedCessna 150 · Miles City, MTJul 15, 1978 · N19313 · Substantial damage NTSB SEA78FTI14Accident · Minor injuriesClosedCessna 150 · Hamilton, MTMay 16, 1978 · N6743G · Substantial damage NTSB SEA76FTA26Accident · Serious injuriesClosedCessna 150L · Miles City, MTJul 30, 1976 · N11547 · Destroyed NTSB SEA76FTI32Accident · No injuriesClosedCessna 150D · Lincoln, MTJul 14, 1976 · N19422 · Substantial damage NTSB SEA76DTI25Accident · No injuriesClosedCessna 150 · Three Forks, MTMay 5, 1976 · N18119 · Substantial damage NTSB SEA72AS019Accident · 1 fatalClosedCessna 150L · Ulm, MTNov 9, 1971 · N6691G · Destroyed