Skip to content

NTSB investigations: Cessna 150J, WI

22 cases on aircraft the registry lists as Cessna 150J. 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" = '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 ('2071820')) 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 ('2071820'))
  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 ('2071820'))
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 CEN14CA515Accident · Minor injuriesData collectionFinal reportCessna 150J · Brookfield, WIThe pilot's inadequate maintenance and preflight of the airplane which resulted in a total loss of engine power due to oil starvation.Sep 22, 2014 · N50889 · Substantial damage NTSB CEN12LA133Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Denmark, WIThe pilot’s loss of control due to his alcohol impairment. Contributing to the accident was the pilot's decision to fly at night with a known interior lighting malfunction.Jan 12, 2012 · N60676 · Substantial damage NTSB CHI07CA123Accident · Minor injuriesData collectionFinal reportCessna 150J · Amery, WIThe pilot's failure to maintain control of the airplane during the aborted landing attempt which resulted in the airplane impacting trees. A misjudged flare, subsequent bounced landing, and gusty wind conditions were contributing factors.Apr 29, 2007 · N50486 · Substantial damage NTSB CHI03LA281Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Fennimore, WIThe loss of engine power in cruise flight due to carburetor icing. A factor was the unsuitable terrain the pilot encountered during his forced landing.Aug 23, 2003 · N61134 · Substantial damage NTSB CHI97LA088Accident · No injuriesLimited investigationFinal reportCessna 150J · La Valle, WIthe pilot's inadequate pre-flight planning/preparation which led to fuel exhaustion. A factor was the snow covered terrain.Mar 20, 1997 · N5526G · Substantial damage NTSB CHI93LA163Accident · No injuriesLimited investigationFinal reportCessna 150J · Rice Lake, WIThe student pilot's failure to maintain directional control of the airplane.May 5, 1993 · N61306 · Substantial damage NTSB CHI92LA147Accident · No injuriesLimited investigationFinal reportCessna 150 · Greenbay, WIA fractured rod end bolt which resulted in an unsteerable nosewheel.May 10, 1992 · N50610 · Substantial damage NTSB CHI89LA044Accident · No injuriesLimited investigationFinal reportCessna 150J · Osceola, WIInadequate preflight by the student pilot, inadequate supervision (to assure a proper preflight) by the instructor pilot (CFI), and water contamination of the fuel. The terrain was considered to be a contributing factor.Jan 15, 1989 · N61306 · Substantial damage NTSB CHI87LA131Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Neillsville, WIA student & instructor (CFI) were on a dual x-country flt fm elroy to Neillsville & rtrn. The flt to Neillsville was uneventfull. After the acft was on the gnd aprx 20 min, hot starting procedures were used to start the eng for the rtrn flt. Eng runup &…May 17, 1987 · N50499 · Destroyed NTSB CHI82FEP02Accident · No injuriesClosedCessna 150 · Hamburg, WIOct 4, 1981 · N60052 · Substantial damage NTSB CHI82FEP01Accident · No injuriesClosedCessna 150J · Waukesha, WIOct 1, 1981 · N51046 · Substantial damage NTSB CHI79FEP13Accident · No injuriesClosedCessna 150 · Sussex, WIDec 28, 1978 · N60422 · Substantial damage NTSB CHI78DEP32Accident · Minor injuriesClosedCessna 150 · Baileys Harbor, WIMay 16, 1978 · N60536 · Substantial damage NTSB CHI78FEP13Accident · No injuriesClosedCessna 150-J · Necedha, WIJan 29, 1978 · N51042 · Substantial damage NTSB CHI77FEP33Accident · Minor injuriesClosedCessna 150 · Waukesha, WIApr 26, 1977 · N51392 · Substantial damage NTSB CHI74FEP06Accident · Minor injuriesClosedBeech C23 · Milwaukee, WIAug 7, 1973 · N2102W · 2 aircraft · Substantial damage NTSB CHI71DER08Accident · No injuriesClosedCessna 150 · Cochrane, WIMay 29, 1971 · N50543 · Substantial damage NTSB CHI71DEP49Accident · No injuriesClosedCessna 150 · Appleton, WIMar 30, 1971 · N60049 · Substantial damage NTSB CHI71FDJ22Accident · No injuriesClosedCessna 182 · Middleton, WIOct 15, 1970 · N3018Y · 2 aircraft · Substantial damage NTSB CHI71FDJ19Accident · Serious injuriesClosedCessna 150J · Eau Claire, WIOct 5, 1970 · N61357 · Destroyed NTSB CHI70AC075Accident · 2 fatalClosedCessna 150J · Fond Du Lac, WIApr 28, 1970 · N5539G · Destroyed NTSB CHI70F0340Accident · No injuriesClosedCessna 150J · Lancaster, WINov 22, 1969 · N60713 · Substantial damage