NTSB investigations: Cessna 150, IL

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

19642026

NTSB investigations: Cessna 150, IL per year, 1964–2026: 10 cases
1964	2
1968	1
1969	1
1970	1
1971	1
1974	1
1976	1
1977	1
2002	1

Where

Open the map

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 ('2071802')) 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 ('2071802'))
  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 ('2071802'))
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 CHI02LA241Accident · No injuriesLimited investigationFinal reportCessna 150 · Belleville, ILDirectional control not obtained/maintained by the pilot during landing.Aug 1, 2002 · N8137S · Substantial damage NTSB CHI78FEE02Accident · No injuriesClosedCessna 150 · Kankakee, ILOct 2, 1977 · N6572T · Substantial damage NTSB CHI77FEE05Accident · No injuriesClosedCessna 150 · Oak Lawn, ILNov 5, 1976 · N17022 · Substantial damage NTSB CHI75AC030Accident · 2 fatalClosedCessna 150L · Morris, ILOct 8, 1974 · N19048 · Destroyed NTSB CHI71DBQ32Accident · No injuriesClosedCessna 150 · Sumner, ILFeb 20, 1971 · N383VU · Substantial damage NTSB CHI71AC023Accident · 2 fatalClosedCessna 150 · Mackinaw, ILSep 28, 1970 · N5901E · Destroyed NTSB CHI69A0096Accident · 1 fatalClosedCessna 150G · Ofallon, ILMay 20, 1969 · N3655J · Destroyed NTSB CHI69D0413Accident · No injuriesClosedCessna 150 · Kankakee, ILDec 23, 1968 · N7749E · Substantial damage NTSB UNK64X0748Accident · Minor injuriesClosedCessna 150 · Mouline, ILFeb 29, 1964 · N7933E · Destroyed NTSB UNK64X0422Accident · No injuriesClosedCessna 150 · Ringwood, ILFeb 1, 1964 · N5511E · Substantial damage