Skip to content

NTSB investigations: Cessna A150K, CA

17 cases on aircraft the registry lists as Cessna A150K. 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

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 ('2071824')) 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 ('2071824'))
  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 ('2071824'))
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 LAX85LA377Accident · No injuriesLimited investigationFinal reportCessna A150K · Avalon, CAThe plt said the operation was about 4 and 1/2 hours into a commercial fish spotting flt when the engine 'began to run rough, then quit altogether.' Attempts to restart the engine were unsuccessful and the plt completed a power-off ditching at sea. He and the…Aug 31, 1985 · N8409M · Destroyed NTSB LAX84LA295Accident · No injuriesLimited investigationFinal reportCessna A150K · Trona, CAThe acft settled back to the rwy and veered of the left side during takeoff. The plt stated that he attempt a short field takeoff and the acft would not accelerate to more than 60 mph. It settled onto the dirt off the left side of the rwy and groundlooped to…May 12, 1984 · N8376M · Substantial damage NTSB LAX84LA243Accident · No injuriesLimited investigationFinal reportCessna A150K · Chico, CAWhen the acft was about 7 mi from its destination, the eng lost power & the plt elected to land on an access road. During the landing roll, the left wing hit the top of a fence & the acft veered left. The nosewheel then struck a curb & the acft nosed over.…Apr 6, 1984 · N8334M · Substantial damage NTSB LAX83LA355Accident · 1 fatalLimited investigationFinal reportCessna A150K · Stonyford, CAThe acft collided with the ground while negotiating a low level aerobatic maneuver. The acft had departed a private ranch airstrip and according to a witness the acft was 'rolled'. After a few circles of the strip. The witness was surprised because the plt…Jul 23, 1983 · N8353M · Destroyed NTSB LAX83LA307Accident · Serious injuriesLimited investigationFinal reportCessna A150K · San Diego, CAWitnesses observed the acft circling over the housing development at low altitude. The acft banked steeply, pitched up & the nose fell through the horizon. The student plt flying the acft resided four houses away from where the acft crashed.Jun 25, 1983 · N8496M · Destroyed NTSB OAK79DVA13Accident · No injuriesClosedCessna A150K · Merced, CAJan 18, 1979 · N5909J · Substantial damage NTSB LAX78DUM36Accident · Minor injuriesClosedCessna A150K · Imperial, CASep 12, 1978 · N8348M · Destroyed NTSB OAK77FVA29Accident · No injuriesClosedCessna A150K · Fresno, CAApr 24, 1977 · N8399M · Substantial damage NTSB OAK76FVM25Accident · No injuriesClosedCessna 150 · San Jose, CAMar 7, 1976 · N8373M · Substantial damage NTSB OAK76AP039Accident · 1 fatalClosedCessna A150K · Oakland, CADec 29, 1975 · N8430M · Destroyed NTSB OAK76FVG33Accident · No injuriesClosedCessna A150K · Lincoln, CANov 12, 1975 · N8417M · Substantial damage NTSB LAX74AL060Accident · 1 fatalClosedCessna A150K · Moorpark, CAMar 9, 1974 · N8392M · Destroyed NTSB LAX73FUG13Accident · Serious injuriesClosedCessna A150K · Daggett, CAAug 24, 1972 · N8472M · Substantial damage NTSB OAK71FVM53Accident · No injuriesClosedCessna 150 · San Carlos, CAMay 14, 1971 · N8378M · Substantial damage NTSB OAK71FVM28Accident · Serious injuriesClosedCessna A150K · San Jose, CADec 6, 1970 · N5901J · Substantial damage NTSB OAK71DVM06Accident · Minor injuriesClosedCessna 150 · San Jose, CAJul 15, 1970 · N8490M · Substantial damage NTSB OAK70DVD18Accident · No injuriesClosedCessna 150 · Novato, CAApr 25, 1970 · N8370M · Substantial damage