Skip to content

NTSB investigations: Cessna 172C, CA

17 cases on aircraft the registry lists as Cessna 172C. 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 ('2072408')) 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 ('2072408'))
  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 ('2072408'))
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 LAX04CA157Accident · Minor injuriesData collectionFinal reportCessna 172C · Thermal, CAthe pilot's failure to retract the flaps during the go-around and his failure to obtain and maintain sufficient airspeed, which led to a stall mush condition. High density altitude was a contributing factor.Mar 14, 2004 · N8287X · Substantial damage NTSB LAX02FA040Accident · No injuriesField investigationFinal reportCessna 172C · Corona, CAa loss of engine power due to the pilot's improper use of the carburetor heat controls while in weather conditions conducive to serious carburetor icing.Dec 5, 2001 · N1834Y · Substantial damage NTSB LAX87LA021Accident · Serious injuriesLimited investigationFinal reportCessna 172C · Michigan Bar, CADuring a pleasure cross-country flight, the aircraft experienced an enging failure. Examination of the fuel tanks revealed that both tanks were empty of fuel. The carburetor was removed from the engine and found to contain approximately 1 tablespoon of fuel.…Oct 19, 1986 · N8449X · Substantial damage NTSB LAX84LA001Accident · No injuriesLimited investigationFinal reportCessna 172 · Salinas, CAThe acft nosed over during a forced landing after the engine quit on an inital approach to land. The pilot had taken offfrom monterey CA at 1100 hours PDT to fly to Salinas CA with an estimated 4-5 gallons of fuel on board the acft. At 1150PDT the acft landed…Oct 1, 1983 · N8426X · Substantial damage NTSB LAX83LA108Accident · Serious injuriesLimited investigationFinal reportCessna 172C · Rubidoux, CAThe acft crashed alongside the runway during takeoff in windy conditions. Witnesses observed the acft stagger into the air at slow airspeed from a grass runway into a 20-30 KTS santa ana wind out of the north. The pilot stated that he attempted a soft field…Feb 19, 1983 · N8347X · Destroyed NTSB LAX82DA220Accident · No injuriesFinal reportCessna 172 · Lancaster, CADuring flight, the pilot landed at an airport to refuel. However, the fuel trucks were locked up and no one was at the UNICOM office, even though, the airport directory indicated the field was attended and fuel should have been available. The pilot…Jun 14, 1982 · N1580Y · Substantial damage NTSB LAX80DVG75Accident · Minor injuriesClosedCessna 172C · Mount Shasta, CASep 26, 1980 · N1843Y · Destroyed NTSB LAX74FUA04Accident · No injuriesClosedCessna 172C · Huntngtn Bh, CAAug 26, 1973 · N8248X · Substantial damage NTSB LAX72DUQ78Accident · Minor injuriesClosedCessna 172 · Inyokern, CAApr 14, 1972 · N1484Y · Substantial damage NTSB OAK72AP028Accident · 1 fatalClosedCessna 172 · Strawberry, CAFeb 13, 1972 · N1360Y · Destroyed NTSB OAK71FVW07Accident · Serious injuriesClosedCessna 172G · Bishop, CASep 5, 1970 · N8264X · Substantial damage NTSB OAK70DVD32Accident · Minor injuriesClosedCessna 172 · Lodi, CAJun 28, 1970 · N8491X · Substantial damage NTSB OAK70D0136Accident · Minor injuriesClosedCessna 172 · Lodi, CASep 18, 1969 · N1486Y · Substantial damage NTSB OAK70D0190Accident · No injuriesClosedCessna 172 · Furnace Cr, CAOct 21, 1968 · N8375X · Substantial damage NTSB LAX67D0351Accident · No injuriesClosedCessna 172 · Agua Dulce, CAMar 7, 1967 · N1452Y · Substantial damage NTSB LAX66F0225Accident · Minor injuriesClosedCessna 172 · Apple Valley, CAJan 31, 1966 · N8480X · Destroyed NTSB OAK66F0100Accident · Minor injuriesClosedCessna 172 · St Lus Obispo, CAAug 17, 1965 · N8391X · Substantial damage