Skip to content

NTSB investigations: Cessna 150L, WI

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

19702026

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 ('2071826')) 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 ('2071826'))
  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 ('2071826'))
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 CHI01LA301Accident · No injuriesLimited investigationFinal reportCessna 150L · Madison, WIThe deer which struck the empennage of the airplane during the landing flare.Sep 1, 2001 · N19302 · Substantial damage NTSB CHI91LA042Accident · No injuriesLimited investigationFinal reportCessna 150 · Portage, WIDelayed go-around and stall encountered. Contributing factors were a snow bank, proper alignment not attained, and raising the flaps not performed by the PIC.Dec 6, 1990 · N11327 · Substantial damage NTSB CHI91LA019Accident · No injuriesLimited investigationFinal reportCessna 150 · La Crosse, WIInadequate visual outlook by the PIC.Oct 30, 1990 · N7641G · Substantial damage NTSB CHI90LA209Accident · No injuriesLimited investigationFinal reportCessna 150 · Oshkosh, WILoss of engine power for an undetermined reason.Jul 30, 1990 · N11948 · Substantial damage NTSB CHI89FA113Accident · 1 fatalField investigationFinal reportCessna 150L · Wisc Rapids, WIThe pilot's failure to assure that the flaps were in the up position during takeoff. A factor related to the accident was the pilot's lack of familiarity with aircraft.Jun 18, 1989 · N6878G · Destroyed NTSB CHI85LA208Accident · No injuriesLimited investigationFinal reportCessna 150L · Necedah, WIAfter a flt with an instructor, the student took off on a solo flt. During a touch & go the student stated, '... I came in high & fast. I landed long and the aircraft bounced twice. I then panicked and pushed the control forward causing the nose to dive into…May 25, 1985 · N5481Q · Substantial damage NTSB CHI83LA109Accident · No injuriesLimited investigationFinal reportCessna 150 · Calumetville, WITais Cessna 150 collided with snow covered terrain while practicing the results of 'ground effect'. The weather was VMC and no flight plan was filed. The pilot was not injured in the accident. The flight originated at fond du lac WI at 1200 CST on feb. 12,…Feb 12, 1983 · N11454 · Substantial damage NTSB CHI81FEP07Accident · No injuriesClosedCessna 150L · Spencer, WINov 2, 1980 · N6773G · Substantial damage NTSB CHI81FEP05Accident · No injuriesClosedCessna 150L · Rhinelander, WIOct 11, 1980 · N7730G · Substantial damage NTSB CHI79DEP80Accident · No injuriesClosedCessna 150 · Platteville, WISep 24, 1979 · N11569 · Substantial damage NTSB CHI78DEP27Accident · No injuriesClosedCessna 150 · Black River, WIMar 22, 1978 · N18162 · Substantial damage NTSB CHI78DEP16Accident · No injuriesClosedCessna 150 · Kenosha, WIFeb 9, 1978 · N10428 · Substantial damage NTSB CHI78DEP12Accident · No injuriesClosedCessna 150L · Sun Prairie, WIJan 31, 1978 · N10735 · Substantial damage NTSB CHI76DEP51Accident · Minor injuriesClosedCessna 150 · Boscobel, WISep 22, 1976 · N11106 · Destroyed NTSB CHI75FEP60Accident · No injuriesClosedCessna 150L · Milwaukee, WIMay 31, 1975 · N1254Q · Substantial damage NTSB CHI75FEP33Accident · 2 fatalClosedCessna 150L · Slinger, WIOct 30, 1974 · N10430 · Destroyed NTSB CHI74DEP24Accident · No injuriesClosedCessna 150 · Crivitz, WIDec 10, 1973 · N10772 · Substantial damage NTSB CHI74DER03Accident · No injuriesClosedCessna 150L · Durand, WIOct 14, 1973 · N17295 · Substantial damage NTSB CHI74DEP02Accident · Minor injuriesClosedCessna 150L · Stoughton, WIJul 25, 1973 · N1328Q · Destroyed NTSB CHI73DEP42Accident · No injuriesClosedCessna 150 · Sheboygan, WIMay 3, 1973 · N18690 · Substantial damage NTSB CHI73DEP24Accident · No injuriesClosedCessna 150 · Palmyra, WIAug 14, 1972 · N1710Q · Substantial damage NTSB CHI71FDJ32Accident · Serious injuriesClosedCessna 150 · Strum, WIDec 12, 1970 · N6770G · Destroyed