Skip to content

NTSB investigations: Cessna 172E, CA

66 cases on aircraft the registry lists as Cessna 172E. 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 ('2072412')) 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 ('2072412'))
  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 ('2072412'))
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 GAA20CA074Accident · No injuriesData collectionFinal reportCessna 172 · FallBrook, CAThe student pilot's use of excessive ground speed while making a right turn when exiting the runway, which resulted in a loss of directional control and a runway excursion.Nov 12, 2019 · N3803S · Substantial damage NTSB WPR12LA090Accident · Serious injuriesLimited investigationFinal reportCessna 172E · Dinsmore, CAThe flight instructor's delayed remedial action, inadequate recovery from a bounced landing, and failure to attain/maintain adequate airspeed during an attempted go-around.Feb 3, 2012 · N3879S · Substantial damage NTSB WPR11LA062Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Suisun City, CAA total loss of engine power for undetermined reasons.Nov 27, 2010 · N5582T · Substantial damage NTSB WPR10LA417Accident · Serious injuriesLimited investigationFinal reportCessna 172E · Mammoth Lakes, CAThe pilot’s failure to maintain adequate airspeed and airplane control during takeoff in high density altitude conditions, which resulted in an aerodynamic stall.Aug 22, 2010 · N7807U · Substantial damage NTSB LAX99LA256Accident · No injuriesLimited investigationFinal reportCessna 172E · Emeryville, CAThe pilot's inadequate in-flight planning and inadequate fuel consumption calculations, resulting in a total loss of engine power due to fuel exhaustion. Factors were the pilot's failure to have all appropriate flight manuals aboard the airplane and the low…Jul 24, 1999 · N5784T · Substantial damage NTSB LAX92LA143Accident · Serious injuriesLimited investigationFinal reportCessna 172E · Yucapia, CAThe partial loss of power most likely related to the poor quality of aircraft maintenance. A factor in the accident was the lack of suitable terrain for a forced landing.Mar 16, 1992 · N5417T · Substantial damage NTSB LAX90LA196Accident · Serious injuriesLimited investigationFinal reportCessna 172E · Brentwood, CAThe pilot improperly calculated the fuel consumption causing the airplane to sustain a total loss of power due to fuel exhaustion.May 25, 1990 · N5714T · Substantial damage NTSB LAX89LA235Accident · No injuriesLimited investigationFinal reportCessna 172E · Mariposa, CAStudent pilot's miscalculation of the fuel supply which led to a loss of engine power due to fuel exhaustion.Jun 26, 1989 · N7744U · Substantial damage NTSB LAX89LA221Accident · No injuriesLimited investigationFinal reportCessna 172E · Grass Valley, CAFailure to perform maintenance inspections prescribed by the magneto, engine and aircraft manufacturers. The high density altitude and terrain conditions were contributing factors.Jun 18, 1989 · N3618S · Substantial damage NTSB LAX88LA038Accident · No injuriesLimited investigationFinal reportCessna 172E · Placerville, CADuring a telephone interview the student pilot stated that he was practicing takeoffs and landings. On the landing prior to the accident, the aircraft bounced and the student pilot attempted a go around. During the go around attempt the aircraft drifted to…Nov 11, 1987 · N5577T · Substantial damage NTSB LAX86LA336Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Lower Lake, CAThe airplane departed on a local sight-seeing flight at Lower Lake, California. A noncurrent commercial pilot was flying the airplane; the PIC, a current commercial pilot, was occupying the right front seat. The airplane collided with some 12-foot high…Aug 30, 1986 · N3651S · Substantial damage NTSB LAX84LA416Accident · No injuriesLimited investigationFinal reportCessna 172E · Elk Grove, CAThe acft bounced several times during landing according to a plt witness near the rwy. During the bounces the acft left the rwy in a crosswind. The damage to the acft was estimated as minor up to this time. The plt of the accident acft decided to try to…Jul 21, 1984 · N3587S · Substantial damage NTSB LAX84LA127Accident · No injuriesLimited investigationFinal reportCessna 172E · Selma, CAThe plt stated he was practicing landings when after takeoff following a full stop landing, the 'motor stopped then started again momentarily.' He landed in a vineyard. Responding officers from the sherriff's department observed no fuelin the aircraft tanks.Jan 2, 1984 · N5314T · Substantial damage NTSB LAX80FVG37Accident · Serious injuriesClosedCessna 172E · Roseville, CAMay 8, 1980 · N5552T · Destroyed NTSB LAX77FUD05Accident · No injuriesClosedCessna 172E · Compton, CAMar 17, 1977 · N3707S · Substantial damage NTSB LAX76AL038Accident · 1 fatalClosedCessna 172E · Corona, CANov 27, 1975 · N5342T · Destroyed NTSB OAK76FVA28Accident · No injuriesClosedCessna 172 · Shaver Lake, CANov 9, 1975 · N3626S · Substantial damage NTSB OAK75FVG30Accident · Minor injuriesClosedCessna 172E · Butte Mdws, CAOct 15, 1974 · N5415E · Substantial damage NTSB OAK74DVG17Accident · No injuriesClosedCessna 172 · Sutter Crk, CAOct 11, 1973 · N7707U · Substantial damage NTSB OAK73DVM39Incident · No injuriesClosedCessna 150 · Moss Beach, CAJun 19, 1973 · N17147 · 2 aircraft · Minor damage NTSB OAK73DVD21Accident · No injuriesClosedCessna 172 · Livermore, CADec 10, 1972 · N5363T · Substantial damage NTSB OAK72AP040Accident · 1 fatalClosedCessna 172E · Modesto, CAMay 10, 1972 · N3862S · Destroyed NTSB LAX72FUG69Accident · Serious injuriesClosedCessna 172E · Hesperia, CAApr 15, 1972 · N5532T · Substantial damage NTSB LAX71AL068Accident · 1 fatalClosedCessna 172E · El Cajon, CAMay 15, 1971 · N5678T · Destroyed NTSB LAX71DUQ47Accident · No injuriesClosedCessna 172E · Van Nuys, CAJan 2, 1971 · N5606T · Substantial damage NTSB OAK71FVM07Accident · Minor injuriesClosedCessna 172 · Palo Alto, CAAug 11, 1970 · N3820S · Substantial damage NTSB LAX71FUA05Accident · No injuriesClosedCessna 172 · Santa Ana, CAJul 30, 1970 · N3803S · 2 aircraft · Substantial damage NTSB OAK71AP002Accident · No injuriesClosedCessna 172 · Fresno, CAJul 10, 1970 · N5790T · 2 aircraft · Substantial damage NTSB OAK70DVM12Accident · No injuriesClosedCessna 172E · Atascadero, CAMar 26, 1970 · N7744U · Substantial damage NTSB LAX70FUG10Accident · Minor injuriesClosedCessna 172 · Rubidoux, CAFeb 22, 1970 · N1212K · Substantial damage NTSB LAX70FUA11Accident · No injuriesClosedCessna 172 · Santa Ana, CAFeb 19, 1970 · N7707U · Substantial damage NTSB LAX70DUA09Accident · No injuriesClosedCessna 172 · Santa Ana, CAJan 31, 1970 · N7807U · Substantial damage NTSB LAX70D0202Accident · No injuriesClosedCessna 172 · Newhall, CANov 13, 1969 · N3976S · Substantial damage NTSB OAK70D0022Accident · No injuriesClosedCessna 172E · Madera, CAJun 16, 1969 · N3987S · Substantial damage NTSB OAK70F0034Accident · Serious injuriesClosedCessna 172 · Woodland, CAJun 2, 1969 · N5635T · Substantial damage NTSB LAX69F0332Accident · Serious injuriesClosedCessna 172 · Calexico, CAApr 28, 1969 · N3939S · Substantial damage NTSB LAX71AL063Accident · 2 fatalClosedCessna 172E · Banning, CADec 1, 1968 · N2992U · Destroyed NTSB OAK69A0034Accident · 1 fatalClosedCessna 172E · Susanville, CANov 21, 1968 · N5740T · Destroyed NTSB LAX69D0083Accident · No injuriesClosedCessna 172 · Catalina Is., CAAug 16, 1968 · N7721U · Substantial damage NTSB OAK69D0082Accident · Minor injuriesClosedCessna 172 · Selma, CAAug 2, 1968 · N3945S · Substantial damage NTSB OAK69D0010Accident · No injuriesClosedCessna 172 · Tracy, CAJun 5, 1968 · N7744U · Substantial damage NTSB OAK69D0077Accident · Serious injuriesClosedCessna 172 · Shelter Cove, CAJun 2, 1968 · N5421T · Destroyed NTSB OAK68D0309Accident · No injuriesClosedCessna 172 · Corning, CADec 29, 1967 · N5421T · Substantial damage NTSB LAX68F0054Accident · No injuriesClosedCessna 172 · Arcadia, CAJul 2, 1967 · N3879S · Substantial damage NTSB LAX67D0390Accident · No injuriesClosedCessna 172 · Murrieta, CAMay 7, 1967 · N5504T · Substantial damage NTSB LAX67F0273Accident · No injuriesClosedCessna 172 · Van Nuys, CAFeb 11, 1967 · N5504T · Substantial damage NTSB OAK67F0209Accident · No injuriesClosedCessna 172 · Bishop, CADec 22, 1966 · N3579S · Destroyed NTSB LAX67D0082Accident · Minor injuriesClosedCessna 172 · Santa Ynez, CAJul 30, 1966 · N3946S · Substantial damage NTSB OAK67F0013Accident · Serious injuriesClosedCessna 172E · Vacaville, CAJun 26, 1966 · N3911S · Substantial damage NTSB OAK67F0027Accident · No injuriesClosedCessna 172E · Fresno, CAJun 12, 1966 · N5386T · Substantial damage