Skip to content

NTSB investigations: Cessna 150J, MN

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

19702026

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 ('2071820')) 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 ('2071820'))
  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 ('2071820'))
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 CEN23LA069Accident · No injuriesClass 4 · LimitedFinal reportCessna 150J · South St. Paul, MNThe student pilot’s failure to maintain directional control during the take-off roll with a snow and ice covered runway.Dec 26, 2022 · N51115 · Substantial damage NTSB CEN18LA015Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Willmar, MNThe pilot’s improper conduct of the soft-field takeoff, which led to his failure to attain adequate airspeed, and the flight instructor’s subsequent improper landing flare, which resulted in a hard, forced landing.Oct 18, 2017 · N50609 · Substantial damage NTSB CHI06CA107Accident · No injuriesData collectionFinal reportCessna 150 · Sandstone, MNThe total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight. A contributing factor was the unsuitable terrain encountered during the forced landing.Apr 10, 2006 · N50970 · Substantial damage NTSB CHI91LA206Accident · No injuriesLimited investigationFinal reportCessna 150 · Carlos, MNThe pilot's failure to use adequate carburetor heat. Factors to the accident were the carburetor icing conditions and the wires.Jul 3, 1991 · N50637 · Substantial damage NTSB CHI88LA221Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Burnsville, MNDuring a local pleasure/aerial photography flight, the pilot failed to handle the aircraft properly. Subsequently the pilot was unable to maintain sufficient airspeed and/or altitude to remain clear of obstacles. The aircraft was configured for slow flight as…Aug 27, 1988 · N5561G · Substantial damage NTSB CHI83LA111Accident · No injuriesLimited investigationFinal reportCessna 150 · Worthington, MNThe plt reported that he was able to maintain visual ground contact after he left blue earth, MN. However, as he was following an interstate highway near Worthington, MN, the visibility decreased. He attempted to get to the arpt at Worthington, but saw a…Feb 12, 1983 · N50567 · Substantial damage NTSB MKC78FER07Accident · No injuriesClosedPiper PA-28 · Anoka, MNNov 9, 1977 · N47350 · 2 aircraft · Substantial damage NTSB MKC77DER42Accident · No injuriesClosedCessna 150 · Pine City, MNMay 15, 1977 · N60541 · Substantial damage NTSB MKC77FER05Accident · No injuriesClosedCessna 150J · Tyler, MNNov 7, 1976 · N60663 · Substantial damage NTSB MKC76DER82Accident · No injuriesClosedCessna 150J · Anoka, MNJul 25, 1976 · N60030 · Substantial damage NTSB MKC76FER56Accident · Serious injuriesClosedCessna 150J · Rochester, MNMar 10, 1976 · N60038 · Substantial damage NTSB MKC76DER52Accident · No injuriesClosedCessna 150J · Lake Elmo, MNFeb 13, 1976 · N61039 · Substantial damage NTSB MKC75DER56Accident · No injuriesClosedCessna 150J · Anoka, MNMar 10, 1975 · N60030 · Substantial damage NTSB MKC74DER51Accident · No injuriesClosedCessna 150J · Esko, MNJun 1, 1974 · N50793 · Substantial damage NTSB MKC74DER40Accident · No injuriesClosedCessna 150 · Motley, MNFeb 9, 1974 · N60030 · Substantial damage NTSB MKC74DTG09Accident · No injuriesClosedCessna 150H · Angus, MNOct 5, 1973 · N50989 · Substantial damage NTSB MKC71FDM53Accident · No injuriesClosedCessna 150J · St Paul, MNApr 5, 1971 · N50930 · Substantial damage NTSB MKC70DDM19Accident · Minor injuriesClosedCessna 150 · Lake Elmo, MNApr 10, 1970 · N50693 · Substantial damage NTSB MKC70DDM18Accident · No injuriesClosedCessna 150J · Willmar, MNApr 4, 1970 · N51179 · Substantial damage NTSB MKC70DDM11Accident · No injuriesClosedCessna 150J · Winona, MNFeb 23, 1970 · N61182 · Substantial damage