Skip to content

NTSB investigations: Cessna 150H, WI

22 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" = '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 ('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\" = '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 ('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" = '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 ('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 CHI08CA130Accident · No injuriesData collectionFinal reportCessna 150 · Pulaski, WIThe student pilot's failure to take remedial action in response to a porpoise/pilot-induced oscillation during landing. Factors were the porpoise, the pilot's lack of experience, and the separation of the nose landing gear.May 14, 2008 · N22997 · Substantial damage NTSB CHI07CA087Accident · No injuriesData collectionFinal reportCessna 150 · LaCrosse, WIThe dual student's failure to maintain the proper glidepath and clearance from terrain and the flight instructor's delayed remedial action. A factor was the flight instructor's fatigue.Mar 9, 2007 · N7272S · Substantial damage NTSB CHI01LA074Accident · No injuriesLimited investigationFinal reportCessna 150H · Burlington, WIAircraft control not maintained by the pilot during the landing roll. Factors to the accident were the loss of engine power for undetermined reasons, the end of the runway being snow-covered, and the snowbank.Jan 28, 2001 · N22026 · Substantial damage NTSB CHI00LA074Accident · No injuriesLimited investigationFinal reportCessna 150H · Wisconsin Rapid, WIThe student pilot's failure to maintain directional control. Factors were the pilot's lack of total experience and the snowbank.Feb 21, 2000 · N22017 · Substantial damage NTSB CHI98LA226Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Osceola, WIthe student pilot's incomplete preflight, and the instructor pilot's inadequate supervision of the student's preflight. Factors were the fuel contaminated with water, and the roadway encountered during the forced landing rollout.Jun 28, 1998 · N50433 · Substantial damage NTSB CHI88LA037Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Mt. Pleasant, WIThe stu plt climbed to 1600 ft MSL aft tkof. Shortly aft level off, the engine stopped. He attempted an air start without success. During the forced lndg the nose wheel dug in and the acft nosed over in the soft soil. During a post crash interview, the stu…Dec 25, 1987 · N6468S · Substantial damage NTSB CHI88LA019Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Cumberland, WIAt 0112 CST, the plt telephoned the fss & requested a wx outlook for a 0600 CST departure. The wx briefer adzd the wx to the south was deteriorating & that the destn would be IFR by about the planned departure time. Also, the briefer suggested the plt could…Nov 8, 1987 · N6501S · Destroyed NTSB CHI88LA004Accident · No injuriesLimited investigationFinal reportCessna 150H · Elroy, WIUpon attempting his tenth touch and go the student pilot noticed, prior to touchdown, that the aircraft was to the right of the runway. In an attempt to realign himself with the runway the pilot stated he 'lowered' the left wing. The left wing then struck the…Oct 11, 1987 · N50124 · Substantial damage NTSB CHI87LA222Accident · No injuriesLimited investigationFinal reportCessna 150H · Sparta, WIThe plt was taking off on his pvt strip in a prevailing 12 kt x-wind that was vrbl & blowing fm a 'lull' to 18 KTS. He said the strip was located near an l-shaped ridge which attenuated the general wind flow. Also, he said the 1900' sod strip sloped downhill…Sep 27, 1987 · N6469S · Substantial damage NTSB CHI85LA384Accident · No injuriesLimited investigationFinal reportCessna 150H · Racine, WIThe pilot reported a gust of wind resulted in a nose high left turn just prior to touchdown. Power was added & the left wing contacted the runway. The aircraft went off the left side of the runway and hit a ditch.Sep 21, 1985 · N50433 · Substantial damage NTSB CHI84LA316Accident · No injuriesLimited investigationFinal reportCessna 150H · Menomonie, WIThe plt was disoriented during a x-country and circled the wrong area looking for an arpt until low fuel demanded a landing. During the approach the engine quit and the acft nosed over in a bean field during landing.Jul 28, 1984 · N6707S · Substantial damage NTSB CHI84LA032Accident · No injuriesLimited investigationFinal reportCessna 150 · La Crosse, WIThe acft was ditched in lake onalaska after the engine quit about 1 mile short of destination. After the accident the acft was pulled from the lake and examined. The 3 FAA inspectors who examined the acft verified that there was not enough fuel in the acft to…Oct 30, 1983 · N23183 · Substantial damage NTSB CHI84LA006Accident · No injuriesLimited investigationFinal reportCessna 150 · Neenah, WIThe plt was not lined up with the rwy during final & executed a go-around. He applied full power, retracted flaps, & theacft dropped onto the rwy nose gear first. The student plt had 5 hrs of dual & was no endorsed for solo flt.Oct 1, 1983 · N22774 · Substantial damage NTSB CHI82DA340Accident · No injuriesFinal reportCessna 150H · Genoa City, WIReturning from a cross-country flight the pilot overshot the touchdown point. During the go-around, the engine quit and the aircraft hit a tree. The pilot stated that he did not evaluate his fuel consumption properly.Sep 7, 1982 · N50318 · Substantial damage NTSB CHI77DEP31Accident · No injuriesClosedCessna 150 · Berlin, WIApr 9, 1977 · N23448 · Destroyed NTSB CHI76FEP16Accident · No injuriesClosedCessna 150H · Lake Geneva, WIOct 12, 1975 · N50127 · Substantial damage NTSB CHI75DEP63Accident · No injuriesClosedCessna 150H · Middleton, WIMay 13, 1975 · N50006 · Substantial damage NTSB CHI70DDJ18Accident · No injuriesClosedCessna 150H · Dodgeville, WIMay 21, 1970 · N6620S · Substantial damage NTSB CHI70F0341Accident · No injuriesClosedCessna 150 · Waukesha, WIOct 9, 1969 · N6526S · Substantial damage NTSB CHI69F0554Accident · No injuriesClosedCessna 150H · Dodgeville, WIMar 23, 1969 · N6620S · Substantial damage NTSB CHI69F0481Accident · No injuriesClosedCessna 150 · Beloit, WIJan 18, 1969 · N50322 · Destroyed NTSB CHI69D0310Accident · No injuriesClosedCessna 150 · Clintonville, WIOct 1, 1968 · N7235S · Substantial damage