Skip to content

NTSB investigations: Cessna 150B, CA

27 cases on aircraft the registry lists as Cessna 150B. 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 ('2071806')) 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 ('2071806'))
  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 ('2071806'))
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 LAX86FA183Accident · 1 fatalField investigationFinal reportCessna 150B · Bermuda Dunes, CAThe purpose of the research & development flight was to document through the use of videotape the deployment & trajectory of a speciality parachute which was connected to a ballast bag. The plt, who was the designer of the device, utilized his experimental…Apr 21, 1986 · N1118Y · Destroyed NTSB LAX86FA066Accident · 1 fatalField investigationFinal reportCessna 150 · Oxnard, CAThe acft took off, pitched up steeply, stalled, nosed over to the right and crashed, nose down into the grass south of the rwy. Post accident inspection of the acft disclosed that the 2 inch bolt the plt used as a control gust lock for the elevator and…Dec 13, 1985 · N7310X · Destroyed NTSB LAX83LA025Accident · No injuriesLimited investigationFinal reportCessna 150B · Los Angeles, CAAccording to the pilot, the aircraft departed on a cross-country flight with partially filled fuel tanks. Enroute, over the santa monica mountains the engine quit from fuel exhaustion. After hitting a highway sign during the approach, the aircraft landed on…Nov 3, 1982 · N7280X · Substantial damage NTSB LAX78FUG46Accident · 1 fatalClosedCessna 150B · Rialto, CAAug 4, 1978 · N1161Y · 2 aircraft · Destroyed NTSB LAX77FUD01Accident · Serious injuriesClosedCessna 150B · Baldwin Hills, CADec 4, 1976 · N1136Y · Substantial damage NTSB LAX76FUQ19Accident · No injuriesClosedCessna 150 · Lancaster, CADec 23, 1975 · N7314X · Substantial damage NTSB OAK75FXQ48Accident · No injuriesClosedCessna 150 · Silver Springs, CAJun 22, 1975 · N7372X · Substantial damage NTSB OAK75DVD44Accident · No injuriesClosedCessna 150 · Brentwood, CAApr 20, 1975 · N7266X · Substantial damage NTSB OAK71FVG56Accident · Serious injuriesClosedCessna 150B · Lincoln, CAMar 16, 1971 · N7304X · Destroyed NTSB OAK70D0134Accident · No injuriesClosedCessna 150 · Concord, CASep 23, 1969 · N1131Y · Substantial damage NTSB LAX69A0031Accident · 5 fatalClosedCessna 150B · Santa Paula, CADec 8, 1968 · N1192Y · 2 aircraft · Destroyed NTSB LAX69D0128Accident · No injuriesClosedCessna 150 · Borego Spgs, CASep 28, 1968 · N1211Y · Substantial damage NTSB OAK69F0104Accident · Serious injuriesClosedCessna 150 · San Lorenzo, CAAug 13, 1968 · N7347X · Destroyed NTSB LAX67D0344Accident · Minor injuriesClosedCessna 150 · Apple Valley, CAMar 3, 1967 · N1191Y · Substantial damage NTSB OAK67F0189Accident · Serious injuriesClosedCessna 150 · Antioch, CADec 9, 1966 · N1218Y · Destroyed NTSB OAK67D0076Accident · No injuriesClosedCessna 150 · Stockton, CAAug 6, 1966 · N7304X · Substantial damage NTSB OAK66D0251Accident · No injuriesClosedCessna 150B · Tracy, CAApr 25, 1966 · N7266X · Substantial damage NTSB LAX66D0321Accident · No injuriesClosedCessna 150 · Hemit, CAMar 31, 1966 · N7311X · Substantial damage NTSB LAX66F0187Accident · Serious injuriesClosedCessna 150 · Fillmore, CANov 26, 1965 · N1270Y · Destroyed NTSB OAK66D0119Accident · No injuriesClosedCessna 150 · Hanford, CANov 1, 1965 · N1257Y · Substantial damage NTSB LAX66F0034Accident · Minor injuriesClosedCessna 150 · Laverne, CAMay 22, 1965 · N7386X · Substantial damage NTSB LAX65A0073Accident · 1 fatalClosedCessna 150B · Santa Maria, CAFeb 27, 1965 · N1154Y · Destroyed NTSB UNK65X0218Accident · No injuriesClosedCessna 150 · San Jose, CAOct 10, 1964 · N7374X · Substantial damage NTSB UNK64X3842Accident · No injuriesClosedCessna 150 · San Jose, CASep 7, 1964 · N7310X · Substantial damage NTSB UNK64X3385Accident · 2 fatalClosedCessna 150 · Monterey, CAAug 14, 1964 · N7369X · Destroyed NTSB UNK64X2606Accident · No injuriesClosedCessna 150 · Palm Spgs, CAJul 2, 1964 · N1117Y · Substantial damage NTSB UNK64X0240Accident · Serious injuriesClosedCessna 150B · San Jose, CAJan 13, 1964 · N7294X · Destroyed