Skip to content

NTSB investigations: Cessna 172F, CA

47 cases on aircraft the registry lists as Cessna 172F. 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 ('2072414')) 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 ('2072414'))
  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 ('2072414'))
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 GAA19CA544Accident · No injuriesData collectionFinal reportCessna 172F · Hemet, CAThe flight instructor's improper decision to perform a precautionary landing on unsuitable terrain, which resulted in a noseover.Sep 12, 2019 · N5229F · Substantial damage NTSB WPR13LA098Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Marysville, CAA total loss of engine power during initial climb due to fuel starvation, which resulted from maintenance personnel’s improper installation of the fuel selector handle. Contributing to the accident was an incorrectly modified fuel selector handle assembly.Jan 20, 2013 · N5208F · Substantial damage NTSB WPR10CA311Accident · No injuriesData collectionFinal reportCessna 172F · Rancho Murieta, CAA total loss of engine power in flight due to fuel exhaustion as a result of the pilot's inadequate fuel planning.Jul 8, 2010 · N8793U · Substantial damage NTSB WPR10LA087Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Corona, CAA loss of engine power for undetermined reasons.Dec 17, 2009 · N8520U · Substantial damage NTSB LAX08CA214Accident · No injuriesData collectionFinal reportCessna 172F · Pomona, CAFuel exhaustion due to the pilot's inadequate preflight planning and his failure to refuel the airplane.Jul 6, 2008 · N8881U · Substantial damage NTSB LAX04CA086Accident · No injuriesData collectionFinal reportCessna 172F · Redlands, CAthe pilot's inadequate compensation for the existing gusty crosswind condition, and his failure to maintain directional control. Contributing factors were a crosswind and wind gusts.Jan 3, 2004 · N5184F · Substantial damage NTSB LAX01FA070Accident · 2 fatalField investigationFinal reportCessna 172F · San Luis Obispo, CAThe pilot's failure to maintain a proper climb rate to VFR conditions on-top.Jan 7, 2001 · N383CA · Destroyed NTSB LAX98LA301Accident · No injuriesLimited investigationFinal reportCessna 172F · Long Beach, CAThe pilot's misjudging the flare point and failure to maintain an adequate airspeed margin, which resulted in a stall/mush and hard landing. A contributing factor was the dark night conditions.Sep 21, 1998 · N8761U · Substantial damage NTSB LAX96LA316Accident · No injuriesLimited investigationFinal reportCessna 172F · Ocotillo, CAthe pilot's failure to maintain proper runway alignment. The sun glare and proximity of rocks were related factors.Aug 26, 1996 · N5543R · Substantial damage NTSB LAX95LA295Accident · No injuriesLimited investigationFinal reportCessna 172F · Bradley, CAfuel exhaustion due to the pilot's failure to refuel prior to takeoff and his delayed decision to proceed to his alternate airport. The night light conditions and the lack of a suitable emergency landing area were factors.Aug 15, 1995 · N5563R · Substantial damage NTSB LAX95LA193Accident · No injuriesLimited investigationFinal reportCessna 172F · Boonville, CAa loss of engine power for undetermined reasons.May 26, 1995 · N5255F · Substantial damage NTSB LAX94LA192Accident · No injuriesLimited investigationFinal reportCessna 172F · Arlington, CAFailure of the certified flight instructor to properly supervise the student pilot and perform the appropriate remedial action before the airplane descended to an altitude too low for recovery. Factors were the student pilot's handling of the airplane which…Apr 17, 1994 · N5709R · Substantial damage NTSB LAX88LA310Accident · No injuriesLimited investigationFinal reportCessna 172F · Fairfield, CAThe pilot performed a soft field takeoff on a grass strip in winds gusting to 34 KTS. The airplane would not accelerate in ground effect, nor would it climb. Feeling that he could not out-climb objects in his path, the pilot turned to the right. As he turned…Sep 11, 1988 · N5149F · Substantial damage NTSB LAX80FVG27Accident · No injuriesClosedCessna 172F · Lake Berryessa, CAApr 16, 1980 · N5149F · Substantial damage NTSB LAX78FVA38Accident · No injuriesClosedCessna 172F · Bakersfield, CAApr 21, 1978 · N859CR · Substantial damage NTSB OAK76DXQ62Accident · No injuriesClosedCessna 172 · S.Lake Tahoe, CAAug 3, 1976 · N8332L · Substantial damage NTSB OAK76DVA74Accident · No injuriesClosedCessna 172 · Orange Cove, CAJun 26, 1976 · N5231Q · Destroyed NTSB OAK76DVW27Accident · Minor injuriesClosedCessna 172F · Furnace Creek, CAMay 19, 1976 · N5519R · Substantial damage NTSB LAX75AL023Accident · 2 fatalClosedCessna 172F · Lebec, CAOct 26, 1974 · N8275U · Destroyed NTSB OAK74AP012Accident · 3 fatalClosedCessna 172F · Weaverville, CASep 25, 1973 · N7858U · Destroyed NTSB OAK72FVA76Accident · No injuriesClosedPiper J3C · Merced, CAJun 4, 1972 · N3637N · 2 aircraft · Substantial damage NTSB OAK71DVM05Accident · No injuriesClosedCessna 172 · Simmler, CAJul 29, 1970 · N8768U · Substantial damage NTSB OAK70DVD30Accident · No injuriesClosedCessna 172 · Schellville, CAJun 28, 1970 · N5571R · Substantial damage NTSB LAX70FUA20Accident · No injuriesClosedCessna 172 · Avalon, CAApr 11, 1970 · N8848U · Substantial damage NTSB OAK70D0094Accident · No injuriesClosedCessna 172 · Kerman, CAAug 23, 1969 · N8842U · Substantial damage NTSB LAX70F0019Accident · Serious injuriesClosedCessna 172F · Lake Henshaw, CAJun 22, 1969 · N5455R · Substantial damage NTSB OAK68D0013Accident · No injuriesClosedCessna 172 · Oakland, CAMay 23, 1967 · N8185U · Substantial damage NTSB LAX67D0394Accident · No injuriesClosedCessna 172 · Apple Valley, CAApr 19, 1967 · N5396R · Substantial damage NTSB OAK67D0276Accident · Serious injuriesClosedCessna 172 · Carmel, CAMar 16, 1967 · N8166U · Substantial damage NTSB LAX67D0313Accident · No injuriesClosedCessna 172 · El Monte, CAFeb 17, 1967 · N8166U · Substantial damage NTSB OAK67F0227Accident · Serious injuriesClosedCessna 172F · Monterey, CAJan 16, 1967 · N5650R · Destroyed NTSB LAX67D0271Accident · No injuriesClosedCessna 172 · Agua Dulce, CAJan 15, 1967 · N5609R · Substantial damage NTSB LAX67D0221Accident · No injuriesClosedCessna 172 · Mojave, CADec 7, 1966 · N8848U · Substantial damage NTSB OAK67A0041Accident · 3 fatalClosedCessna 172F · Woodford, CAOct 2, 1966 · N5655R · Destroyed NTSB OAK67D0125Accident · Serious injuriesClosedCessna 172 · Alvarado, CASep 17, 1966 · N5388R · Destroyed NTSB LAX67D0068Accident · No injuriesClosedCessna 172F · Oceanside, CAAug 5, 1966 · N8846U · Substantial damage NTSB OAK67D0022Accident · No injuriesClosedCessna 172C · Petaluma, CAJun 18, 1966 · N7966U · Substantial damage NTSB LAX66D0368Accident · No injuriesClosedCessna 172 · Apple Valley, CAMay 29, 1966 · N8863U · Destroyed NTSB OAK66D0210Accident · No injuriesClosedCessna 172 · Sacramento, CAFeb 7, 1966 · N5571R · Substantial damage NTSB OAK66A0031Accident · 2 fatalClosedCessna 172F · Livermore, CAFeb 4, 1966 · N8184U · Destroyed NTSB LAX66F0250Accident · No injuriesClosedCessna 172 · Ontario, CAJan 16, 1966 · N5466R · Substantial damage NTSB LAX66A0047Accident · 2 fatalClosedCessna 172 · Winterhaven, CADec 9, 1965 · N8242U · Destroyed NTSB LAX66F0273Accident · No injuriesClosedCessna 172 · Santa Susana, CANov 25, 1965 · N5536R · Substantial damage NTSB OAK66A0009Accident · 1 fatalClosedCessna 172D · Kyburz, CASep 7, 1965 · N8282U · Destroyed NTSB OAK66F0102Accident · Minor injuriesClosedCessna 172 · Willits, CAAug 29, 1965 · N8712U · Substantial damage NTSB LAX66D0006Accident · No injuriesClosedCessna 172 · Lancaster, CAMay 31, 1965 · N7900U · Substantial damage NTSB OAK65F0039Accident · No injuriesClosedCessna 172 · Concord, CAApr 4, 1965 · N8303U · Substantial damage