Skip to content

NTSB investigations: Cessna 150G, WI

25 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

19672026

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 ('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\" = '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 ('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" = '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 ('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 CHI08CA084Accident · No injuriesData collectionFinal reportCessna 150G · Viroqua, WIThe pilot not maintaining directional control during the landing and the ground loop the pilot encountered. A factor was the crosswind.Feb 16, 2008 · N10RH · Substantial damage NTSB CHI02LA138Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Kenosha, WIThe student pilot's failure to use carburetor heat, and the flight instructor's inadequate supervision of the flight.May 19, 2002 · N8657J · Substantial damage NTSB CHI96LA271Accident · No injuriesLimited investigationFinal reportCessna 150 · Wisconsin Rapid, WIfuel exhaustion, due to the pilot's improper planning/decision and inadequate fuel management.Aug 2, 1996 · N3238X · Substantial damage NTSB CHI90LA107Accident · No injuriesLimited investigationFinal reportCessna 150G · Franklin, WIInadequate compensation for wind conditions by the pilot, and his failure to maintain runway alignment during the attempted go-around (aborted landing). The wind conditions and soft terrain were related factors.Apr 5, 1990 · N3876J · Substantial damage NTSB CHI89LA133Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Iola, WIThe improper preflight planning by the pilot in command resulting in the airplane fuel quantity being near the unusable quantity which resulted in total loss of engine power due to fuel starvation while maneuvering. Contributing to the accident was the pilots…Jul 12, 1989 · N4054J · Substantial damage NTSB CHI83LA216Accident · No injuriesLimited investigationFinal reportCessna 150 · Janesville, WIN13364 had stopped short of the runway for a run-up check prior to takeoff. The pilot of N8576J continued his taxi while he was checking the field elevation and setting his altimeter he taxied into the empennage of N13364.May 16, 1983 · N8576J · 2 aircraft · Minor damage NTSB CHI81DEP16Accident · No injuriesClosedCessna 150E · Palmyra, WIApr 20, 1981 · N3901J · Substantial damage NTSB CHI80DER68Accident · No injuriesClosedCessna 150 · Osceola, WISep 22, 1980 · N8582J · Substantial damage NTSB CHI78DEP26Accident · No injuriesClosedCessna 150 · Delavan, WIMar 11, 1978 · N3639J · Substantial damage NTSB CHI76DEP30Accident · Minor injuriesClosedCessna 150 · Albany, WIMay 9, 1976 · N2931S · Substantial damage NTSB CHI76FER05Accident · No injuriesClosedCessna 150G · Rice Lake, WINov 15, 1975 · N3940J · Substantial damage NTSB CHI73FEP43Accident · Serious injuriesClosedCessna 150G · Monroe, WIMar 29, 1973 · N2418J · Destroyed NTSB CHI73DER01Accident · No injuriesClosedCessna 150G · New Richmond, WIJul 31, 1972 · N3998J · Substantial damage NTSB CHI73FEP04Accident · No injuriesClosedCessna 150G · Genoa City, WIJul 21, 1972 · N3794J · Substantial damage NTSB CHI71DDJ04Accident · No injuriesClosedCessna 150 · Platteville, WIJul 10, 1970 · N3679J · Substantial damage NTSB CHI70AC091Accident · No injuriesClosedCessna 150G · Burlington, WIJun 18, 1970 · N2213J · 2 aircraft · Minor damage NTSB CHI70D0330Accident · No injuriesClosedCessna 150 · Platteville, WIOct 25, 1969 · N3227J · Substantial damage NTSB CHI70F0236Accident · No injuriesClosedCessna 150 · Kansasville, WIAug 26, 1969 · N3906J · Substantial damage NTSB CHI69D0300Accident · No injuriesClosedCessna 150 · Black Rvr Fls, WIAug 30, 1968 · N3679J · Substantial damage NTSB CHI69D0167Accident · Minor injuriesClosedCessna 150 · Franklin, WIJul 31, 1968 · N3906J · Destroyed NTSB CHI68D0664Accident · No injuriesClosedCessna 150 · Pulaski, WIMar 21, 1968 · N2213J · Substantial damage NTSB CHI68D0544Accident · No injuriesClosedCessna 150 · Superior, WIJan 13, 1968 · N2707S · Substantial damage NTSB CHI68D0091Accident · No injuriesClosedCessna 150 · Black R.Fall, WIJun 25, 1967 · N3679J · Substantial damage NTSB CHI68D0049Accident · No injuriesClosedCessna 150 · Franklin, WIJun 21, 1967 · N3876J · Substantial damage NTSB MKC67F0617Accident · No injuriesClosedCessna 150G · Wonewak, WIApr 25, 1967 · N4685X · Substantial damage