Skip to content

NTSB investigations: Cessna 150F, MN

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

19652026

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 ('2071814')) 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 ('2071814'))
  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 ('2071814'))
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 GAA17CA100Accident · No injuriesData collectionFinal reportCessna 150 · Warren, MNThe noncertificated pilot’s failure to maintain directional control during the landing, which resulted in a runway excursion.Dec 23, 2016 · N7961F · Substantial damage NTSB CHI04CA143Accident · No injuriesData collectionFinal reportCessna 150F · Forest Lake, MNThe pilot's inaccurate fuel consumption calculations which resultied in fuel exhaustion and loss of engine power. Factors associated with the accident were the dark light conditions and the water on which the forced landing was made.Jun 7, 2004 · N6620F · Substantial damage NTSB CHI92LA108Accident · No injuriesLimited investigationFinal reportCessna 150 · Waseca, MNDirectional control was not maintained by the pilot.Mar 15, 1992 · N8741G · Substantial damage NTSB CHI91LA168Accident · No injuriesLimited investigationFinal reportCessna 150 · Cambridge, MNPartial loss of engine power due to improper use of carburetor heat and a stall encountered by the pilot.May 28, 1991 · N8845S · Substantial damage NTSB CHI87LA031Accident · No injuriesLimited investigationFinal reportCessna 150F · Nicollet, MNThe plt experienced fuel exhaustion and made an emergency forced landing. With the help of a farmer he refueled the acft and got it to nearby highway 14, where he attempted to takeoff while state police provided road blocks. While on takeoff, the plt lost…Nov 16, 1986 · N6442F · Destroyed NTSB CHI81FER27Accident · No injuriesClosedCessna 150F · St Paul, MNMar 13, 1981 · N7823F · Substantial damage NTSB CHI80FER64Accident · No injuriesClosedCessna 150 · Ogema, MNAug 10, 1980 · N8215F · Substantial damage NTSB MKC78FER96Accident · Minor injuriesClosedCessna 150 · Belle Plaine, MNSep 17, 1978 · N8241S · Destroyed NTSB MKC76DER66Accident · Minor injuriesClosedCessna 150 · Little Fork, MNMay 30, 1976 · N6485F · Substantial damage NTSB MKC72DER41Accident · No injuriesClosedCessna 150F · Princeton, MNFeb 12, 1972 · N8918S · Substantial damage NTSB MKC71FDM24Accident · Minor injuriesClosedCessna 150F · Isabella, MNSep 18, 1970 · N8743G · Substantial damage NTSB MKC71DDM05Accident · No injuriesClosedCessna 150F · Lincoln, MNJul 8, 1970 · N6485F · Substantial damage NTSB MKC70FDM36Accident · No injuriesClosedCessna 150F · Crystal, MNJun 20, 1970 · N7936F · Substantial damage NTSB MKC70D0299Accident · No injuriesClosedCessna 150F · Minneapolis, MNDec 16, 1969 · N8868G · Substantial damage NTSB MKC69D0368Accident · No injuriesClosedCessna 150 · Grand Rapids, MNMar 17, 1969 · N8585G · Substantial damage NTSB MKC69D0333Accident · No injuriesClosedCessna 150 · Eden Prairie, MNDec 29, 1968 · N6825F · Substantial damage NTSB MKC68D0493Accident · No injuriesClosedCessna 150 · Little Falls, MNFeb 15, 1968 · N3089X · Substantial damage NTSB MKC67F0513Accident · Minor injuriesClosedCessna 150 · Fosston, MNApr 29, 1967 · N6283R · Substantial damage NTSB MKC67D0548Accident · No injuriesClosedCessna 150 · Sprg.Lake Pk., MNMar 25, 1967 · N8892G · Substantial damage NTSB MKC67F0454Accident · No injuriesClosedCessna 150 · Anoka, MNFeb 14, 1967 · N8614G · Substantial damage NTSB MKC67D0379Accident · No injuriesClosedCessna 150 · Hopkins, MNJan 12, 1967 · N6960F · Substantial damage NTSB MKC67D0354Accident · No injuriesClosedCessna 150F · Warren, MNDec 11, 1966 · N7199F · Substantial damage NTSB MKC67F0355Accident · No injuriesClosedCessna 150F · Hopkins, MNNov 26, 1966 · N3520L · Substantial damage NTSB MKC67F0287Accident · Serious injuriesClosedCessna 150 · Crystal, MNNov 15, 1966 · N3698S · Destroyed NTSB MKC67F0272Accident · No injuriesClosedCessna 150 · Rosemount, MNSep 27, 1966 · N6684T · 2 aircraft · Substantial damage NTSB MKC67F0214Accident · No injuriesClosedCessna 150 · Cross Lake, MNSep 3, 1966 · N8834G · Substantial damage NTSB MKC67D0107Accident · No injuriesClosedCessna 150 · Norwood, MNJul 30, 1966 · N6988F · Substantial damage NTSB MKC66D0311Accident · No injuriesClosedCessna 150 · Rochester, MNOct 14, 1965 · N8042S · Substantial damage