NTSB investigations: Cessna 150C, AZ

8 cases on aircraft the registry lists as Cessna 150C. 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 150C, AZ per year, 1964–2026: 8 cases
1964	2
1966	1
1970	1
1971	2
1972	1
2003	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" = 'AZ' 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 ('2071808')) 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\" = 'AZ' 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 ('2071808'))
  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" = 'AZ' 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 ('2071808'))
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 LAX03CA261Accident · No injuriesData collectionFinal reportCessna 150C · Tucson, AZthe pilot's inadequate inflight planning/decision, which resulted in fuel exhaustion and loss of engine power due to an inadequate fuel supply.Aug 22, 2003 · N7909Z · Substantial damage NTSB LAX72FUJ89Accident · Minor injuriesClosedCessna 150C · Chandler, AZApr 2, 1972 · N1932Z · Substantial damage NTSB LAX72AL035Accident · 2 fatalClosedCessna 150C · Tonopah, AZNov 16, 1971 · N7802Z · Destroyed NTSB LAX72DUJ28Accident · No injuriesClosedCessna 150 · Tempe, AZJul 25, 1971 · N2065Z · Substantial damage NTSB LAX71FUJ44Accident · No injuriesClosedCessna 150 · Mesa, AZNov 1, 1970 · N7976Z · Substantial damage NTSB LAX67F0176Accident · Minor injuriesClosedCessna 150 · Phoenix, AZOct 15, 1966 · N7802Z · Substantial damage NTSB UNK64X3376Accident · No injuriesClosedCessna 150 · Peoples, AZAug 14, 1964 · N1975Z · Substantial damage NTSB UNK64X0555Accident · No injuriesClosedCessna 150 · Tucson, AZFeb 13, 1964 · N2059Z · Substantial damage