# NTSB investigations: Cessna 172B, CA NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports. ## Latest cases - [NTSB GAA16LA001](https://openairdocs.org/ntsb/GAA16LA001.md): Cessna 172B · Redding, CA · Accident · Serious injuries · Limited investigation · Final report · Oct 3, 2015 · N7837X · Substantial damage > The pilot’s improper decision to land the airplane on a short runway with a tailwind and his subsequent delayed decision to abort the landing. - [NTSB WPR12LA253](https://openairdocs.org/ntsb/WPR12LA253.md): Cessna 172B · San Andreas, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 9, 2012 · N7458X · Substantial damage > A 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. - [NTSB SEA07CA107](https://openairdocs.org/ntsb/SEA07CA107.md): Cessna 172B · Los Angeles, CA · Accident · Minor injuries · Data collection · Final report · Apr 19, 2007 · N7546X · Substantial damage > The 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. - [NTSB LAX03FAMS3](https://openairdocs.org/ntsb/LAX03FAMS3.md): Cessna 172B · Little River, CA · Accident · 1 fatal · Missing aircraft · Final report · May 26, 2003 · N7555X · Destroyed > Aircraft is missing. - [NTSB LAX91LA353](https://openairdocs.org/ntsb/LAX91LA353.md): Cessna 172B · King City, CA · Accident · No injuries · Limited investigation · Final report · Aug 11, 1991 · N7910X · Substantial damage > The 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. - [NTSB LAX90LA245](https://openairdocs.org/ntsb/LAX90LA245.md): Cessna 172 · Davis, CA · Accident · No injuries · Limited investigation · Final report · Jul 8, 1990 · N7726X · Substantial damage > The pilot failed to maintin directional control by improperly using the brakes. - [NTSB LAX82FUQ11](https://openairdocs.org/ntsb/LAX82FUQ11.md): Cessna 172 · Lancaster, CA · Accident · No injuries · Final report · Mar 14, 1982 · N7498X · Destroyed > At 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… - [NTSB OAK77DVD11](https://openairdocs.org/ntsb/OAK77DVD11.md): Cessna 172 · Lodi, CA · Accident · No injuries · Closed · Jan 22, 1977 · N7459X · Substantial damage - [NTSB OAK77DVG02](https://openairdocs.org/ntsb/OAK77DVG02.md): Cessna 172 · Cedarville, CA · Accident · No injuries · Closed · Oct 8, 1976 · N8073X · Substantial damage - [NTSB OAK76AP066](https://openairdocs.org/ntsb/OAK76AP066.md): Cessna 172B · Shelter Cove, CA · Accident · 1 fatal · Closed · Aug 13, 1976 · N8058X · Destroyed - [NTSB OAK7LDVG03](https://openairdocs.org/ntsb/OAK7LDVG03.md): Cessna 172 · Oroville, CA · Accident · No injuries · Closed · Jul 5, 1975 · N7795X · Substantial damage - [NTSB LAX74AL020](https://openairdocs.org/ntsb/LAX74AL020.md): Cessna 172 · Silverado, CA · Accident · 3 fatal · Closed · Sep 10, 1973 · N7636X · Destroyed - [NTSB LAX72FUG27](https://openairdocs.org/ntsb/LAX72FUG27.md): Cessna 172 · Chino, CA · Accident · Serious injuries · Closed · Oct 14, 1971 · N7621X · Substantial damage - [NTSB OAK72DVW07](https://openairdocs.org/ntsb/OAK72DVW07.md): Cessna 172 · Independnce, CA · Accident · No injuries · Closed · Aug 1, 1971 · N7697X · Substantial damage - [NTSB OAK70DVD14](https://openairdocs.org/ntsb/OAK70DVD14.md): Cessna 172 · Schellville, CA · Accident · No injuries · Closed · Apr 8, 1970 · N8035X · Destroyed - [NTSB LAX70F0156](https://openairdocs.org/ntsb/LAX70F0156.md): Cessna 172 · Pacoima, CA · Accident · Minor injuries · Closed · Oct 18, 1969 · N7494X · Substantial damage - [NTSB LAX69D0193](https://openairdocs.org/ntsb/LAX69D0193.md): Cessna 172B · Pearblossom, CA · Accident · No injuries · Closed · Nov 17, 1968 · N7852X · Substantial damage - [NTSB OAK69A0016](https://openairdocs.org/ntsb/OAK69A0016.md): Cessna 172B · Niles, CA · Accident · 4 fatal · Closed · Sep 5, 1968 · N7938X · Destroyed - [NTSB LAX67D0355](https://openairdocs.org/ntsb/LAX67D0355.md): Cessna 172 · Hawthorne, CA · Accident · No injuries · Closed · Apr 14, 1967 · N8205X · Minor damage - [NTSB UNK65X0903](https://openairdocs.org/ntsb/UNK65X0903.md): Cessna 172 · Inyokern, CA · Accident · No injuries · Closed · Dec 2, 1964 · N7882X · Substantial damage - [NTSB UNK65X0673](https://openairdocs.org/ntsb/UNK65X0673.md): Cessna 172 · Oxnard, CA · Accident · No injuries · Closed · Nov 12, 1964 · N7501X · Substantial damage - [NTSB UNK64X4011](https://openairdocs.org/ntsb/UNK64X4011.md): Cessna 172B · Los Angeles, CA · Accident · 4 fatal · Closed · Sep 16, 1964 · N8025X · Destroyed - [NTSB UNK64X2511](https://openairdocs.org/ntsb/UNK64X2511.md): Cessna 172B · Menachemeadow, CA · Accident · No injuries · Closed · Jun 27, 1964 · N7780X · Substantial damage - [NTSB UNK64X2075](https://openairdocs.org/ntsb/UNK64X2075.md): Cessna 172B · Frazier Park, CA · Accident · Minor injuries · Closed · Jun 2, 1964 · N7523X · Destroyed - [NTSB UNK64X1363](https://openairdocs.org/ntsb/UNK64X1363.md): Piper PA23 · Santa Ana, CA · Accident · No injuries · Closed · Apr 18, 1964 · N1317P · 2 aircraft · No damage - [NTSB UNK64X0171](https://openairdocs.org/ntsb/UNK64X0171.md): Cessna 172B · Blythe, CA · Accident · No injuries · Closed · Jan 5, 1964 · N7910X · Substantial damage - [NTSB UNK64X0130](https://openairdocs.org/ntsb/UNK64X0130.md): Cessna 172 · Palo Alto, CA · Accident · No injuries · Closed · Jan 3, 1964 · N6868X · Substantial damage ## The whole list in SQL Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS: ```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 ``` This list as a web page: https://openairdocs.org/ntsb?model=2072406&state=CA --- OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.