Skip to content

NTSB investigations: Cessna 150F, WI

31 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

19662026

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" = 'WI' 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\" = 'WI' 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" = 'WI' 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 CEN15LA217Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Neillsville, WIA partial loss of engine power for reasons that could not be determined because a postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.May 2, 2015 · N8558G · Substantial damage NTSB CHI00LA008Accident · No injuriesLimited investigationFinal reportCessna 150F · East Troy, WIthe pilot not maintaining directional control and not obtaining a proper climb rate. Factors were the gusts, and the ground loop that was encountered. A finding was the pilot atempted a go-around.Oct 13, 1999 · N7941F · Substantial damage NTSB CHI94LA156Accident · No injuriesLimited investigationFinal reportCessna 150F · Chippewa Falls, WIthe loss of engine power due to a binding carburetor heat door.May 12, 1994 · N6872F · Substantial damage NTSB CHI88LA245Accident · No injuriesLimited investigationFinal reportCessna 150F · Baraboo, WIWhile landing on a sod strip with an 11 knot quartering tailwind, the aircraft drifted to the left of the runway and encountered uneven terrain. The pilot reported that he failed to maintain directional control and was unable to avoid a ditch with standing…Sep 25, 1988 · N381VU · Substantial damage NTSB CHI86LA053Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Glidden, WIThe aircraft collided with powerlines while attempting a power off landing after engine stoppage. The fuel tanks were inspected and there was no fuel in the right tanks and only a small quantity in the lft tank. The engine was tested and found to function…Dec 28, 1985 · N8687S · Substantial damage NTSB CHI85LA279Accident · No injuriesLimited investigationFinal reportCessna 150F · Fond Du Lac, WIThe acft nosed over in soft terrain 1/4 mile short of the rwy at fon du lac arpt following a total loss of pwr. The flt departed henderson, KY, at 1510 CDT with 26 gallons of fuel and the pwr loss occurred at 1925 CDT, 4 hrs and 15 minsafter departure. Post…Jul 6, 1985 · N8219S · Substantial damage NTSB CHI81DEP03Accident · Serious injuriesClosedCessna 150F · Elkhorn, WIOct 7, 1980 · N7856F · No damage NTSB CHI80DEP16Accident · No injuriesClosedCessna 150 · Eau Claire, WIFeb 9, 1980 · N6747F · Substantial damage NTSB CHI79FEP53Accident · No injuriesClosedCessna 150 · Milwaukee, WIJul 6, 1979 · N7774F · Substantial damage NTSB CHI78FA070Accident · 1 fatalClosedCessna 150F · Portage, WISep 25, 1978 · N8815S · Destroyed NTSB CHI78DEP18Accident · No injuriesClosedCessna 150F · Necedah, WIFeb 20, 1978 · N8617G · Substantial damage NTSB CHI77FEP21Accident · No injuriesClosedCessna 150 · La Crosse, WIFeb 18, 1977 · N8098F · Substantial damage NTSB CHI76DER07Accident · No injuriesClosedCessna 150 · Amery, WIFeb 26, 1976 · N3596L · Substantial damage NTSB CHI74AC079Accident · 1 fatalClosedCessna 150F · Glen Flora, WIMar 28, 1974 · N8654G · Destroyed NTSB CHI73DEP53Accident · No injuriesClosedCessna 150 · Tony, WIApr 24, 1973 · N8654G · Substantial damage NTSB CHI73DEP22Accident · No injuriesClosedCessna 150 · Elkhorn, WISep 17, 1972 · N8778G · Substantial damage NTSB CHI73FEP09Accident · 1 fatalClosedCessna 150F · Lakewood, WIJul 22, 1972 · N7109F · Substantial damage NTSB CHI72DEP22Accident · No injuriesClosedCessna 150 · Kenosha, WINov 2, 1971 · N8229F · Substantial damage NTSB CHI72AC031Accident · 2 fatalClosedCessna 150F · Tomahawk, WIOct 1, 1971 · N7801F · Destroyed NTSB CHI72DEP12Accident · Minor injuriesClosedCessna 150 · Gays Mills, WIAug 15, 1971 · N6872F · Substantial damage NTSB CHI71FDM05Accident · No injuriesClosedCessna 150 · Superior, WIMar 17, 1971 · N6249R · 2 aircraft · Substantial damage NTSB CHI70DDM05Accident · Minor injuriesClosedCessna 150 · Baldwin, WIJun 7, 1970 · N8843S · Substantial damage NTSB CHI70DDJ07Accident · No injuriesClosedCessna 150 · Pewaukee, WIFeb 1, 1970 · N8662S · Substantial damage NTSB CHI69D0670Accident · No injuriesClosedCessna 150 · West Bend, WIMar 26, 1969 · N7912F · Substantial damage NTSB CHI69D0331Accident · No injuriesClosedCessna 150 · Waukesha, WIOct 31, 1968 · N6422F · Substantial damage NTSB DCA69A0001Accident · 3 fatalClosedConvair 580 · Milwaukee, WIAug 4, 1968 · N4634S · 2 aircraft · Substantial damage NTSB CHI69D0126Accident · No injuriesClosedCessna 150F · Neenah, WIJun 29, 1968 · N6970F · Substantial damage NTSB CHI67D0660Accident · No injuriesClosedCessna 150 · Waukesha, WIMay 7, 1967 · N3589L · Substantial damage NTSB CHI67D0352Accident · No injuriesClosedCessna 150 · La Farge, WIOct 1, 1966 · N7725F · Substantial damage NTSB CHI66F0735Accident · No injuriesClosedCessna 150 · Milwauke, WIMay 19, 1966 · N6765F · Substantial damage NTSB CHI66F0595Accident · No injuriesClosedCessna 150 · Milwaukee, WIFeb 16, 1966 · N8704S · Substantial damage