Skip to content

NTSB investigations: Cessna 150G, IL

40 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" = 'IL' 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\" = 'IL' 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" = 'IL' 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 CEN15LA114Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Pontiac, ILThe flight instructor’s loss of directional control during an attempted go-around with a crosswind. Contributing to the accident was the loss of engine power for reasons that could not be determined during examination of the engine.Jan 9, 2015 · N2871S · Substantial damage NTSB CHI01LA068Accident · No injuriesLimited investigationFinal reportCessna 150G · La Rose, ILthe pilot's inadequate airplane preflight and the snow covered terrain. A factor was the fuel exhaustion.Jan 18, 2001 · N6281S · Substantial damage NTSB CHI94LA298Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Centralia, ILfuel exhaustion as a result of the pilots improper fuel calculation and improper use of fuel mixture.Aug 26, 1994 · N6307S · Substantial damage NTSB CHI87LA038Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Rockford, ILShortly after takeoff at about 100 feet AGL, pilot reports the engine lost power, aircraft stalled, entered a spin, and collided with the ground. Inspection of the aircraft and magnetos did not disclose any discrepancies other than possible coil deterioration.Nov 28, 1986 · N8703S · Destroyed NTSB CHI84LA079Accident · No injuriesLimited investigationFinal reportCessna 150G · Plato Center, ILThe acft nosed over during a forced landing after the engine lost power. After the accident oil samples from the acft were analyzed and found to contain anti-freeze. The acft owner suspected sabotage.Jan 8, 1984 · N2396U · Substantial damage NTSB CHI83LA415Accident · No injuriesLimited investigationFinal reportCessna 150G · Paris, ILThe student plt was on his 1st solo x-country flt. On the 1st leg of the flt, he became disoriented, experienced fuel exhaustion & landed in a soybean field. During the landing, the acft nosed over when the gear encountered the tall beans. The student…Sep 5, 1983 · N6227S · Substantial damage NTSB CHI79DEE35Accident · No injuriesClosedCessna 150 · Spring Valley, ILJan 22, 1979 · N3089S · Substantial damage NTSB CHI78DEE66Accident · No injuriesClosedCessna 150 · Aperville, ILJul 18, 1978 · N3026S · Substantial damage NTSB CHI76FEV60Accident · Minor injuriesClosedCessna 150G · Pekin, ILAug 22, 1976 · N6342S · Substantial damage NTSB NYC74AN022Accident · 1 fatalClosedCessna 172H · Wheeling, ILSep 13, 1973 · N2665L · 2 aircraft · Minor damage NTSB CHI74FEE11Accident · No injuriesClosedCessna 150 · Wheeling, ILAug 20, 1973 · N3135J · Substantial damage NTSB CHI73FCA05Accident · Minor injuriesClosedCessna 150 · Cahokia, ILMay 18, 1973 · N6272S · Substantial damage NTSB CHI73DEE15Accident · No injuriesClosedCessna 150G · Naperville, ILAug 12, 1972 · N2951J · Substantial damage NTSB CHI72FEE74Accident · No injuriesClosedCessna 150G · Northbrook, ILApr 23, 1972 · N3135J · Substantial damage NTSB CHI71FEV40Accident · No injuriesClosedCessna 150 · Manito, ILMay 10, 1971 · N3821J · Substantial damage NTSB CHI71FBD59Accident · No injuriesClosedCessna 150 · Naperville, ILMar 28, 1971 · N4611X · Substantial damage NTSB CHI71DBD63Accident · No injuriesClosedCessna 150 · Ringwood, ILMar 17, 1971 · N2216J · Substantial damage NTSB CHI71FBQ15Accident · No injuriesClosedCessna 150 · Macomb, ILSep 3, 1970 · N6330S · Substantial damage NTSB CHI71DBD19Accident · No injuriesClosedCessna 150G · Wheeling, ILAug 26, 1970 · N4641X · Substantial damage NTSB CHI70DBD26Accident · No injuriesClosedCessna 150G · Naperville, ILApr 29, 1970 · N3045S · Substantial damage NTSB CHI70AC053Accident · 2 fatalClosedCessna 150G · Rantoul, ILFeb 16, 1970 · N2968J · Destroyed NTSB CHI70DBD06Accident · No injuriesClosedCessna 150 · Roselle, ILJan 11, 1970 · N6227S · Substantial damage NTSB CHI70DBD03Accident · No injuriesClosedCessna 150 · Wheeling, ILJan 10, 1970 · N3076S · Substantial damage NTSB CHI70DBD09Accident · No injuriesClosedCessna 150G · Wauconda, ILJan 5, 1970 · N3135J · Substantial damage NTSB CHI70D0351Accident · No injuriesClosedCessna 150G · E.St Louis, ILDec 2, 1969 · N6309S · Substantial damage NTSB CHI70F0139Accident · No injuriesClosedCessna 150G · Springfield, ILAug 4, 1969 · N3276J · Substantial damage NTSB CHI69D0437Accident · No injuriesClosedCessna 150G · Streator, ILDec 24, 1968 · N6227S · Substantial damage NTSB CHI69D0187Accident · No injuriesClosedCessna 150 · Streator, ILAug 15, 1968 · N2440J · Substantial damage NTSB CHI69F0333Accident · Serious injuriesClosedCessna 150 · Carmi, ILAug 14, 1968 · N6370S · Substantial damage NTSB CHI69F0079Accident · No injuriesClosedCessna 150 · Wheeling, ILJul 7, 1968 · N6352S · Substantial damage NTSB CHI68F0573Accident · Minor injuriesClosedCessna 150G · Midlothian, ILFeb 3, 1968 · N3200J · Substantial damage NTSB CHI68D0522Accident · No injuriesClosedCessna 150G · Carbondale, ILDec 26, 1967 · N3191J · Substantial damage NTSB CHI68D0390Accident · No injuriesClosedCessna 150 · Streator, ILOct 14, 1967 · N3093S · Substantial damage NTSB CHI68F0284Accident · No injuriesClosedCessna 150 · Warren, ILAug 23, 1967 · N2985J · Substantial damage NTSB CHI68D0315Accident · No injuriesClosedCessna 150 · Freeport, ILAug 6, 1967 · N3286J · Substantial damage NTSB CHI68D0484Accident · No injuriesClosedCessna 150 · Lawrenceville, ILMay 27, 1967 · N3748J · Substantial damage NTSB CHI67D0485Accident · No injuriesClosedCessna 150 · Streator, ILMar 3, 1967 · N2440J · Substantial damage NTSB CHI67D0586Accident · No injuriesClosedCessna 150 · Peoria, ILFeb 4, 1967 · N3829J · Substantial damage NTSB CHI67F0585Accident · No injuriesClosedCessna 150G · Camp Grove, ILJan 23, 1967 · N3621J · Substantial damage NTSB CHI67D0298Accident · No injuriesClosedCessna 150G · Rockford, ILOct 8, 1966 · N3728J · Substantial damage