NTSB investigations, 1992, CA
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 1962 | 10 |
|---|---|
| 1963 | 11 |
| 1964 | 659 |
| 1965 | 654 |
| 1966 | 755 |
| 1967 | 799 |
| 1968 | 668 |
| 1969 | 613 |
| 1970 | 617 |
| 1971 | 605 |
| 1972 | 510 |
| 1973 | 499 |
| 1974 | 523 |
| 1975 | 488 |
| 1976 | 484 |
| 1977 | 497 |
| 1978 | 548 |
| 1979 | 473 |
| 1980 | 472 |
| 1981 | 403 |
| 1982 | 391 |
| 1983 | 441 |
| 1984 | 388 |
| 1985 | 329 |
| 1986 | 316 |
| 1987 | 315 |
| 1988 | 322 |
| 1989 | 289 |
| 1990 | 318 |
| 1991 | 291 |
| 1992 | 277 |
| 1993 | 260 |
| 1994 | 242 |
| 1995 | 237 |
| 1996 | 223 |
| 1997 | 182 |
| 1998 | 212 |
| 1999 | 186 |
| 2000 | 222 |
| 2001 | 183 |
| 2002 | 176 |
| 2003 | 182 |
| 2004 | 171 |
| 2005 | 191 |
| 2006 | 187 |
| 2007 | 207 |
| 2008 | 158 |
| 2009 | 187 |
| 2010 | 158 |
| 2011 | 141 |
| 2012 | 134 |
| 2013 | 128 |
| 2014 | 117 |
| 2015 | 118 |
| 2016 | 119 |
| 2017 | 162 |
| 2018 | 119 |
| 2019 | 114 |
| 2020 | 105 |
| 2021 | 94 |
| 2022 | 111 |
| 2023 | 103 |
| 2024 | 101 |
| 2025 | 91 |
| 2026 | 80 |
Where
Open the mapLatest cases
Query with SQL
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 year(c.\"eventDate\") = 1992
AND c.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
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 year(c."eventDate") = 1992 AND c."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA' 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 LAX93LA085Accident · No injuriesLimited investigationFinal reportMooney M20F · So. Lake Tahoe, CAThe pilot's failure to maintain directional control of the aircraft due to gusting cross winds and ice on the runway.NTSB LAX93LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Big Bear, CAThe pilot's failure to maintain directional control of the aircraft after touchdown.NTSB LAX93LA079Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-125 · Herald, CAThe failure of the pilot to maintain a proper descent rate and his failure to take timely remedial action to correct a high sink rate prior to colliding with the ground.NTSB LAX93FA086Accident · 2 fatalField investigationFinal reportRockwell 690B · Herlong, CAAn inadvertent encounter with severe turbulence which exceeded the design strength of the airplane's structure.NTSB LAX93LA082Accident · No injuriesLimited investigationFinal reportMaule MX-7-180 · Oceano, CAThe pilot's operation of the aircraft with known deficiencies in the brake system.NTSB LAX93LA078Accident · No injuriesLimited investigationFinal reportCessna 150 · Oakland, CA1) The pilots failure to compensate for winds during the landing sequence, 2) the improper use of the flight controls by not maintaining directional control of the aircraft,and 3) the pilots failure to maintain an adequate airspeed during the landing phase…NTSB LAX93LA076Accident · Minor injuriesLimited investigationFinal reportCurtiss JN-4D · Livermore, CAThe shearing of the number 8 cylinder rocker arm support pedestal/coolant housing retaining bolts. Contributing to the accident was a loss of engine coolant.NTSB LAX93LA073Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Long Beach, CAA failure of the dual student (second pilot) to properly perform the touch down, and properly assess the terrain at the point of touch down, of an intentional autorotation. Contributing to the accident was a failure of the flight instructor (first pilot) to…NTSB LAX93LA072Accident · No injuriesLimited investigationFinal reportCessna 180K · Fullerton, CAThe airplane's owners (including the pilot) poor maintenance and the pilot's inadequate preflight inspection. Contributing to this accident was the deteriorated overwing fuel caps seals and the tailwind.NTSB LAX93LA070Accident · No injuriesLimited investigationFinal reportBeech C24R · Oakland, CAFuel starvation due to improper fuel system management by both pilots and the failure of the flight instructor to adequately supervise the conduct of the flight.NTSB LAX93LA067Accident · Minor injuriesLimited investigationFinal reportBeech 23-C23 · Oceanside, CAThe pilot's failure to attain the proper touchdown point and to initiate a timely go around when the landing over shoot became apparent.NTSB LAX93FA066Accident · 2 fatalField investigationFinal reportPiper PA-31P · Oceanside, CAThe airplane colliding with the ocean due to unknown reason (s).NTSB LAX93FAMS2Accident · 4 fatalMissing aircraftFinal reportPiper PA-28-181 · Missing Acft, CAUndetermined.NTSB LAX93LA064Accident · No injuriesLimited investigationFinal reportPiper PA-32-301T · Auburn, CAFailure of the pilot to maintain direction control during the landing touchdown. Contributing to the accident inadequate maintenance of the runway safety area by airport personnel.NTSB LAX93LA061Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Novato, CAFailed to maintain directional control and an inadequate visual lookout. Contributing to this accident were the inoperative runway lights.NTSB LAX93LA059Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Lost Hills, CAThe pilot's poor preflight planning/preparation, poor fuel consumption calculations, and delay in effecting any remedial action. Contributing to this accident was the pilot inadvertently becoming Lost/disoriented and the dark night.NTSB LAX93LA058Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Fresno, CAThe pilot's inadequate preflight. Contributing to this accident was the separation of the fuel cap, tail rotor blade balance weight, tail rotor gear box, and the vertical fin.NTSB LAX93LA057Accident · 2 fatalLimited investigationFinal reportHughes 369B · Fallbrook, CAThat the pilot misjudged the distance of the high tension wires from the helicopter.NTSB LAX93FA055Accident · 5 fatalField investigationFinal reportCessna T210M · Thornton, CAThe failure of the pilots of both airplanes to see and avoid each other. Contributing to the accident was the failure of the sacramento controller to advise the stockton controller of the impending unsafe situation, and the failure of the stockton controller…NTSB LAX93LA054Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Rialto, CAThe pilot's poor preflight inspection and his failure to maintain flying speed during the forced landing. Conributing to this accident was the inadvertent stall, the preceding sand/dust storm, the engine assembly low compression due to sand in the intake and…NTSB LAX93T#A04Accident · No injuriesClass 3Final reportMcDonnell Douglas 369E · Juniper Flats, CANTSB LAX93LA051Accident · Serious injuriesLimited investigationFinal reportCessna 421C · Santa Maria, CA1) The internal failure of the left engine, left magneto due to inadequate maintenance and non compliance with the manufacturers service bulletins and recommendations, and 2) the failure of the pilot to attain the proper touchdown point during the landing…NTSB LAX93LA049Accident · No injuriesLimited investigationFinal reportMooney M20J · Santa Ana, CAThe pilot's improper landing flare, his improper bounced landing recovery technique, and his inadvertent entry into a stall mush condition.NTSB LAX93LA048Accident · 1 fatalLimited investigationFinal reportRans S-10 Sakota · San Jose, CA1) The loss of engine power due to undetermined reason(s), and, 2) the pilot not maintaining airspeed above the power off stall speed while maneuvering to the runway resulting in an inadvertent stall/spin. A factor in this accident was the pilot not having…NTSB LAX93FA046Accident · 2 fatalField investigationFinal reportCessna 172N · Tehachapi, CAThe pilot's decision to cruise at an altitude inadequate to ensure terrain clearance. Factors which contributed to the accident were: the pilot's failure to obtain a preflight weather briefing, the dark night, and likely instrument meteorological conditions.NTSB LAX93LA060Accident · No injuriesLimited investigationFinal reportCessna 180 · Clarksburg, CAThe pilot's improper use of the ailerons.NTSB LAX93LA044Accident · No injuriesLimited investigationFinal reportHughes 369D · Carlsbad, CAFailure of the overrunning clutch assembly bearing for undetermined reasons.NTSB LAX93FA042Accident · 2 fatalField investigationFinal reportCessna TU-206F · Clearlake, CAThe exhaust valve failing due to a complete fracture which resulted in the total lose of engine power. Factors in this accident were: 1) the terrain not being suitable for a forced landing, and 2) low ambient light which hampered the pilot's ability to see…NTSB LAX93LA041Accident · 1 fatalLimited investigationFinal reportLitchford Falcon XP · Palm Springs, CAThe pilot's inflight loss of control for reasons related to the improper installation and functioning of the rudder control system, and, the pilot's inadvertent entry into a stall spin.NTSB LAX93LA039Accident · No injuriesLimited investigationFinal reportGlaser-Dirks DG400 · Calistoga, CAThe failure of the brakes due to a separation of the brake cable for undetermined reasons. A factor in the accident was the tailwind condition during the landing rollout.NTSB LAX93LA038Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Mariposa, CAThe pilot's failure to maintain a sufficient airspeed margin while on final approach, and, after encountering a down draft, his failure to correct the resulting descent rate and maintain a glide path which would maintain obstacle clearance.NTSB LAX93LA035Accident · No injuriesLimited investigationFinal reportCessna 182P · Hawthorne, CAThe pilot's improper use of the brakes. Contributing to this accident was the worn brake pedals.NTSB LAX93LA034Accident · No injuriesLimited investigationFinal reportCessna 195 · El Cajon, CAThe pilot's improper use of the brakes.NTSB LAX93LA032Accident · 1 fatalLimited investigationFinal reportR.W. Sherman Turbulent · Adelanto, CAThe pilot's improper emergency decision to attempt to return to the departure area. Contributing to this accident was the undetermined loss of power, inadequate altitude, and failure to maintain the airspeed.NTSB LAX93LA026Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Fontana, CAThe noncertificated pilot's unwarranted low flying.NTSB LAX93LA021Accident · Minor injuriesLimited investigationFinal reportBell 47G2 · Gonzales, CAThe pilot's failure to maintain adequate clearance from the wires.NTSB LAX93FA024Accident · 2 fatalField investigationFinal reportPiper PA-24-180 · Kelso, CAThe pilot's poor preflight planning; his inadequate weather evaluation; and his intentional VFR flight into instrument meteorological conditions. Contributing to the accident was the turbulence, rain and low clouds.NTSB LAX93LA017Accident · 1 fatalLimited investigationFinal reportPasporello, J.F. RV-3 · Lompoc, CAThe failure of an unidentified airframe or component system for unknown reasons and the resulting inflight fire.NTSB LAX93FA014Accident · Serious injuriesField investigationFinal reportCessna T337G · Fullerton, CAThe pilot's failure to maintain control of the aircraft during a circle to land maneuver in reduced visibility conditions. A factor in the accident was his distraction while reconfiguring the aircraft for a go around which led to an inadvertent entry into a…NTSB LAX93LA013Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Warner Springs, CAThe pilot's inadequate planned approach to the runway, and, his improper use of the flight controls which resulted in an inadvertent accelerated stall/spin.NTSB LAX93LA012Accident · 2 fatalLimited investigationFinal reportGilbert SX300 · Rosamond, CAThe pilots inadequate compensation for the wind conditions and his failure to maintain an adequate airspeed while maneuvering which led to an inadvertent stall spin.NTSB LAX93FA011Accident · 2 fatalField investigationFinal reportPiper PA28-140 · Rosemead, CAThe pilot's poor preflight planning/preparation and intentional flight into instrument meteorological conditions. Factors relating to this accident were the prevailing low ceiling and fog.NTSB LAX93LA010Accident · No injuriesLimited investigationFinal reportBell 47-D1 · El Monte, CAThe pilot's failure to maintain the rotor RPM.NTSB LAX93LA009Accident · No injuriesLimited investigationFinal reportCessna 210F · Buena Park, CAFailure of the pilot to adequately detect water contamination in the airplane's fuel system during preflight.NTSB LAX93FA007Accident · 1 fatalField investigationFinal reportCessna 172M · Fairfield, CAThe pilot's delay in initiating a go-around during a night landing. Factors related to the accident were: the pilot misjudging distance and speed resulting a overshooting the touchdown, the night light condition, his lack of night flying experience in a…NTSB LAX93LA005Accident · 1 fatalLimited investigationFinal reportSwich II · El Mirage, CAThe pilot/owner's improper installation of the vertical stabilizer. Contributing to this accident was the pilot's intentional stall, inadvertent spin, and inability to recover from the spin due to the inadequate equipment (vertical stabilizer) design.NTSB LAX93T#A01Accident · No injuriesClass 3Final reportDouglas DC-7B · Kyburz, CANTSB LAX92FA410Accident · 2 fatalField investigationFinal reportRobinson R22-B · Martinez, CAAn undetermined divergence of the main rotor from its normal plane of rotation which resulted in rotor contact to the fuselage and passenger.NTSB LAX92LA408Accident · 2 fatalLimited investigationFinal reportAir Command · Eureka, CAThe failure of the unqualified non certificated pilot to maintain control of the gyrocopter. A factor in the accident was the pilot's lack of total experience.NTSB LAX92LA404Accident · 1 fatalLimited investigationFinal reportLanceair 235 · Hollister, CAThe pilot performing the final segment of a visual approach at too low of an altitude resulting in an inflight collision with a guy wire.