Skip to content

NTSB investigations: Cessna 150E, CA

68 cases on aircraft the registry lists as Cessna 150E. 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

19652026

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 ('2071812')) 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 ('2071812'))
  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 ('2071812'))
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 LAX03FA025Accident · 1 fatalField investigationFinal reportCessna 150E · Anaheim Hills, CAthe pilot's continued VFR flight into instrument meteorological conditions and his subsequent failure to maintain clearance from power lines. A contributing factor was the pilot's impairment by medication.Nov 8, 2002 · N6236T · Destroyed NTSB LAX01LA213Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Burbank, CAFuel exhaustion while maneuvering during a banner tow flight due to an inadequate fuel supply. A factor was the pilot's improper preflight preparation.Jun 17, 2001 · N3937U · Substantial damage NTSB LAX00LA120Accident · No injuriesLimited investigationFinal reportCessna 150E · Reedley, CAA loose seat latch which permitted the seat to move aft to a position where the pilot could no longer reach the controls.Mar 7, 2000 · N6194T · Substantial damage NTSB LAX96LA054Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Sonora, CAcarburetor icing, due to the pilot's improper use of power plant controls and/or carburetor heat. A factor relating to the accident was: the weather condition, which was conducive to carburetor ice.Nov 25, 1995 · N3000J · Substantial damage NTSB LAX95LA131Accident · No injuriesLimited investigationFinal reportCessna 150E · Visalia, CAthe pilot's misjudged landing flare and his improper bounced landing recovery technique.Mar 13, 1995 · N6277T · Substantial damage NTSB LAX93LA221Accident · No injuriesLimited investigationFinal reportCessna 150E · Hollister, CAfuel exhaustion due to the pilot's inadequate preflight inspection of the aircraft and his failure to refuel the aircraft prior to departure.May 23, 1993 · N3051J · Substantial damage NTSB LAX91LA014Accident · No injuriesLimited investigationFinal reportCessna 150E · S. Lake Tahoe, CAThe pilot's failure to ensure adequate clearance was available when he attempted to taxi pass a parked vehicle.Oct 19, 1990 · N6203R · Substantial damage NTSB LAX85LA389Accident · No injuriesLimited investigationFinal reportCessna 150E · Apple Valley, CAWhile practicing stop and go takeoffs and landings, the solo student plt flared too high on the second landing and lost directional control. The plt applied power to negotiate a go around. The nose ptiched up and the acft stalled. The acft contacted the gnd…Sep 11, 1985 · N3926U · Substantial damage NTSB LAX85LA333Accident · Serious injuriesLimited investigationFinal reportCessna 150E · Sonoma, CADuring a dual instructional flight the student plt practiced a full stop ldg followed by a take off. On initial climb all eng power was suddenly lost. When the CFI took over the controls & maneuvered the acft for an emergency ldg, the eng momentarily coughed…Jul 31, 1985 · N6284T · Destroyed NTSB LAX81DUQ05Accident · No injuriesClosedCessna 150 · Lancaster, CANov 28, 1980 · N3529J · Substantial damage NTSB OAK78DVG16Accident · No injuriesClosedCessna 150E · Calistoga, CAJan 26, 1978 · N47793 · Substantial damage NTSB LAX77DUQZ7Accident · No injuriesClosedCessna 150 · Quartz Hill, CAApr 14, 1977 · N2514J · Substantial damage NTSB LAX76DUG26Accident · No injuriesClosedCessna 150 · Apple Valley, CANov 16, 1975 · N6223T · Substantial damage NTSB OAK74DVD02Accident · No injuriesClosedCessna 150 · Healdsburg, CAAug 14, 1973 · N6198T · Substantial damage NTSB LAX73AL057Accident · 1 fatalClosedCessna 150 · Malibu, CAMay 14, 1973 · N3928U · Destroyed NTSB OAK73AP020Accident · 1 fatalClosedCessna 150 · San Carlos, CAJan 7, 1973 · N6076T · Destroyed NTSB LAX72FUA17Accident · No injuriesClosedCessna 150E · Avalon, CAOct 4, 1971 · N4065U · Substantial damage NTSB LAX72FUG02Accident · No injuriesClosedCessna 150E · E.Highlands, CAJul 13, 1971 · N3092J · Substantial damage NTSB OAK71DVM31Accident · No injuriesClosedCessna 150E · Salinas, CADec 6, 1970 · N2533J · Substantial damage NTSB LAX71FUQ31Accident · Serious injuriesClosedCessna 150 · Valencia, CANov 1, 1970 · N3035J · Substantial damage NTSB LAX71FUA23Accident · No injuriesClosedCessna 150 · Huntingtn Bch, CAOct 17, 1970 · N6223T · Substantial damage NTSB OAK71FVG19Accident · No injuriesClosedCessna 150 · Franklin, CASep 12, 1970 · N3937U · Substantial damage NTSB OAK70DVD29Accident · No injuriesClosedCessna 150 · Livermore, CAJun 16, 1970 · N3549J · Substantial damage NTSB OAK70D0188Accident · No injuriesClosedCessna 150E · Livermore, CANov 26, 1969 · N2560J · Substantial damage NTSB OAK70D0072Accident · No injuriesClosedCessna 150 · Hornbrook, CAAug 5, 1969 · N6185T · Substantial damage NTSB LAX69D0318Accident · No injuriesClosedCessna 150 · Bakersfield, CAApr 13, 1969 · N4053U · Substantial damage NTSB LAX69F0255Accident · No injuriesClosedCessna 150 · Van Nuys, CAFeb 2, 1969 · N3982U · Substantial damage NTSB LAX69F0225Accident · No injuriesClosedCessna 150E · Perris, CADec 14, 1968 · N6189T · Substantial damage NTSB LAX69D0183Accident · No injuriesClosedCessna 150 · Cuyama, CANov 9, 1968 · N220F · Destroyed NTSB OAK69D0143Accident · No injuriesClosedCessna 150 · Watsonville, CASep 23, 1968 · N2533J · Substantial damage NTSB LAX69F0149Accident · No injuriesClosedCessna 150 · Torrance, CAAug 21, 1968 · N6236T · Substantial damage NTSB LAX69D0035Accident · No injuriesClosedCessna 150 · San Diego, CAJul 14, 1968 · N6105T · Substantial damage NTSB LAX69F0032Accident · No injuriesClosedCessna 150 · Long Beach, CAJun 23, 1968 · N6236T · Substantial damage NTSB LAX68A0110Accident · 2 fatalClosedCessna 150E · Santa Susana, CAJun 22, 1968 · N3532J · Substantial damage NTSB LAX68D0384Accident · No injuriesClosedCessna 150G · Lancaster, CAApr 7, 1968 · N4065U · Substantial damage NTSB LAX68D0356Accident · No injuriesClosedCessna 150 · Rubidoux, CAMar 10, 1968 · N6262T · Substantial damage NTSB LAX68F0266Accident · No injuriesClosedCessna 150 · Walnut, CAJan 2, 1968 · N4025U · Substantial damage NTSB OAK68D0024Accident · No injuriesClosedCessna 150 · Placerville, CAJun 25, 1967 · N6138T · Substantial damage NTSB OAK68D0044Accident · No injuriesClosedCessna 150 · San Jose, CAJun 23, 1967 · N2878S · 2 aircraft · Minor damage NTSB LAX68D0023Accident · No injuriesClosedCessna 150 · Torrance, CAJun 1, 1967 · N6267T · Substantial damage NTSB OAK67D0317Accident · No injuriesClosedCessna 150 · Susanville, CAMay 18, 1967 · N3587J · Substantial damage NTSB OAK68D0014Accident · No injuriesClosedCessna 150 · Turlock, CAMay 14, 1967 · N6266T · Substantial damage NTSB LAX67D0365Accident · Minor injuriesClosedCessna 150 · Frazier Prk, CAApr 28, 1967 · N6282T · Substantial damage NTSB LAX67A0080Accident · No injuriesClosedCessna 150E · Santa Susana, CAFeb 19, 1967 · N4096U · Minor damage NTSB OAK67D0215Accident · No injuriesClosedCessna 150 · Hayward, CAFeb 7, 1967 · N3035J · Substantial damage NTSB OAK67D0170Accident · No injuriesClosedCessna 150E · Palo Alto, CANov 18, 1966 · N6138T · Substantial damage NTSB OAK67F0213Accident · No injuriesClosedCessna 150E · Concord, CANov 12, 1966 · N3050J · 2 aircraft · Substantial damage NTSB LAX67D0166Accident · No injuriesClosedCessna 150 · Ocotillo Well, CAOct 8, 1966 · N6220T · Substantial damage NTSB LAX67F0030Accident · No injuriesClosedCessna 150 · Van Nuys, CAJul 24, 1966 · N6222R · Substantial damage NTSB LAX66F0377Accident · No injuriesClosedCessna 150 · Santa Ana, CAMay 30, 1966 · N4027U · Substantial damage