Skip to content

NTSB investigations: Cessna 150F, IL

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

19652026

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 ('2071814')) 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 ('2071814'))
  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 ('2071814'))
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 CEN23LA191Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150F · Genoa, ILThe pilot’s failure to maintain airplane control during a go-around.May 18, 2023 · N6840F · Substantial damage NTSB CEN21LA335Accident · No injuriesClass 3 · LimitedFinal reportCessna 150F · Rock Falls, ILThe right seat pilot’s improper decision to perform a low approach with full flaps and the failure of the flaps to retract during the attempted go-around, which resulted in a forced landing.Jul 24, 2021 · N7893F · Substantial damage NTSB CHI06CA059Accident · No injuriesData collectionFinal reportCessna 150F · Poplar Grove, ILThe student pilot's inadequate recovery from the bounced landing, and not maintaining airplane control during the landing.Dec 20, 2005 · N8723S · Substantial damage NTSB CHI04LA254Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Ancona, ILThe pilot became incapacitated (unconscious) for undetermined reasons which resulted in his inability to maintain altitude.Sep 10, 2004 · N6544F · Substantial damage NTSB CHI92LA122Accident · No injuriesLimited investigationFinal reportCessna 150F · Centralia, ILThe pilot's failure to maintain the proper altitude during the final approach to landing. A factor in the accident was the pilot's delayed remedial action.Apr 4, 1992 · N6878F · Substantial damage NTSB CHI85LA074Accident · No injuriesLimited investigationFinal reportCessna 150F · Staunton, ILWhile taxiing for takeoff at a private airstrip, the acft contacted a parked truck. The plt attributed the collision to his lack of alertness.Dec 22, 1984 · N8232F · Substantial damage NTSB CHI82DA158Accident · No injuriesFinal reportCessna 150 · Bloomington, ILThe pilot stated that base and final approach at Bloomington-normal airport seemed smooth at 80 mph. At 8 ft above the runway the throttle was reduced to idle. Immediately at throttle reduction, the aircraft dropped to the runway landing on the main gear. The…May 8, 1982 · N8197F · Substantial damage NTSB CHI81FEE21Accident · Serious injuriesClosedCessna 150F · Marengo, ILMar 7, 1981 · N8945S · Substantial damage NTSB CHI78FA052Accident · 2 fatalClosedPiper PA-22 · East Moline, ILAug 6, 1978 · N3217B · 2 aircraft · Destroyed NTSB CHI76FEE21Accident · Minor injuriesClosedCessna 150 · Dekalb, ILSep 28, 1975 · N8179F · Substantial damage NTSB CHI75FEV39Accident · No injuriesClosedCessna 150 · Carbondale, ILJun 27, 1975 · N8490G · Substantial damage NTSB CHI75DEE35Accident · No injuriesClosedCessna 150 · Richton Park, ILDec 23, 1974 · N7137F · Substantial damage NTSB CHI75FEV07Accident · No injuriesClosedCessna 150 · Galatia, ILOct 15, 1974 · N3088X · Substantial damage NTSB CHI73AC090Accident · 2 fatalClosedCessna 150F · Hillsboro, ILMay 19, 1973 · N7756F · Destroyed NTSB CHI73FEV21Accident · Minor injuriesClosedCessna 150J · Marion, ILJan 30, 1973 · N61286 · Substantial damage NTSB CHI73FEE18Accident · No injuriesClosedCessna 150G · Shannon, ILAug 14, 1972 · N2823S · Substantial damage NTSB CHI72DEY06Accident · Minor injuriesClosedCessna 150F · Carbondale, ILJul 31, 1971 · N8028F · Substantial damage NTSB CHI71FBQ25Accident · No injuriesClosedCessna 150 · Carbondale, ILNov 7, 1970 · N3545L · Substantial damage NTSB CHI71DBQ24Accident · No injuriesClosedCessna 150 · Aledo, ILOct 31, 1970 · N8654G · Substantial damage NTSB CHI70FBQ10Accident · No injuriesClosedCessna 150 · Galesburg, ILApr 4, 1970 · N8631S · Substantial damage NTSB CHI70FBQ06Accident · No injuriesClosedCessna 150F · Mt Hawley, ILFeb 14, 1970 · N8700S · Substantial damage NTSB CHI70ABD05Accident · No injuriesClosedCessna 150 · Rockford, ILJan 10, 1970 · N7860F · Substantial damage NTSB CHI70D0212Accident · Minor injuriesClosedCessna 150 · Shabbona, ILSep 9, 1969 · N3516L · Substantial damage NTSB CHI70D0032Accident · No injuriesClosedCessna 150 · Minooka, ILJun 10, 1969 · N8382G · Substantial damage NTSB CHI69D0674Accident · No injuriesClosedCessna 150 · Ringwood, ILMay 22, 1969 · N6933F · Substantial damage NTSB CHI69F0548Accident · No injuriesClosedCessna 150 · Collinsville, ILMar 18, 1969 · N8391G · Substantial damage NTSB CHI69F0545Accident · No injuriesClosedCessna 150F · Danville, ILMar 15, 1969 · N8346G · Substantial damage NTSB CHI69F0507Accident · No injuriesClosedCessna 150 · West Chicago, ILMar 4, 1969 · N8982S · Substantial damage NTSB CHI69D0449Accident · No injuriesClosedCessna 150G · Wheeling, ILJan 19, 1969 · N2823S · Substantial damage NTSB CHI69D0447Accident · No injuriesClosedCessna 150F · Mendota, ILJan 10, 1969 · N8751G · Substantial damage NTSB CHI69D0510Accident · No injuriesClosedCessna 150F · Buckley, ILNov 23, 1968 · N8179F · Substantial damage NTSB CHI69F0245Accident · No injuriesClosedCessna 150 · Kankakee, ILSep 25, 1968 · N8839G · Substantial damage NTSB CHI69D0184Accident · No injuriesClosedCessna 150 · Wheeling, ILJul 27, 1968 · N8022S · Substantial damage NTSB CHI68D0665Accident · No injuriesClosedCessna 150 · Peoria, ILMar 20, 1968 · N6800F · Substantial damage NTSB CHI68F0490Accident · No injuriesClosedCessna 150 · Desoto, ILDec 8, 1967 · N3545L · Substantial damage NTSB CHI68D0267Accident · No injuriesClosedCessna 150 · Northbrook, ILAug 28, 1967 · N8602G · Substantial damage NTSB CHI68D0228Accident · No injuriesClosedCessna 150 · Greenwood, ILAug 16, 1967 · N6933F · Substantial damage NTSB CHI68D0193Accident · No injuriesClosedCessna 150 · Naperville, ILJun 29, 1967 · N7028F · Substantial damage NTSB CHI68D0101Accident · No injuriesClosedCessna 150 · Northbrook, ILJun 27, 1967 · N8602G · Substantial damage NTSB CHI68D0310Accident · No injuriesClosedCessna 150 · East Alton, ILJun 2, 1967 · N6547F · Substantial damage NTSB CHI67F0546Accident · No injuriesClosedCessna 150F · Cahokia, ILFeb 16, 1967 · N8279S · Substantial damage NTSB CHI67F0483Accident · Minor injuriesClosedCessna 150F · Northbrook, ILFeb 4, 1967 · N8022S · Substantial damage NTSB CHI67D0508Accident · No injuriesClosedCessna 150 · Lombard, ILDec 26, 1966 · N8002F · Substantial damage NTSB CHI67F0334Accident · No injuriesClosedCessna 150 · Northbrook, ILOct 2, 1966 · N3514J · 2 aircraft · Substantial damage NTSB CHI67D0220Accident · No injuriesClosedCessna 150 · Joliet, ILAug 27, 1966 · N6630F · Substantial damage NTSB CHI67D0346Accident · No injuriesClosedCessna 150 · Chicago, ILAug 6, 1966 · N3047X · Substantial damage NTSB CHI67D0124Accident · No injuriesClosedCessna 150 · Rockford, ILJul 30, 1966 · N8021S · Substantial damage NTSB CHI67F0323Accident · Serious injuriesClosedCessna 150F · Chicago, ILJul 24, 1966 · N8846S · Destroyed NTSB CHI67F0099Accident · No injuriesClosedCessna 150 · East St.Louis, ILJun 23, 1966 · N7973F · Substantial damage NTSB CHI67D0211Accident · No injuriesClosedCessna 150 · Northbrook, ILJun 22, 1966 · N8022S · Substantial damage