Skip to content

NTSB investigations: Cessna 150A, CA

25 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

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" = 'CA' 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 ('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.\"eventStateOrRegion\" = 'CA' 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 ('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."eventStateOrRegion" = 'CA' 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 ('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 LAX98LA130Accident · Minor injuriesLimited investigationFinal reportCessna 150A · Apple Valley, CAThe pilot's selection of an unsuitable landing area.Mar 30, 1998 · N6640T · Substantial damage NTSB LAX78FUQ41Accident · Serious injuriesClosedCessna 150A · Pacoima, CAAug 6, 1978 · N7102X · Destroyed NTSB LAX77FUQ36Accident · No injuriesClosedCessna 150 · Palmdale, CAJul 2, 1977 · N7227X · Substantial damage NTSB LAX76DUQ33Accident · No injuriesClosedCessna 150 · Mojave, CAMar 27, 1976 · N6670T · Substantial damage NTSB OAK75AP052Accident · 1 fatalClosedCessna 150A · Kingsburg, CAMay 22, 1975 · N7230X · Destroyed NTSB LAX72FUQ01Accident · No injuriesClosedCessna 150 · Van Nuys, CAJul 5, 1971 · N7102X · Substantial damage NTSB OAK71DVG27Accident · No injuriesClosedCessna 150 · Los Molinos, CAOct 3, 1970 · N831DB · Substantial damage NTSB LAX70A0032Accident · No injuriesClosedTaylorcraft BC-12D · Santa Paula, CADec 9, 1969 · N39983 · 2 aircraft · Substantial damage NTSB LAX70F0201Accident · Serious injuriesClosedCessna 150 · Sta.Susana, CANov 8, 1969 · N7201X · Destroyed NTSB LAX69D0206Accident · No injuriesClosedCessna 150 · Yucca Valley, CANov 21, 1968 · N6655T · Substantial damage NTSB LAX68D0369Accident · No injuriesClosedCessna 150 · El Monte, CAApr 6, 1968 · N6685T · Substantial damage NTSB LAX68D0349Accident · No injuriesClosedCessna 150 · Compton, CAMar 30, 1968 · N8916S · Substantial damage NTSB LAX67D0299Accident · No injuriesClosedCessna 150 · Thermal, CAFeb 5, 1967 · N8916S · Substantial damage NTSB LAX67A0018Accident · 1 fatalClosedCessna 150A · S.Catalina Is., CAAug 9, 1966 · N7160X · Destroyed NTSB LAX66F0371Accident · No injuriesClosedCessna 150 · Lompoc, CAJun 2, 1966 · N7161X · Substantial damage NTSB LAX66D0361Accident · No injuriesClosedCessna 150 · Ojai, CAMay 25, 1966 · N6685T · Substantial damage NTSB LAX66F0242Accident · No injuriesClosedCessna 150 · Lompoc, CAFeb 12, 1966 · N7161X · Substantial damage NTSB LAX66F0245Accident · Minor injuriesClosedCessna 150 · San Diego, CAJan 25, 1966 · N7125X · Substantial damage NTSB LAX66D0227Accident · No injuriesClosedCessna 150 · Burbank, CAJan 20, 1966 · N830SR · Substantial damage NTSB LAX66D0119Accident · No injuriesClosedCessna 150 · Wasco, CASep 29, 1965 · N7102X · Substantial damage NTSB LAX65D0026Accident · No injuriesClosedCessna 170B · Hawthorne, CAJan 16, 1965 · N2819C · 2 aircraft · Minor damage NTSB UNK65X0809Accident · 3 fatalClosedCessna 150D · Pomona, CANov 23, 1964 · N4359U · 2 aircraft · Destroyed NTSB UNK64X2699Accident · No injuriesClosedCessna 150 · El Monte, CAJul 7, 1964 · N7091X · Substantial damage