Skip to content

NTSB investigations: Cessna 172B, CA

27 cases on aircraft the registry lists as Cessna 172B. 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 ('2072406')) 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 ('2072406'))
  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 ('2072406'))
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 GAA16LA001Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Redding, CAThe pilot’s improper decision to land the airplane on a short runway with a tailwind and his subsequent delayed decision to abort the landing.Oct 3, 2015 · N7837X · Substantial damage NTSB WPR12LA253Accident · Minor injuriesLimited investigationFinal reportCessna 172B · San Andreas, CAA loss of engine power in cruise flight for reasons that could not be determined because a postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.Jun 9, 2012 · N7458X · Substantial damage NTSB SEA07CA107Accident · Minor injuriesData collectionFinal reportCessna 172B · Los Angeles, CAThe pilot's failure to maintain adequate airspeed during performance of a go around, resulting in an inadvertent stall and in-flight collision with the ground.Apr 19, 2007 · N7546X · Substantial damage NTSB LAX03FAMS3Accident · 1 fatalMissing aircraftFinal reportCessna 172B · Little River, CAAircraft is missing.May 26, 2003 · N7555X · Destroyed NTSB LAX91LA353Accident · No injuriesLimited investigationFinal reportCessna 172B · King City, CAThe total loss of engine power in cruise flight due to the failure of the number 3 cylinder exhaust valve, resulting in a forced landing, and subsequent nose over on landing roll out.Aug 11, 1991 · N7910X · Substantial damage NTSB LAX90LA245Accident · No injuriesLimited investigationFinal reportCessna 172 · Davis, CAThe pilot failed to maintin directional control by improperly using the brakes.Jul 8, 1990 · N7726X · Substantial damage NTSB LAX82FUQ11Accident · No injuriesFinal reportCessna 172 · Lancaster, CAAt 1530 PST, the pilot received a weather briefing from the Lancaster fss. At that time, the wind was variable, 230 to 250 degrees, at 20 KTS. The pilot reported the wind was variable from the same direction at 22 to 26 KTS, while taxiing to runway 24. The…Mar 14, 1982 · N7498X · Destroyed NTSB OAK77DVD11Accident · No injuriesClosedCessna 172 · Lodi, CAJan 22, 1977 · N7459X · Substantial damage NTSB OAK77DVG02Accident · No injuriesClosedCessna 172 · Cedarville, CAOct 8, 1976 · N8073X · Substantial damage NTSB OAK76AP066Accident · 1 fatalClosedCessna 172B · Shelter Cove, CAAug 13, 1976 · N8058X · Destroyed NTSB OAK7LDVG03Accident · No injuriesClosedCessna 172 · Oroville, CAJul 5, 1975 · N7795X · Substantial damage NTSB LAX74AL020Accident · 3 fatalClosedCessna 172 · Silverado, CASep 10, 1973 · N7636X · Destroyed NTSB LAX72FUG27Accident · Serious injuriesClosedCessna 172 · Chino, CAOct 14, 1971 · N7621X · Substantial damage NTSB OAK72DVW07Accident · No injuriesClosedCessna 172 · Independnce, CAAug 1, 1971 · N7697X · Substantial damage NTSB OAK70DVD14Accident · No injuriesClosedCessna 172 · Schellville, CAApr 8, 1970 · N8035X · Destroyed NTSB LAX70F0156Accident · Minor injuriesClosedCessna 172 · Pacoima, CAOct 18, 1969 · N7494X · Substantial damage NTSB LAX69D0193Accident · No injuriesClosedCessna 172B · Pearblossom, CANov 17, 1968 · N7852X · Substantial damage NTSB OAK69A0016Accident · 4 fatalClosedCessna 172B · Niles, CASep 5, 1968 · N7938X · Destroyed NTSB LAX67D0355Accident · No injuriesClosedCessna 172 · Hawthorne, CAApr 14, 1967 · N8205X · Minor damage NTSB UNK65X0903Accident · No injuriesClosedCessna 172 · Inyokern, CADec 2, 1964 · N7882X · Substantial damage NTSB UNK65X0673Accident · No injuriesClosedCessna 172 · Oxnard, CANov 12, 1964 · N7501X · Substantial damage NTSB UNK64X4011Accident · 4 fatalClosedCessna 172B · Los Angeles, CASep 16, 1964 · N8025X · Destroyed NTSB UNK64X2511Accident · No injuriesClosedCessna 172B · Menachemeadow, CAJun 27, 1964 · N7780X · Substantial damage NTSB UNK64X2075Accident · Minor injuriesClosedCessna 172B · Frazier Park, CAJun 2, 1964 · N7523X · Destroyed NTSB UNK64X1363Accident · No injuriesClosedPiper PA23 · Santa Ana, CAApr 18, 1964 · N1317P · 2 aircraft · No damage NTSB UNK64X0171Accident · No injuriesClosedCessna 172B · Blythe, CAJan 5, 1964 · N7910X · Substantial damage NTSB UNK64X0130Accident · No injuriesClosedCessna 172 · Palo Alto, CAJan 3, 1964 · N6868X · Substantial damage