Skip to content

NTSB investigations: Cessna 150H, IL

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

19682026

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 ('2071818')) 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 ('2071818'))
  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 ('2071818'))
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 CHI05LA033Accident · No injuriesLimited investigationFinal reportCessna 150H · Columbia, ILA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight. Factors were the unsuitable field encountered during the forced landing, the muddy field, and the dark night.Nov 24, 2004 · N6932S · Substantial damage NTSB CHI92LA154Accident · 1 fatalLimited investigationFinal reportCessna 150H · Robinson, ILPoor judgement by the pilot in intentionally proceeding to the airport in instrument meteorological conditions. The weather conditions were a factor.May 20, 1992 · N7200S · Substantial damage NTSB CHI91LA039Accident · No injuriesLimited investigationFinal reportCessna 150 · Niota, ILFuel consumption calculations misjudged by the PIC. Contributing factors were a tailwind landing and no suitable terrain.Nov 29, 1990 · N50098 · Substantial damage NTSB CHI87LA108Accident · No injuriesLimited investigationFinal reportCessna 150H · Tinley Park, ILApproximately 3 miles short of the destination arpt the plt stated that the engine quit. The acft was lined up with a road but due to heavy traffic the plt elected to stall the acft into nearby trees. Examination of the acft by the FAA following the accident…Apr 6, 1987 · N50305 · Destroyed NTSB CHI80FEV11Accident · No injuriesClosedCessna 150H · Springfield, ILDec 3, 1979 · N22931 · Substantial damage NTSB CHI78FEE27Accident · Serious injuriesClosedCessna 150 · Plainfield, ILMar 9, 1978 · N6662S · No damage NTSB CHI77FEV45Accident · No injuriesClosedCessna 150H · Carbondale, ILSep 27, 1977 · N50111 · Substantial damage NTSB CHI77FA050Accident · 1 fatalClosedCessna 150H · Benton, ILJun 13, 1977 · N7087S · Destroyed NTSB CHI77DEV20Accident · No injuriesClosedCessna 150 · Thompsonville, ILApr 16, 1977 · N23127 · Substantial damage NTSB CHI76DEV66Accident · No injuriesClosedCessna 150 · Eldorado, ILSep 5, 1976 · N50250 · Substantial damage NTSB CHI76FEE63Accident · Minor injuriesClosedCessna 150H · Sandwich, ILJun 20, 1976 · N755J · Substantial damage NTSB CHI75FEV30Accident · No injuriesClosedCessna 150H · Pittsfield, ILApr 12, 1975 · N23303 · Substantial damage NTSB CHI74FEV06Accident · No injuriesClosedCessna 150H · Paris, ILJul 25, 1973 · N6478S · Substantial damage NTSB CHI73FEV19Accident · Minor injuriesClosedCessna 150H · Albion, ILDec 29, 1972 · N50344 · Substantial damage NTSB CHI73DCA02Accident · No injuriesClosedCessna 150H · Cahokia, ILNov 12, 1972 · N22473 · Substantial damage NTSB CHI73FEE19Accident · No injuriesClosedCessna 150H · Deerfield, ILAug 25, 1972 · N7287S · Substantial damage NTSB CHI72DEE38Accident · No injuriesClosedCessna 150 · Sandwich, ILOct 18, 1971 · N5944G · Substantial damage NTSB CHI72FEV13Accident · No injuriesClosedCessna 150 · Manito, ILAug 16, 1971 · N6510S · Substantial damage NTSB CHI71DBD62Accident · No injuriesClosedCessna 150H · Midlothian, ILMar 24, 1971 · N6946S · Substantial damage NTSB CHI71DBD50Accident · No injuriesClosedCessna 150 · Ringwood, ILJan 22, 1971 · N6534S · Substantial damage NTSB CHI71FBD30Accident · Minor injuriesClosedCessna 150H · Sandwich, ILOct 11, 1970 · N50240 · Substantial damage NTSB CHI70AC043Accident · 1 fatalClosedCessna 150H · Collinsville, ILJan 4, 1970 · N22419 · 2 aircraft · Destroyed NTSB CHI70D0397Accident · No injuriesClosedCessna 150 · Streator, ILNov 21, 1969 · N22102 · Substantial damage NTSB CHI69D0673Accident · Minor injuriesClosedCessna 150 · Lockport, ILMay 11, 1969 · N23502 · Substantial damage NTSB CHI69D0579Accident · No injuriesClosedCessna 150J · Carmi, ILMar 15, 1969 · N50344 · Substantial damage NTSB CHI69A0050Accident · 2 fatalClosedCessna 150 · Frankfort, ILNov 15, 1968 · N22532 · Destroyed NTSB CHI69A0047Accident · 2 fatalClosedCessna 150H · Mattoon, ILNov 7, 1968 · N6519S · Destroyed NTSB CHI69D0351Accident · No injuriesClosedCessna 150 · Lockport, ILOct 26, 1968 · N23019 · Substantial damage NTSB CHI69F0203Accident · Minor injuriesClosedCessna 150 · Alton, ILSep 7, 1968 · N22959 · Substantial damage NTSB CHI69F0240Accident · Minor injuriesClosedCessna 150H · East St.Louis, ILAug 20, 1968 · N23486 · Substantial damage NTSB CHI69F0132Accident · No injuriesClosedCessna 150 · Mattoon, ILJul 12, 1968 · N6519S · Substantial damage