Skip to content

NTSB investigations: Cessna 150K, MI

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

19692026

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" = 'MI' 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 ('2071822')) 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\" = 'MI' 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 ('2071822'))
  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" = 'MI' 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 ('2071822'))
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 CEN10CA500Accident · Minor injuriesData collectionFinal reportCessna 150K · Gaylord, MIA loss of engine power for undetermined reasons.Aug 24, 2010 · N6032G · Substantial damage NTSB CHI98LA148Accident · Serious injuriesLimited investigationFinal reportCessna 150K · Clarkston, MIthe pilot selected unsuitable terrain on which to make the precautionary landing due to weather. Factors associated with the accident were the fog, low ceiling, poor in-flight planning, the precautionary landing, the loose wet gravel on which the…May 12, 1998 · N5876G · Substantial damage NTSB CHI97LA172Accident · No injuriesLimited investigationFinal reportCessna 150K · Ypsilanti, MIthe pilot's failure to use carburetor heat, which resulted in carburetor ice, loss of engine power, and a forced landing. Factors relating to this accident were: the icing (weather) condition and sign(s) in the emergency landing area.Jun 19, 1997 · N5738G · Substantial damage NTSB CHI92LA083Accident · No injuriesLimited investigationFinal reportCessna 150 · Lansing, MIFailure of the pilot to maintain directional control of the airplane during a takeoff ground run. Factors associated with the accident are the pilot's diverted attention, his lack of total experience, and the soft terrain.Jan 26, 1992 · N5842G · Substantial damage NTSB CHI92LA078Accident · No injuriesLimited investigationFinal reportCessna 150 · New Haven, MIDirectional control was not maintained by the dual student and remedial action was delayed by the CFI. A factor related to the accident was the icy runway conditions.Jan 25, 1992 · N6225G · Substantial damage NTSB CHI88LA194Accident · No injuriesLimited investigationFinal reportCessna 150K · Detroit, MIHard landing made by the student pilot resulting in a nose gear failure due to overload forces and the aircraft flipping over on its back.Aug 7, 1988 · N5796G · Substantial damage NTSB CHI88LA098Accident · No injuriesLimited investigationFinal reportCessna 150K · Pinconning, MIThe airplane collided with a hangar and a tree during an attempted go-around at gross airport. The pilot stated that he flared too high and failed to correct the left yaw when he added power. The resultant flight path was directly into trees which he felt he…Apr 17, 1988 · N6126G · Substantial damage NTSB CHI85LA331Accident · No injuriesLimited investigationFinal reportCessna 150K · Romeo, MIThe acft nosed over after contacting a ditch during a landing roll. The student plt, on his second solo flt, was practicing touch & go landings when the accident occurred. He stated he rushed on final apch because other acft were lined up waiting to takeoff.…Aug 3, 1985 · N5783G · Substantial damage NTSB CHI81DEM39Accident · No injuriesClosedCessna 150 · East Lansing, MIAug 25, 1981 · N5842G · Substantial damage NTSB CHI80FEC17Accident · No injuriesClosedCessna 150K · Imlay City, MIMay 4, 1980 · N5783G · Substantial damage NTSB CHI78FEM21Accident · Serious injuriesClosedCessna 150K · Gladstone, MIJun 15, 1978 · N5775G · Substantial damage NTSB CHI77FEC16Accident · No injuriesClosedCessna 150 · Pontiac, MIFeb 20, 1977 · N5796G · Substantial damage NTSB CHI75FEC56Accident · No injuriesClosedCessna 150K · Meade, MIJun 15, 1975 · N6225G · Substantial damage NTSB CHI74FEM23Accident · No injuriesClosedCessna 150 · Freeland, MIOct 6, 1973 · N5883G · Substantial damage NTSB CHI74AEC03Accident · No injuriesClosedCessna 150K · Owosso, MIJul 11, 1973 · N6451G · Substantial damage NTSB CHI72FEM35Accident · No injuriesClosedCessna 150K · Bath, MISep 30, 1971 · N6069G · Substantial damage NTSB CHI70FBJ16Accident · No injuriesClosedCessna 150K · Midland, MIMar 28, 1970 · N5795G · Substantial damage NTSB CHI70FBJ05Accident · No injuriesClosedCessna 150 · Ionia, MIFeb 1, 1970 · N5951G · Substantial damage NTSB CHI70D0349Accident · No injuriesClosedCessna 150 · Hillsdale, MINov 27, 1969 · N5827G · Substantial damage