Fatal NTSB investigations: Cessna 150A

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

Fatal NTSB investigations: Cessna 150A per year, 1964–2026: 16 cases
1964	3
1966	1
1967	1
1969	2
1970	1
1973	2
1975	1
1976	1
1984	1
2001	1
2019	1
2022	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."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071804')) 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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071804'))
  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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071804'))
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 WPR23FA073Accident · 1 fatalClass 3 · FieldFinal reportCessna 150A · Santa Monica, CAA failure of the No. 1 piston connecting rod bearing journal due to oil starvation for reasons that could not be determined, which resulted in a complete loss of engine power.Dec 22, 2022 · N7032X · Substantial damage NTSB WPR20FA018Accident · 2 fatalClass 3 · FieldFinal reportCessna 150 · Brawley, CAThe pilot’s decision to perform a flight while impaired by the effects of alcohol and cocaine, and his failure to maintain terrain clearance during the flight.Oct 31, 2019 · N7158X · Substantial damage NTSB NYC01FA123Accident · 2 fatalField investigationFinal reportCessna 150A · Jackson Twp., PAThe pilot's inadequate visual lookout while manuevering at low level. A factor was the pilot's improper decision to conduct low-level flight.May 13, 2001 · N7064X · Substantial damage NTSB CHI84FA354Accident · 3 fatalField investigationFinal reportCessna 150A · Twin Lake, MIThe acft collided with the ground in a spiral like descent with the eng in a power retarded state as evidenced by the sound effects. The was no missing or backfiring of the power plant. The acft struck the ground vertically after being seen in a nose dwn…Aug 23, 1984 · N7250X · Substantial damage NTSB FTW77FA010Accident · 2 fatalClosedCessna A150M · Cypress, TXNov 5, 1976 · N9871J · Destroyed NTSB OAK75AP052Accident · 1 fatalClosedCessna 150A · Kingsburg, CAMay 22, 1975 · N7230X · Destroyed NTSB FTW74AF048Accident · 1 fatalClosedCessna 150A · Grand Isle, LADec 27, 1973 · N7133X · Destroyed NTSB MIA74AM003Accident · 1 fatalClosedCessna 150L · Wicksburg, ALJul 11, 1973 · N7007X · Destroyed NTSB MEX71A0051Accident · 2 fatalClosedCessna 150A · San Quintin, MexicoAug 29, 1970 · N8916S · Destroyed NTSB CHI70A0002Accident · 1 fatalClosedCessna 150 · Odell, ILJul 3, 1969 · N7156X · Destroyed NTSB DIA69A0039Accident · 1 fatalClosedCessna 150 · Flintstone, MDFeb 2, 1969 · N7244X · Destroyed NTSB DIA67A0014Accident · 2 fatalClosedCessna 150A · Wakefield, VAApr 16, 1967 · N7013X · Destroyed NTSB LAX67A0018Accident · 1 fatalClosedCessna 150A · S.Catalina Is., CAAug 9, 1966 · N7160X · Destroyed NTSB UNK65X0868Accident · 1 fatalClosedCessna 150 · Georgetown, TXNov 28, 1964 · N7123X · Destroyed NTSB UNK65X0809Accident · 3 fatalClosedCessna 150D · Pomona, CANov 23, 1964 · N4359U · 2 aircraft · Destroyed NTSB UNK64X3403Accident · 2 fatalClosedCessna 150A · Clarksdale, MSAug 15, 1964 · N7022X · Destroyed