Skip to content

NTSB investigations: Cessna 150H, MI

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

19682026

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 ('2071818')) 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 ('2071818'))
  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 ('2071818'))
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 CHI08CA275Accident · No injuriesData collectionFinal reportCessna 150H · Bay City, MIThe loss of engine power during descent due to carburetor icing. Contributing to the accident was the collapse of the nose landing gear due to rough terrain.Aug 30, 2008 · N23461 · Substantial damage NTSB CHI07CA169Accident · Minor injuriesData collectionFinal reportCessna 150H · Bellaire, MIA loss of engine power for undetermined reasons. A factor in the accident was the deer fence.Jun 15, 2007 · N23117 · Substantial damage NTSB CHI02CA191Accident · No injuriesData collectionFinal reportCessna 150H · Mecosta, MIThe airplane encountered unsuitable terrain and the pilot applied excessive braking during the aborted takeoff. A factor contributing to the accident was the sandy terrain.Jul 13, 2002 · N6912S · Substantial damage NTSB CHI92FAMS3Accident · 1 fatalMissing aircraftFinal reportCessna 150H · Manistee, MIUndeterminedSep 12, 1992 · N6759S · Destroyed NTSB CHI92LA185Accident · No injuriesLimited investigationFinal reportCessna 150H · Three Rivers, MIThe pilot-in-command's selection of a rough and uneven terrain. A factor related to the accident was the pilot-in-command's poor inflight decision making.Jun 21, 1992 · N22120 · Substantial damage NTSB CHI91LA296Accident · No injuriesLimited investigationFinal reportCessna 150H · New Hudson, MIFailure of the pilot to maintain directional control during landing roll in a crosswind.Sep 20, 1991 · N91R · Substantial damage NTSB CHI91LA195Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Cadillac, MIImproper preflight, inattentiveness, failure to maintain airspeed, and poor inflight planning/decision.Jun 18, 1991 · N22494 · Destroyed NTSB CHI91LA038Accident · No injuriesLimited investigationFinal reportCessna 150 · Grand Haven, MIDelayed application of carburetor heat by the PIC. Contributing factors were carburetor icing conditions (weather) and none suitable terrain.Dec 2, 1990 · N7199S · Substantial damage NTSB CHI90LA083Accident · No injuriesLimited investigationFinal reportCessna 150H · Plainwell, MIForeign object (ice), which jammed the right wheel. A factor related to the accident was: the snowbank.Feb 18, 1990 · N50003 · Substantial damage NTSB CHI89DET02Accident · No injuriesFinal reportCessna 150H · Benton Harbor, MIA misjudged approach during the execution of an emergency landing resulting in an encounter with unsuitable terrain. Contributing factors are inaccurate fuel consumption calculations and fuel starvation due to contamination.Dec 22, 1988 · N50331 · Substantial damage NTSB CHI87LA090Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Hopkins, MIThe plt stated that 'everything was normal' on downwind and base, but that he experienced rough air and 'side to side motion' of the acft on final approach to rwy 27. According to the plt, he held an airspeed of 70 mph with 'some power' until he had the rwy…Mar 7, 1987 · N22793 · Substantial damage NTSB CHI86LA063Accident · No injuriesLimited investigationFinal reportCessna 150H · Charlotte, MIThe student was performing a practice approach to an emergency landing on a frozen, snow covered lake. After he had flown to an altitude low over the lake the instructor took over the controls. At this point the aircraft struck a ridge of snow and came to a…Jan 8, 1986 · N50255 · Substantial damage NTSB CHI83LA395Accident · No injuriesLimited investigationFinal reportCessna 150H · Allegan, MIThe acft collided with a guard rail during a precautionary landing in IMC weather. During the flt wx cond deteriorated and the plt became concerned about collision with structures(towers) in the area and elected to land on a fairground. Braking was poor on…Aug 28, 1983 · N6996S · Substantial damage NTSB CHI80FEM09Accident · No injuriesClosedCessna 150H · Hesperia, MIDec 26, 1979 · N6746S · Substantial damage NTSB CHI78FEC30Accident · No injuriesClosedCessna 150M · Willis, MIMay 29, 1978 · N767MF · Substantial damage NTSB CHI76FEC65Accident · Minor injuriesClosedCessna 150H · Willis, MISep 19, 1976 · N50203 · Substantial damage NTSB CHI75DEM13Accident · No injuriesClosedCessna 150H · Cadillac, MIDec 28, 1974 · N6934S · Substantial damage NTSB CHI75DEM19Accident · No injuriesClosedCessna 150 · Boyne City, MIOct 28, 1974 · N22919 · Substantial damage NTSB CHI74DEC23Accident · No injuriesClosedCessna 150 · Troy, MIDec 21, 1973 · N6463S · Substantial damage NTSB CHI74FEM14Accident · No injuriesClosedCessna 150 · Grand Haven, MIAug 11, 1973 · N7116S · Destroyed NTSB CHI73FEM45Accident · No injuriesClosedCessna 150J · Allegan, MIMar 22, 1973 · N50415 · Substantial damage NTSB CHI73DEM32Accident · No injuriesClosedCessna 150 · Traverse Cty, MIDec 14, 1972 · N22120 · Substantial damage NTSB CHI72DEM17Accident · No injuriesClosedCessna 150H · Bruce Crosng, MISep 3, 1971 · N6501S · Substantial damage NTSB CHI72FEM06Accident · No injuriesClosedCessna 150H · Freeland, MIJul 27, 1971 · N23461 · Substantial damage NTSB CHI71DEC56Accident · No injuriesClosedCessna 150H · Plymouth, MIJun 6, 1971 · N22038 · Substantial damage NTSB CHI71FET27Accident · No injuriesClosedCessna 150H · Coldwater, MIJun 3, 1971 · N22168 · Substantial damage NTSB CHI71FEM84Accident · Serious injuriesClosedCessna 150 · Mt Pleasant, MIMay 20, 1971 · N23006 · Substantial damage NTSB CHI71DEM74Incident · No injuriesClosedCessna 150 · Freeland, MIMar 28, 1971 · N50138 · Minor damage NTSB CHI71FBJ56Accident · Minor injuriesClosedCessna 150H · Gladstone, MIJan 25, 1971 · N22587 · Substantial damage NTSB CHI70FBJ25Accident · No injuriesClosedCessna 150H · Beechwood, MIMay 2, 1970 · N6536S · Substantial damage NTSB CHI70FBG06Accident · No injuriesClosedCessna 150H · Plymouth, MIJan 30, 1970 · N22063 · Substantial damage NTSB CHI70A0005Accident · Serious injuriesClosedCessna 150H · Plymouth, MIJul 15, 1969 · N50005 · 2 aircraft · Destroyed NTSB CHI70F0093Accident · Minor injuriesClosedCessna 150 · Houghton Lk, MIJul 12, 1969 · N23154 · Destroyed NTSB CHI69F0498Accident · No injuriesClosedCessna 150 · Plymouth, MIFeb 25, 1969 · N22038 · Substantial damage NTSB CHI69F0465Accident · No injuriesClosedCessna 150H · Detroit, MIFeb 18, 1969 · N6423S · Substantial damage NTSB CHI69D0489Accident · No injuriesClosedCessna 150H · Hamburg, MIFeb 13, 1969 · N22063 · Substantial damage NTSB CHI69F0343Accident · No injuriesClosedCessna 150 · Plymouth, MINov 7, 1968 · N50005 · Substantial damage