Skip to content

NTSB investigations: Cessna 150G, MI

32 cases on aircraft the registry lists as Cessna 150G. 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" = '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 ('2071816')) 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 ('2071816'))
  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 ('2071816'))
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 CEN09FA015Accident · 1 fatalField investigationFinal reportCessna 150G · Cedar Lake, MIThe student pilot's failure to maintain adequate clearance after takeoff. Contributing to the accident was the pilot's overall lack of flight experience.Oct 11, 2008 · N3623J · Substantial damage NTSB CHI99LA299Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Lambertville, MIthe inadequate aircraft preflight by the pilot and the pilot's failure to remove the aileron gust lock before flight. Factors to the accident were the soft terrain adjacent to the runway and the collapse of the nose gear.Aug 16, 1999 · N4061J · Substantial damage NTSB CHI97LA064Accident · No injuriesLimited investigationFinal reportCessna 150G · Dowagiac, MIthe pilot's failure to maintain directional control. A factor was the snowbank.Feb 1, 1997 · N4655X · Substantial damage NTSB CHI94LA015Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Monroe, MIThe pilot's inadequate preflight planning/preparation, when he misjudged the (inadequate) supply of fuel before takeoff, which resulted in fuel exhaustion. Soft terrain in the emergency landing area was a related factor.Oct 2, 1993 · N2759S · Substantial damage NTSB CHI91LA049Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Monroe, MIDirectional control not maintained by the PIC.Dec 16, 1990 · N2834S · Substantial damage NTSB CHI90LA167Accident · No injuriesLimited investigationFinal reportCessna 150G · Manchester, MILoss of engine power due to a stuck exhaust valve.Jul 3, 1990 · N4690X · Substantial damage NTSB CHI85LA387Accident · No injuriesLimited investigationFinal reportCessna 150 · Hastings, MIThe pilot was competing in a spot landing contest. The aircraft was reportedly observed about 4 to 5 feet AGL and slow just before it contacted the grass runway. The nosegear failed, dug into the ground, resulting in a nose over.Sep 28, 1985 · N3025S · Substantial damage NTSB CHI84LA276Accident · No injuriesLimited investigationFinal reportCessna 150G · Williamston, MISome cows ran into the path of the acft during takeoff. The plt turned as soon as airborne to avoid the animals and had to turn again to avoid powerlines. In this maneuvering the acfts left wing hit a tree and the acft cartwheeled.Jul 1, 1984 · N3495J · Substantial damage NTSB CHI82DA182Accident · No injuriesFinal reportCessna 150G · White Cloud, MIThe student pilot stated he was too high on final approach so he attempted a go-around. As he applied power, the nose increased in pitch attitude and the empennage struck the runway. The aircraft started to turn to the left, the left wing struck the runway…May 24, 1982 · N2992J · Substantial damage NTSB CHI78FEM22Accident · No injuriesClosedCessna 150 · Battle Creek, MIJun 21, 1978 · N3284J · Substantial damage NTSB CHI78FEC07Accident · No injuriesClosedCessna 150G · Fowlerville, MIDec 3, 1977 · N3166X · Substantial damage NTSB CHI76FEC28Accident · No injuriesClosedCessna 150G · Petersburg, MIFeb 20, 1976 · N3412J · Substantial damage NTSB CHI76DEM20Accident · No injuriesClosedCessna 150G · Mikado, MINov 5, 1975 · N3961J · Substantial damage NTSB CHI76FEM07Accident · Minor injuriesClosedCessna 150G · Nunica, MIAug 18, 1975 · N2441J · Substantial damage NTSB CHI75AC083Accident · 1 fatalClosedCessna 150G · Prudenville, MIMay 6, 1975 · N2910S · Substantial damage NTSB CHI73AC063Accident · 2 fatalClosedCessna 150G · Berrien Spgs, MIJan 14, 1973 · N4033J · Destroyed NTSB CHI72FEM48Accident · No injuriesClosedCessna 150 · Traverse Cty, MIJan 21, 1972 · N8425J · Substantial damage NTSB CHI72FEM34Accident · No injuriesClosedCessna 150G · Montague, MISep 24, 1971 · N3444J · Substantial damage NTSB CHI71DDW35Accident · No injuriesClosedCessna 150 · Owosso, MIFeb 13, 1971 · N3677J · Substantial damage NTSB CHI70F0339Accident · No injuriesClosedCessna 150 · Wixom, MINov 12, 1969 · N3693J · Destroyed NTSB CHI69F0638Accident · Serious injuriesClosedCessna 150 · Lansing, MIMay 2, 1969 · N6317S · No damage NTSB CHI69F0613Accident · No injuriesClosedCessna 150 · Grand Ledge, MIApr 24, 1969 · N6343S · Substantial damage NTSB CHI69F0593Accident · No injuriesClosedCessna 150G · Lansing, MIApr 11, 1969 · N6317S · Substantial damage NTSB CHI69F0386Accident · Serious injuriesClosedCessna 150G · Nn Arbor, MIDec 11, 1968 · N4716X · Substantial damage NTSB CHI69F0205Accident · Minor injuriesClosedCessna 150 · Troy, MIAug 19, 1968 · N4641X · Substantial damage NTSB CHI69A0006Accident · 1 fatalClosedCessna 150G · Three Rivers, MIJul 16, 1968 · N2969S · Destroyed NTSB CHI68F0446Accident · No injuriesClosedCessna 150G · Ypsilanti, MIDec 13, 1967 · N2776S · Substantial damage NTSB CHI68F0189Accident · No injuriesClosedCessna 150G · Traverse Cty, MIJul 11, 1967 · N8464J · Substantial damage NTSB CHI68F0005Accident · No injuriesClosedCessna 150G · Raverse Cty, MIMay 23, 1967 · N8464J · Substantial damage NTSB CHI67F0543Accident · No injuriesClosedCessna 140 · Dowagiac, MIMar 2, 1967 · N3883J · Substantial damage NTSB CHI67F0509Accident · No injuriesClosedCessna 150 · Dowagiac, MIFeb 28, 1967 · N3620J · Substantial damage NTSB CHI67F0386Accident · No injuriesClosedCessna 150 · Plymouth, MIDec 11, 1966 · N3178X · Substantial damage