Skip to content

NTSB investigations: Cessna 150L, MN

23 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" = 'MN' 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\" = 'MN' 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" = 'MN' 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 CEN15CA074Accident · No injuriesData collectionFinal reportCessna 150L · New Buffalo, MNThe student pilot's failure to maintain directional control and the flight instructor's delayed remedial action during landing. Contributing was the snow on the runway surface.Nov 16, 2014 · N6985G · Substantial damage NTSB CHI98LA069Accident · No injuriesLimited investigationFinal reportCessna 150L · Litchfield, MNthe pilot's improper flare and improper recovery from a bounced landing, and his failure to maintain proper runway alignment during the attempted go-around. Factors relating to the accident were: the crosswind condition, and the proximity of trees.Dec 14, 1997 · N18031 · Destroyed NTSB CHI91LA241Accident · No injuriesLimited investigationFinal reportCessna 150 · Winona, MNImproper flare performed by the pilot. A factor related to the accident was lack of total experience by the pilot.Jul 22, 1991 · N19153 · Substantial damage NTSB CHI91LA063Accident · No injuriesLimited investigationFinal reportCessna 150L · Bemidji, MNThe pilot's improper preflight inspection of the airplane.Jan 4, 1991 · N6803G · Substantial damage NTSB MKC90LA052Accident · No injuriesLimited investigationFinal reportCessna 150 · Clear Lake, MNFailure of the pilot to maintain proper alignment with the runway, his delay in initiating a go-around, and his premature raising of the flaps. Factors related to the accident were the adverse wind conditions and the tree.Feb 9, 1990 · N7359G · Substantial damage NTSB CHI86LA162Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Int'L Falls, MNAcft struck power lines on approach to private airstrip. The plt stated that an air pocket pulled the plane down. Weather at international Falls, six miles from the accident site, reported winds at 7 KTS with no gusts. The plts flt time was not reported.Jun 29, 1986 · N19528 · Substantial damage NTSB CHI83LA405Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Halstad, MNThe acft landed long and collided with an embankment at a private farm strip. The pilot stated he landed on rwy 35 and the wind was from 170 degrees at 5-10 KTS.Sep 1, 1983 · N6826G · Substantial damage NTSB CHI83LA043Accident · No injuriesLimited investigationFinal reportCessna 150L · Red Wing, MNThe pilot stated that while enroute to Red Wing, MN he ran into deteriorating weather and the engine started to run rough. He decided to execute a precautionary landing into a hay field rather than encounter darkness and adverse weather conditions with a…Nov 25, 1982 · N18236 · Substantial damage NTSB CHI82DA035Accident · Minor injuriesFinal reportCessna 150 · Buffalo, MNThe instructor and student departed with the intention of making a touch and go landing after takeoff. During the landing, the aircraft veered to the right and struck a 3 to 4 ft snowbank. The student stated that on short final, the aircraft dropped and…Feb 6, 1982 · N10794 · Substantial damage NTSB CHI81DER07Accident · No injuriesClosedCessna 150 · Cook, MNNov 19, 1980 · N19592 · Substantial damage NTSB CHI80DA044Accident · 1 fatalClosedCessna 150 · St Paul, MNMay 23, 1980 · N11960 · No damage NTSB MKC80DER35Accident · No injuriesClosedCessna 150 · Rushford, MNApr 18, 1980 · N19588 · Substantial damage NTSB MKC80DER28Accident · No injuriesClosedCessna 150L · Northome, MNFeb 2, 1980 · N19528 · Substantial damage NTSB MKC78DER36Accident · No injuriesClosedCessna 150 · Staples, MNMar 30, 1978 · N10859 · Substantial damage NTSB MKC77DER64Accident · No injuriesClosedCessna 150 · Staples, MNJul 19, 1977 · N10859 · Substantial damage NTSB MKC76DER96Accident · No injuriesClosedCessna 150 · Cambridge, MNSep 6, 1976 · N16078 · Substantial damage NTSB MKC76DER78Accident · No injuriesClosedCessna 150L · Carlton, MNJul 10, 1976 · N1601Q · Substantial damage NTSB MKC76AK065Accident · 1 fatalClosedCessna 150 · Thief Rv Falls, MNJul 7, 1976 · N1728Q · Destroyed NTSB MKC75FER64Accident · No injuriesClosedCessna 150L · Duluth, MNApr 16, 1975 · N18063 · Substantial damage NTSB MKC75DER44Accident · No injuriesClosedCessna 150L · Garrison, MNJan 19, 1975 · N6909G · Substantial damage NTSB MKC75FER30Accident · No injuriesClosedCessna 150L · Green Isle, MNNov 17, 1974 · N569GS · Substantial damage NTSB MKC75DER09Accident · No injuriesClosedCessna 150L · Crystal, MNJul 31, 1974 · N568GS · Substantial damage NTSB MKC72DER33Accident · No injuriesClosedCessna 150L · Wht Br Lake, MNDec 22, 1971 · N1601Q · Substantial damage