NTSB investigations: Cessna 150K, IA

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

19702026

NTSB investigations: Cessna 150K, IA per year, 1970–2026: 10 cases
1970	3
1972	1
1973	2
1974	2
1975	1
1987	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" = 'IA' 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 ('2071822')) 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\" = 'IA' 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 ('2071822'))
  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" = 'IA' 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 ('2071822'))
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 MKC87LA182Accident · No injuriesLimited investigationFinal reportCessna 150K · Dubuque, IANearing completion of a personal xc flt, acft experienced a total loss of power. An emergency ldg was made approximately 3 miles short of destination apt. Acft struck terrain and nosed over. Post flt investigation revealed usable fuel supply exhausted.Sep 30, 1987 · N6206G · Substantial damage NTSB MKC75FCD34Accident · No injuriesClosedCessna 150 · Lawton, IAFeb 19, 1975 · N5953G · Substantial damage NTSB MKC75AK027Accident · 1 fatalClosedCessna 150K · Hedrick, IANov 6, 1974 · N6463G · Destroyed NTSB MKC75FCD14Accident · Minor injuriesClosedCessna 150 · Runnells, IAAug 24, 1974 · N5753G · Substantial damage NTSB MKC74DCD20Accident · No injuriesClosedCessna 150 · Waterloo, IANov 4, 1973 · N6328G · Substantial damage NTSB MKC73DCD50Accident · No injuriesClosedCessna 150K · Mitchellvile, IAMar 7, 1973 · N5913G · Substantial damage NTSB MKC73DCD41Accident · No injuriesClosedCessna 150K · Waterloo, IADec 15, 1972 · N6404G · Substantial damage NTSB MKC71FCD28Accident · Minor injuriesClosedCessna 150K · Council Bluf, IASep 26, 1970 · N6419G · Substantial damage NTSB MKC71FCD21Accident · No injuriesClosedCessna 150K · Leighton, IAAug 26, 1970 · N6274G · Substantial damage NTSB MKC71DCD17Accident · No injuriesClosedCessna 150K · Iowa Falls, IAAug 2, 1970 · N5684G · Substantial damage