Skip to content

NTSB investigations: Cessna 150D, CA

53 cases on aircraft the registry lists as Cessna 150D. 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 ('2071810')) 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 ('2071810'))
  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 ('2071810'))
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 WPR25LA073AccidentClass 4 · LimitedFinal reportCessna 150D · Temple City, CAThe flight instructor’s unfamiliarity with the fuel quantities the fuel measuring dip stick measured and inadequate preflight inspection which resulted in fuel exhaustion.Jan 6, 2025 · N5943T · Substantial damage NTSB WPR21LA329Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150D · Chino, CAThe pilot’s delayed use of carburetor heat, which resulted in a loss of engine power due to carburetor icing.Aug 25, 2021 · N4375U · Substantial damage NTSB LAX94LA286Accident · 2 fatalLimited investigationFinal reportCessna 150D · Carrville, CAa loss of engine power for undetermined reasons. The mountainous terrain and lack of a suitable forced landing area within gliding distance was a factor in the accident.Jul 16, 1994 · N6052T · Destroyed NTSB LAX93LA240Accident · No injuriesLimited investigationFinal reportCessna 150D · Biggs, CAThe first pilot's premature lift-off and his failure to maintain directional control.Jun 3, 1993 · N6030T · Substantial damage NTSB LAX93LA094Accident · No injuriesLimited investigationFinal reportCessna 150 · Torrance, CA1) The pilot misjudging the airplane's landing flare, and 2) the pilot's improper recovery from a bounced landing. A factor in this accident was the pilot's lack of total aircraft experience.Jan 11, 1993 · N6019T · Substantial damage NTSB LAX90LA049Accident · No injuriesLimited investigationFinal reportCessna 150D · Inyokern, CAThe pilot's failure to use carburetor heat when climatic conditions were conducive to the formation of carburetor ice.Dec 6, 1989 · N4390U · Substantial damage NTSB LAX86LA302Accident · 1 fatalLimited investigationFinal reportCessna 150D · San Diego, CAA Cessna 150D collided with the pacific ocean while spotting fish approximately 5 mi from the coast. The acft owner and operator indicated that the plt was FAA licensed and current. FAA records revealed the plt was issued a student plt certificated along with…Jul 23, 1986 · N5917T · Destroyed NTSB LAX82DUG06Accident · Serious injuriesFinal reportCessna 150 · Daggett, CAWhile descending through 4000 ft MSL to land, the engine began to surge. The pilot moved the mixture to full rich and selected carburetor heat, but the engine lost all power. Reportedly, the aircraft was demolished during a forced landing. Disassembly of the…Feb 14, 1982 · N4539U · Destroyed NTSB OAK77FVA44Accident · No injuriesClosedCessna 150D · Kerman, CAJul 24, 1977 · N4200U · Substantial damage NTSB OAK77FVA37Accident · Serious injuriesClosedCessna 150 · Los Banos, CAJun 19, 1977 · N4254U · Destroyed NTSB LAX77FUG11Accident · No injuriesClosedCessna 150D · Riverside, CANov 29, 1976 · N4539U · Substantial damage NTSB OAK76FVM29Accident · Minor injuriesClosedCessna 150D · Monterey, CAMar 14, 1976 · N4402U · Substantial damage NTSB LAX76FUQ02Accident · No injuriesClosedCessna 150 · Pt.Dume, CAJul 4, 1975 · N4505U · Substantial damage NTSB OAK73AP013Accident · 1 fatalClosedCessna 150D · Auburn, CANov 26, 1972 · N4107U · Destroyed NTSB OAK72FVG05Accident · No injuriesClosedCessna 150 · Napa, CAJul 15, 1971 · N4161U · Destroyed NTSB OAK71DVM30Accident · No injuriesClosedCessna 150 · Palo Alto, CADec 5, 1970 · N4254U · Substantial damage NTSB LAX71FUQ34Accident · No injuriesClosedCessna 150 · Oxnard, CASep 26, 1970 · N4345U · Substantial damage NTSB LAX71AL009Accident · 2 fatalClosedCessna 150 · Wrightwood, CASep 6, 1970 · N4412U · Destroyed NTSB LAX70DUG29Accident · No injuriesClosedCessna 150 · El Monte, CAApr 20, 1970 · N4390U · Substantial damage NTSB LAX70DUG18Accident · No injuriesClosedCessna 150 · Murrieta, CAMar 15, 1970 · N4259U · Substantial damage NTSB LAX70D0226Accident · Minor injuriesClosedCessna 150 · Daggett, CADec 22, 1969 · N5997T · Substantial damage NTSB LAX69D0165Accident · No injuriesClosedCessna 150 · Hesperia, CAOct 12, 1968 · N4270U · Substantial damage NTSB OAK69D0145Accident · No injuriesClosedCessna 150 · Palo Alto, CAOct 1, 1968 · N4254U · Substantial damage NTSB LAX69F0111Accident · No injuriesClosedCessna 150D · Fullerton, CASep 14, 1968 · N4448U · Substantial damage NTSB OAK68D0163Accident · No injuriesClosedCessna 150 · Monterey, CAAug 13, 1967 · N6066T · Substantial damage NTSB OAK68D0084Accident · No injuriesClosedCessna 150 · Morgan Hill, CAAug 4, 1967 · N4309U · Destroyed NTSB LAX68D0041Accident · No injuriesClosedCessna 150 · Lakeview, CAJun 23, 1967 · N4403U · Substantial damage NTSB LAX68D0104Accident · No injuriesClosedCessna 150 · Santa Paula, CAApr 21, 1967 · N5953T · Substantial damage NTSB LAX67A0096Accident · 1 fatalClosedCessna 150 · Newhall, CAApr 15, 1967 · N4181U · Destroyed NTSB OAK67D0187Accident · Minor injuriesClosedCessna 150 · Sunnyvale, CADec 7, 1966 · N5937T · Substantial damage NTSB OAK67F0165Accident · No injuriesClosedCessna 150 · Merced, CANov 6, 1966 · N4543U · 2 aircraft · Substantial damage NTSB OAK67D0104Accident · No injuriesClosedCessna 150 · San Jose, CAOct 2, 1966 · N5938T · Substantial damage NTSB OAK67D0064Accident · No injuriesClosedCessna 150 · Half Moon Bay, CAAug 6, 1966 · N5998T · Substantial damage NTSB LAX66F0314Accident · No injuriesClosedCessna 150 · Hawthorne, CAApr 8, 1966 · N4372U · Substantial damage NTSB LAX66D0224Accident · No injuriesClosedCessna 150 · Piru, CAJan 18, 1966 · N4240U · Substantial damage NTSB OAK66F0181Accident · No injuriesClosedCessna 150D · Lincoln, CADec 18, 1965 · N4316U · 2 aircraft · Substantial damage NTSB LAX66F0182Accident · No injuriesClosedCessna 150 · 29 Palms, CANov 12, 1965 · N4546U · Substantial damage NTSB OAK66D0160Accident · No injuriesClosedCessna 150 · Alameda, CAOct 18, 1965 · N4355U · Substantial damage NTSB LAX66D0089Accident · No injuriesClosedCessna 150 · El Monte, CAAug 29, 1965 · N4354U · Substantial damage NTSB OAK66F0126Accident · Minor injuriesClosedCessna 150 · Hamilton Afb, CAAug 28, 1965 · N5975T · Substantial damage NTSB LAX66F0117Accident · No injuriesClosedCessna 150 · Van Nuys, CAAug 28, 1965 · N4384U · Substantial damage NTSB OAK66A0005Accident · 1 fatalClosedCessna 150 · Stockton, CAAug 8, 1965 · N4351U · Destroyed NTSB LAX65F0056Accident · No injuriesClosedCessna 150 · Compton, CAApr 29, 1965 · N4226U · Substantial damage NTSB UNK65X1341Accident · Minor injuriesClosedCessna 150 · Sacramento, CAJan 24, 1965 · N4396U · Substantial damage NTSB UNK65X0830Accident · Minor injuriesClosedCessna 150C · Santa Monica, CANov 25, 1964 · N1992Z · 2 aircraft · Minor damage NTSB UNK65X0809Accident · 3 fatalClosedCessna 150D · Pomona, CANov 23, 1964 · N4359U · 2 aircraft · Destroyed NTSB UNK65X0619Accident · No injuriesClosedCessna 150 · San Carlos, CANov 8, 1964 · N6055T · Substantial damage NTSB UNK65X0530Accident · No injuriesClosedCessna 150 · San Carlos, CANov 2, 1964 · N6065T · Substantial damage NTSB UNK65X0489Accident · No injuriesClosedCessna 150 · Riverside, CAOct 30, 1964 · N4444U · Substantial damage NTSB UNK64X3424Accident · No injuriesClosedCessna 150 · Lauerne, CAAug 16, 1964 · N4270U · Substantial damage