Skip to content

NTSB investigations: Cessna 150, CA

83 cases on aircraft the registry lists as Cessna 150. 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 ('2071802')) 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 ('2071802'))
  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 ('2071802'))
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 WPR21FA298Accident · 2 fatalClass 3 · FieldFinal reportCessna 150 · Banning, CAThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering in the airport traffic pattern, which resulted in an aerodynamic stall and loss of control.Jul 30, 2021 · N8520G · Substantial damage NTSB LAX01TA233Accident · No injuriesFinal reportCessna 150 · Delano, CAA bent mixture control valve stem shaft in the carburetor which made pilot control of the mixture inoperative resulting in excessive fuel consumption, and subsequent loss of engine power..Jul 3, 2001 · N6475T · Substantial damage NTSB LAX00LA296Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Carlsbad, CAA catastrophic internal engine failure for undetermined reasons.Aug 12, 2000 · N6500T · Destroyed NTSB LAX94LA014Accident · No injuriesLimited investigationFinal reportCessna 150 · Daggett, CAthe pilot's poor fuel consumption calculations which culminated in engine losing power due to fuel exhaustion. The soft desert terrain was a factor in this accident.Oct 15, 1993 · N6538T · Substantial damage NTSB LAX89LA228Accident · No injuriesLimited investigationFinal reportCessna 150 · Kelseyville, CAInadequate preflight planning/preparations and the improper fuel consumption calculations by the pilot.Jul 2, 1989 · N5712E · Substantial damage NTSB LAX88LA097Accident · No injuriesLimited investigationFinal reportCessna 150 · Redbluff, CADuring a cross country flt, the engine experienced a complete pwr loss. The plt made a forced landing where the acft collided with the terrain 1 mile short of the rwy. Inspection of the acft revealed that the fuel tanks were near empty. There were no reported…Jan 26, 1988 · N7929E · Substantial damage NTSB LAX86LA345Accident · No injuriesLimited investigationFinal reportCessna 150 · Modesto, CAAt the end of one leg of a solo cross-country flight the student pilot experienced a hard landing which resulted in a porpoise on the rwy. The pilot did not realize the severity of the initial bounce and tried to re-flare the aircraft without adding power.…Sep 10, 1986 · N112LN · Substantial damage NTSB LAX82DA125Accident · No injuriesFinal reportCessna 150 · Death Valley, CAThe pilot reported that during a cross-country flight, the engine began running rough and decreasing thrust resulted in a forced landing. While landing on a soft, dry lake bed, the plane crossed a small wash where the nose gear collapsed and the aircraft…Apr 3, 1982 · N5682E · Substantial damage NTSB LAX82DA097Accident · No injuriesFinal reportCessna 150 · Half Moon Bay, CAThe pilot of Taylorcraft, N94906, was making mild s-turns as he proceeded down a taxiway. As he was making an s-turn back to the right, he saw a Cessna 150, N5678E, at the right edge of the taxiway on a converging course. He turned left to avoid a collision,…Mar 6, 1982 · N5678E · 2 aircraft · Substantial damage NTSB LAX80FA079Accident · 2 fatalClosedCessna 150 · Byron, CAApr 12, 1980 · N7816E · Destroyed NTSB OAK79DVD30Accident · No injuriesClosedCessna 150 · Gualala, CAJun 14, 1979 · N7714E · Substantial damage NTSB LAX79DUG19Accident · Minor injuriesClosedCessna 150 · Thermal, CAFeb 25, 1979 · N5807E · Substantial damage NTSB OAK78DXQ45Accident · Minor injuriesClosedCessna 150 · S.Lake Tahoe, CASep 2, 1978 · N8130S · Substantial damage NTSB OAK78FVG19Accident · 1 fatalClosedCessna 150 · Vacaville, CAFeb 12, 1978 · N6539T · Destroyed NTSB OAK77FA034Accident · 3 fatalClosedCessna 150L · San Ramon, CAJun 2, 1977 · N5456Q · 2 aircraft · Destroyed NTSB LAX77FUG33Accident · Minor injuriesClosedCessna 150L · Riverside, CAMar 4, 1977 · N234AF · Destroyed NTSB OAK77DVA15Accident · No injuriesClosedCessna 150 · Oakhurst, CAJan 16, 1977 · N150SS · Substantial damage NTSB LAX77FA007Accident · 2 fatalClosedCessna 172 · Terminal Islnd, CANov 4, 1976 · N20140 · 2 aircraft · Destroyed NTSB LAX76FUD13Accident · No injuriesClosedCessna 150 · Van Nuys, CAJun 20, 1976 · N5804E · Substantial damage NTSB LAX76FUQ37Accident · No injuriesClosedCessna 150J · Van Nuys, CAApr 30, 1976 · N51283 · Substantial damage NTSB OAK76DVD09Accident · Minor injuriesClosedCessna 150 · Whitethorn, CAAug 31, 1975 · N5210Q · Substantial damage NTSB OAK74DXQ40Accident · No injuriesClosedCessna 150 · Lake Tahoe, CAMay 22, 1974 · N5923G · Substantial damage NTSB OAK74FVG37Accident · No injuriesClosedCessna 150 · Foresthill, CAApr 7, 1974 · N6526T · Substantial damage NTSB LAX74FUG15Accident · No injuriesClosedCessna 150C · Adelanto, CASep 24, 1973 · N2029Z · Substantial damage NTSB OAK73DVM33Accident · Minor injuriesClosedCessna 150 · Pescadero, CAMay 29, 1973 · N7028X · Destroyed NTSB OAK73FVM30Accident · Serious injuriesClosedCessna 150 · Pacifica, CAApr 24, 1973 · N22446 · Destroyed NTSB LAX73AL045Accident · 2 fatalClosedCessna 150J · Newhall, CAMar 21, 1973 · N51362 · Destroyed NTSB LAX73DVA34Accident · No injuriesClosedCessna 150 · Taft, CADec 17, 1972 · N7729E · Substantial damage NTSB OAK73DVA25Accident · No injuriesClosedCessna 150 · Lone Pine, CAOct 14, 1972 · N5522E · Destroyed NTSB LAX72AL062Accident · 5 fatalClosedCessna 182 · San Diego, CAJun 17, 1972 · N3106S · 2 aircraft · Destroyed NTSB LAX72FUG62Accident · Serious injuriesClosedCessna 150 · Riverside, CAMar 25, 1972 · N2962S · Substantial damage NTSB LAX72AL045Accident · No injuriesClosedCessna 150J · Fntn Valley, CAJan 15, 1972 · N51362 · 2 aircraft · Substantial damage NTSB OAK72FVD30Accident · Serious injuriesClosedCessna 150L · Stockton, CAJan 13, 1972 · N6511G · Destroyed NTSB LAX72FUA30Accident · Serious injuriesClosedCessna 150 · Torrance, CAJan 6, 1972 · N7809E · No damage NTSB OAK72DVG11Accident · Minor injuriesClosedCessna 150 · Napa, CAAug 5, 1971 · N5682E · Destroyed NTSB OAK71DVA61Accident · No injuriesClosedCessna 150 · Visalia, CAMar 3, 1971 · N7815E · Substantial damage NTSB LAX71FUA41Accident · No injuriesClosedCessna 150 · Huntngton B., CAJan 2, 1971 · N7966E · Substantial damage NTSB OAK71DVA45Accident · No injuriesClosedCessna 150 · Modesto, CADec 5, 1970 · N6511G · Substantial damage NTSB LAX71FUA24Accident · No injuriesClosedCessna 150 · Long Beach, CAOct 26, 1970 · N51362 · Substantial damage NTSB LAX70DUG39Accident · No injuriesClosedCessna 150C · Joshua Tree, CAMay 30, 1970 · N7771E · Substantial damage NTSB LAX70D0236Accident · No injuriesClosedCessna 150 · La Verne, CADec 26, 1969 · N5617E · Substantial damage NTSB LAX70D0158Accident · No injuriesClosedCessna 150 · Baker, CAOct 13, 1969 · N7827E · Substantial damage NTSB OAK70D0116Accident · No injuriesClosedCessna 150 · Oakland, CASep 8, 1969 · N5797E · Substantial damage NTSB LAX70D0119Accident · No injuriesClosedCessna 150 · San Brnrdno, CAAug 23, 1969 · N7981E · Substantial damage NTSB LAX69D0319Accident · No injuriesClosedCessna 150 · Appl Valley, CAMar 24, 1969 · N5776E · Substantial damage NTSB OAK69D0232Accident · Minor injuriesClosedCessna 150 · Big Sur, CAFeb 3, 1969 · N50378 · Substantial damage NTSB LAX69D0202Accident · Minor injuriesClosedCessna 150 · Redlands, CANov 10, 1968 · N7863E · Substantial damage NTSB OAK69A0020Accident · 2 fatalClosedCessna 150G · Crescent City, CAOct 4, 1968 · N6245S · Destroyed NTSB OAK69A0010Accident · No injuriesClosedCessna 150 · Hayward, CAAug 14, 1968 · N7819E · 2 aircraft · Substantial damage NTSB LAX68F0325Accident · No injuriesClosedCessna 150 · San Diego, CAFeb 29, 1968 · N5836E · Substantial damage