Skip to content

NTSB investigations: Cessna 172A, CA

39 cases on aircraft the registry lists as Cessna 172A. 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 ('2072404')) 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 ('2072404'))
  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 ('2072404'))
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 LAX06LA056Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Corona, CAfailure of both pilots to see and avoid each other during traffic pattern operations at a non-towered airport.Dec 11, 2005 · N65696 · 2 aircraft · Substantial damage NTSB LAX01LA282Accident · Minor injuriesLimited investigationFinal reportCessna 172-A · Groveland, CAa loss of engine power due to water contamination forced the pilot to land in an unsuitable area resulting in collision with a tree.Aug 18, 2001 · N7198T · Substantial damage NTSB LAX00LA062Accident · Minor injuriesLimited investigationFinal reportCessna 172A · Dos Palos, CAA partial loss of engine power due to the failure of maintenance personnel to properly install and safety the throttle arm to the carburetor throttle shaft.Jan 2, 2000 · N7249T · Substantial damage NTSB LAX00LA053Accident · No injuriesLimited investigationFinal reportCessna 172A · Shoshone, CAThe pilot's inadequate compensation for the existing strong and gusting wind conditions and his subsequent failure to maintain directional control.Dec 18, 1999 · N34261 · Substantial damage NTSB LAX98LA163Accident · No injuriesLimited investigationFinal reportCessna 172A · Van Nuys, CAThe pilot's failure to maintain obstacle clearance due to his inadequate visual lookout and selection of the wrong taxi route. Contributing factors were the pilot's diverted attention while taxiing in the vicinity of a construction area.May 17, 1998 · N7222T · Substantial damage NTSB LAX95LA316Accident · No injuriesLimited investigationFinal reportCessna 172A · Weed, CAthe flight instructor's failure to maintain directional control of the aircraft.Aug 30, 1995 · N7641T · Substantial damage NTSB LAX95LA181Accident · Minor injuriesLimited investigationFinal reportCessna 172A · Colusa, CAthe pilot's selection of an inadequate en route cruise altitude for the aerial observation flight, and his failure to identify and stop an inadvertent descent while flying over flooded terrain at a very low altitude. Lack of pilot experience in low level…May 7, 1995 · N7358T · Destroyed NTSB LAX93LA273Accident · Minor injuriesLimited investigationFinal reportCessna 172A · Moccasin, CAFuel exhaustion due to the pilot's failure to perform fuel consumption calculations. Factors related to this accident were: the pilot's inadequate preflight or inflight planning and preparation.Jul 4, 1993 · N7875T · Substantial damage NTSB LAX86LA230Accident · No injuriesLimited investigationFinal reportCessna 172B · Tracy, CAThe acft veered off a rural dirt road being used as an airstrip and nosed over in a farm field. The plt indicated that he was attempting to land on a narrow dirt farm road when the acft veered into a freshly plowed and irrigated tomato field. The nose gear…May 18, 1986 · N7176T · Substantial damage NTSB LAX84LA203Accident · Minor injuriesLimited investigationFinal reportCessna 172A · San Jose, CAThe plt of the Cessna 172 requested clearance to rwy 30R & was cleared as requested. While taxiing, he was cautioned about turbulence behind a DC-9. The DC-9 plts were waiting to takeoff on rwy 30L. The Cessna plt started to pass as the DC-9 was cleared onto…Feb 28, 1984 · N7168T · Substantial damage NTSB LAX83LA284Accident · No injuriesLimited investigationFinal reportCessna 172A · Carmel Valley, CAAccording to the pilot there were no tiedowns, chocks or other restraining devices available so he ask a non certificated person to sit in the aircraft and apply the brakes while he rotated the prop by hand to start the engine. The engine started and the…Jun 5, 1983 · N9854T · Substantial damage NTSB LAX81FVG06Accident · Minor injuriesClosedCessna 172A · San Andreas, CANov 28, 1980 · N7614T · Substantial damage NTSB LAX80FXQ28Accident · 2 fatalClosedCessna 172A · Tahoe City, CAMay 25, 1980 · N7803T · Substantial damage NTSB OAK76FP050Accident · 2 fatalClosedCessna 172A · Planada, CAApr 10, 1976 · N7705T · Destroyed NTSB LAX7LDVA05Accident · Minor injuriesClosedCessna 172A · Bakersfield, CAAug 18, 1975 · N9720T · Substantial damage NTSB OAK75DVA12Accident · No injuriesClosedCessna 172A · Dinuba, CAAug 15, 1974 · N7861T · Substantial damage NTSB OAK73DVM23Accident · No injuriesClosedCessna 172 · Salinas, CAFeb 18, 1973 · N7613T · Substantial damage NTSB OAK72FVD37Accident · Serious injuriesClosedCessna 172A · Livermore, CAMar 25, 1972 · N7213T · Substantial damage NTSB LAX70D0162Accident · No injuriesClosedCessna 172 · Anza, CAOct 11, 1969 · N7713T · Substantial damage NTSB LAX70F0068Accident · Serious injuriesClosedCessna 172A · Rosamond, CAAug 7, 1969 · N9773T · Substantial damage NTSB LAX69D0281Accident · No injuriesClosedCessna 172 · Lucerne Vally, CAFeb 18, 1969 · N9874T · Substantial damage NTSB LAX69A0046Accident · 3 fatalClosedCessna 172 · Tehachapi, CAJan 27, 1969 · N7285T · Destroyed NTSB LAX69D0077Accident · No injuriesClosedCessna 172 · Irwindale, CAJul 27, 1968 · N7557T · Substantial damage NTSB OAK69D0100Accident · No injuriesClosedCessna 172 · Woodland, CAJun 29, 1968 · N9735T · Substantial damage NTSB LAX68D0229Accident · No injuriesClosedCessna 172A · Corona, CADec 2, 1967 · N7217T · Substantial damage NTSB LAX68D0058Accident · No injuriesClosedCessna 172 · Riverside, CAJun 30, 1967 · N9803T · Substantial damage NTSB LAX67A0092Accident · 2 fatalClosedCessna 172A · Alberhill, CAMar 31, 1967 · N7172T · Destroyed NTSB LAX67D0211Accident · No injuriesClosedCessna 172 · Burbank, CANov 18, 1966 · N7460T · Substantial damage NTSB OAK67F0138Accident · No injuriesClosedCessna 172 · Marysville, CASep 19, 1966 · N7247T · Substantial damage NTSB OAK67A0024Accident · 2 fatalClosedCessna 172A · Davis, CAAug 14, 1966 · N9742T · Destroyed NTSB OAK67A0009Accident · 2 fatalClosedCessna 172 · San Carlos, CAJul 12, 1966 · N7484T · Destroyed NTSB OAK67F0238Accident · Minor injuriesClosedCessna 172A · Milpitas, CAJun 9, 1966 · N9896T · Substantial damage NTSB OAK66D0199Accident · No injuriesClosedCessna 172 · Fremont, CAFeb 22, 1966 · N9896T · Substantial damage NTSB UNK65X0640Accident · No injuriesClosedCessna 172 · Gualala, CANov 10, 1964 · N6831X · Destroyed NTSB UNK65X0244Accident · No injuriesClosedCessna 172 · El Monte, CAOct 11, 1964 · N7842T · Substantial damage NTSB UNK64X0968Accident · No injuriesClosedCessna 172 · Turlock, CAMar 18, 1964 · N7405T · Substantial damage NTSB UNK64X0899Accident · Serious injuriesClosedCessna 172 · Auburn, CAMar 13, 1964 · N9818T · Destroyed NTSB UNK64X0822Accident · 2 fatalClosedCessna 172 · Big Bear City, CAMar 6, 1964 · N7778T · Substantial damage NTSB UNK64X0735Accident · 1 fatalClosedCessna 172A · Quincy, CAFeb 28, 1964 · N7260T · Destroyed