NTSB investigations, 1997, CA

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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

19622026
NTSB investigations, 1997, CA per year, 1962–2026: 19,365 cases
196210
196311
1964659
1965654
1966755
1967799
1968668
1969613
1970617
1971605
1972510
1973499
1974523
1975488
1976484
1977497
1978548
1979473
1980472
1981403
1982391
1983441
1984388
1985329
1986316
1987315
1988322
1989289
1990318
1991291
1992277
1993260
1994242
1995237
1996223
1997182
1998212
1999186
2000222
2001183
2002176
2003182
2004171
2005191
2006187
2007207
2008158
2009187
2010158
2011141
2012134
2013128
2014117
2015118
2016119
2017162
2018119
2019114
2020105
202194
2022111
2023103
2024101
202591
202679

Latest 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\") = 1997
    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.

NTSB LAX98LA065Accident · No injuriesLimited investigationFinal reportCessna 172RG · Van Nuys, CAThe student and flight instructor's failure to verify that the landing gear was in the down position, and the design of the electrical system in which a single-point aircraft system malfunction (one open circuit breaker) disabled both the landing gear warning…Dec 30, 1997 · N5404V · Substantial damageNTSB LAX98LA054Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Stoil, CAThe pilot's failure to maintain adequate obstacle clearance and his inadequate visual outlook.. Factors were a severed fuel line which resulted in an in-flight fire, which diminished the pilot's ability to land the airplane with smoke and fire in the cockpit.Dec 24, 1997 · N91915 · DestroyedNTSB LAX98LA062Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Healdsburg, CAthe pilot's misjudged distance and altitude relationship to the runway during a short field approach, which resulted in an undershoot and a hard landing.Dec 21, 1997 · N8805P · Substantial damageNTSB LAX98LA058Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Truckee, CAinternal mechanical failure of the engine due to a progressive failure of the No. 3 connecting rod assembly. A contributing factor was the snow pack which covered the only accessible emergency landing area.Dec 20, 1997 · N5058L · Substantial damageNTSB LAX98IA061Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-80 · San Francisco, CAAn emergency evacuation due to fumes from a failed hydraulic line that entered into the cabin.Dec 20, 1997 · N932AS · No damageNTSB LAX98LA060Accident · No injuriesLimited investigationFinal reportCessna 180H · Santa Ynez, CAThe pilot's improper flare. Related factors were the crosswind conditions.Dec 13, 1997 · N123LJ · Substantial damageNTSB LAX98LA057Accident · Serious injuriesLimited investigationFinal reportSaab-Scania 340B · Ventura, CASeat belt not used. A related factor was the unforecasted severe air turbulence.Dec 11, 1997 · N329AE · No damageNTSB LAX98LA056Accident · Serious injuriesLimited investigationFinal reportJohnson Bushrod · Corona, CAAn in-flight loss of control resulting from a malfunction in the wing flap operating system. The malfunction produced asymmetrical drag and induced a roll which could not be overcome by the pilot's flight control inputs.Dec 9, 1997 · N6232F · DestroyedNTSB LAX98FA052Accident · 2 fatalField investigationFinal reportCessna 172N · Lytle Creek, CAthe non-instrument rated pilot's inadvertent VFR flight into instrument meteorological conditions (IMC), and subsequent loss of aircraft control, due to spatial disorientation. Factors relating to the accident were: the adverse weather conditions (low ceiling…Dec 7, 1997 · N3548E · DestroyedNTSB LAX98LA051Accident · No injuriesLimited investigationFinal reportLuscombe 8 · Grass Valley, CAthe pilot's inadvertent activation of the aircraft brakes during the landing rollout.Dec 2, 1997 · N2591K · Substantial damageNTSB LAX98LA049Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Union City, CABlockage of the fuel flow transducer, which resulted in fuel starvation and the loss of engine power. Unsuitable terrain for an emergency landing was a contributing factor.Dec 2, 1997 · N1396U · Substantial damageNTSB LAX98LA055Accident · No injuriesLimited investigationFinal reportCessna 172N · San Jose, CAthe student pilot's failure to maintain an appropriate airspeed and proper rate of descent, and his misjudged landing flare, which led to an uncontrolled porpoise and eventual collapse of the landing gear.Nov 28, 1997 · N739HE · Substantial damageNTSB LAX98LA047Accident · No injuriesLimited investigationFinal reportCessna 182F · Palmdale, CALoss of engine power due to icing conditions which plugged the fuel system vent.Nov 26, 1997 · N3543Y · Substantial damageNTSB LAX98FA045Accident · 1 fatalField investigationFinal reportCessna 152 · El Cajon, CAThe solo student's failure to see and follow the other aircraft on the downwind as he had been instructed. Factors influencing this accident was the failure of the pilots in the other aircraft to see and avoid the aircraft encroaching on his flight path; the…Nov 25, 1997 · N757FT · 2 aircraft · DestroyedNTSB LAX98LA044Accident · No injuriesLimited investigationFinal reportMaule M-7-235B · San Martin, CAThe pilot's inadequate compensation for the crosswind condition and his failure to maintain directional control.Nov 24, 1997 · N611BY · Substantial damageNTSB LAX98FA043Accident · 1 fatalField investigationFinal reportCessna 172N · La Jolla, CAthe pilot's act of suicide by intentionally diving his aircraft into the ocean.Nov 24, 1997 · N6463D · DestroyedNTSB LAX98LA042Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Long Beach, CAthe flight instructor's failure to thoroughly brief his student on the performance standards of the proposed autorotation and the method to be used for a positive transfer of controls. The student's failure to verify the performance standards of the…Nov 22, 1997 · N45SG · Substantial damageNTSB LAX98LA040Accident · No injuriesLimited investigationFinal reportAero Commander 200D · San Carlos, CAThe pilot's failure to verify that there was an adequate supply of fuel in the selected fuel tank prior to takeoff.Nov 18, 1997 · N2910T · Substantial damageNTSB LAX98FA039Accident · 2 fatalField investigationFinal reportMooney M20 · Big Bear, CAVFR flight by the pilot into instrument meteorological conditions (VMC), which led to spatial disorientation, loss of aircraft control, and an uncontrolled descent into terrain. Related factors were: the adverse weather conditions, the pilot's lack of…Nov 15, 1997 · N5231B · DestroyedNTSB LAX98LA036Accident · No injuriesLimited investigationFinal reportCessna 172RG · San Diego, CAOverload of the main gear actuator piston and the subsequent collapse of the landing gear.Nov 12, 1997 · N9451D · Substantial damageNTSB LAX98LA035Accident · No injuriesLimited investigationFinal reportBeech C23 · Corona, CAThe loss of engine power for undetermined reasons. A factor was the rough terrain that resulted in a nose over during the landing roll.Nov 8, 1997 · N3724Z · Substantial damageNTSB LAX98LA034Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Los Angeles, CAThe pilot's loss of directional control due to an inadvertent ground loop resulting from a deflated tire.Nov 8, 1997 · N3232K · Substantial damageNTSB LAX98LA030Accident · No injuriesLimited investigationFinal reportCessna 172P · San Diego, CAThe student pilot's failure to maintain adequate clearance from a hangar while taxiing.Nov 5, 1997 · N98483 · Substantial damageNTSB LAX98GA029Accident · 2 fatalFinal reportCessna 182R · Markleeville, CAthe pilot-passenger's failure to maintain sufficient altitude and airspeed to avoid collision with terrain, and the pilot-in-command's diverted attention and failure to recognize a deteriorating situation in time to effect a safe recovery.Nov 3, 1997 · N2043E · DestroyedNTSB LAX98LA027Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Santa Rosa, CALoss of engine power for undetermined reasons.Oct 31, 1997 · N1655H · Substantial damageNTSB LAX98LA026Accident · Minor injuriesLimited investigationFinal reportStriplin Lone Ranger Slvr CLD · Agua Dulce, CAFailure of the propeller system/drive assembly, and the pilot's failure to maintain flying speed, which resulted in a stall and subsequent impact with the ground. Inadequate maintenance/inspection of the propeller system was a contributing factor.Oct 29, 1997 · N4478Y · DestroyedNTSB LAX98FA031Accident · 4 fatalField investigationFinal reportCessna U206B · Markleeville, CAthe pilot's improper planning/decision, which resulted in his failure to maintain sufficient altitude or clearance from mountainous terrain. Factors relating to the accident were: the excessive gross weight of the airplane, the high density altitude, and the…Oct 27, 1997 · N4982F · DestroyedNTSB LAX98LA021Accident · Serious injuriesLimited investigationFinal reportRevolution MINI-500 · Long Beach, CAloss of engine power and low rotor rpm for undeterminted reasons. The factory representative's recommendation to reduce the main rotor low pitch stop (from -1.8 degree to -0.5 degree) may have been a related factor.Oct 26, 1997 · N7234Y · DestroyedNTSB LAX98FA022Accident · 2 fatalField investigationFinal reportExtra Flugzeugbau EA-300 · Castaic, CAThe pilot's failure to maintain control of the aircraft during an aerobatic maneuver.Oct 26, 1997 · N69BW · DestroyedNTSB LAX98LA023Accident · No injuriesLimited investigationFinal reportCessna 182Q · Hamburg, CAthe pilot's improper flare, which resulted in a hard landing and overload failure of the nose gear. High terrain (obstruction) near the approach end of the runway was a related factor.Oct 24, 1997 · N759TA · Substantial damageNTSB LAX98LA019Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Fullerton, CAthe pilot's failure to maintain directional control of the airplane during landing roll, which resulted in an inadvertent ground swerve and subsequent damage to the airplane.Oct 23, 1997 · N8203P · Substantial damageNTSB LAX98LA018Accident · No injuriesLimited investigationFinal reportCessna 152 · Torrance, CAfailure of the student pilot to maintain directional control of the airplane during a touch-and-go landing, which resulted in an inadvertent ground swerve, an encounter with soft terrain, and a nose over. The sudden gust of wind was a related factor.Oct 23, 1997 · N89257 · Substantial damageNTSB LAX98LA015Accident · Minor injuriesLimited investigationFinal reportBeech D17S · Chino, CAfuel starvation resulting from the pilot's inadequate in-flight planning and improper fuel management. Contributing factors were the nighttime conditions and the rough/uneven terrain.Oct 20, 1997 · N67736 · Substantial damageNTSB LAX98FA008Accident · 1 fatalField investigationFinal reportAdrian Davis LONG-EZ · Pacific Grove, CAthe pilot's diversion of attention from the operation of the airplane and his inadvertent application of right rudder that resulted in the loss of airplane control while attempting to manipulate the fuel selector handle. Also, the Board determined that the…Oct 13, 1997 · N555JD · DestroyedNTSB LAX98LA011Accident · No injuriesLimited investigationFinal reportCessna 170A · Quincy, CAloss of directional control due to a severe tail wheel vibration, which was induced by an improperly installed and adjusted tail wheel assembly.Oct 12, 1997 · N9212A · Substantial damageNTSB LAX98FA009Accident · 1 fatalField investigationFinal reportBellanca 7ECA · Tracy, CAThe pilot's low operating altitude and his failure to maintain appropriate clearance during low level maneuvering flight. Contributing factors were transmission wires and the physical impairment that resulted from the effects of the over-the-counter…Oct 12, 1997 · N11860 · DestroyedNTSB LAX98LA025Accident · No injuriesLimited investigationFinal reportCiernia GLASAIR-III · Desert Center, CAA loss of engine power due to the eventual loss of electrical power which resulted from the pilot's failure to ensure the alternator switch was on as specified in the before starting checklist. The inoperative alternator out warning light was a factor in this…Oct 11, 1997 · N153JC · Substantial damageNTSB LAX98LA005Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 11 · Rancho Bernardo, CAThe pilot's intentional flight in high wind conditions and his improper in-flight planning.Oct 11, 1997 · N2585Z · Minor damageNTSB LAX98FA007Accident · 1 fatalField investigationFinal reportSchweizer 2-32 · Warner Springs, CAthe pilot's inadvertent flight into instrument meteorological conditions after inadvertently encountering mountain wave and associated downdraft conditions. The obscuration and high/mountainous terrain were related factors.Oct 11, 1997 · N242DB · Substantial damageNTSB LAX98FA006Accident · 1 fatalField investigationFinal reportCessna 152 · Julian, CAThe pilot's inadequate in-flight planning which resulted in VFR flight into instrument meteorological conditions and the loss of aircraft control. Contributing was the pilot's overconfidence in his ability, clouds, and rain.Oct 11, 1997 · N67293 · DestroyedNTSB LAX98LA003Accident · No injuriesLimited investigationFinal reportCessna 185F · Oakland, CAThe pilot's inadequate compensation for the existing crosswind condition, which resulted in a loss of directional control.Oct 5, 1997 · N17SR · Substantial damageNTSB LAX98LA001Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Burbank, CAA loss of engine power for undetermined reasons.Oct 3, 1997 · N2483B · Substantial damageNTSB LAX97FA330Accident · 2 fatalField investigationFinal reportRyan Navion B · Pacoima, CAthe dual student's improper positioning of the fuel selector and the CFI's inadequate supervision, which led to a takeoff with the auxiliary fuel tank selected and resulted in fuel starvation. A contributing factor was the position of the nomenclature on the…Sep 26, 1997 · N5241K · DestroyedNTSB LAX97FA328Accident · 4 fatalField investigationFinal reportBeech C23 · Torrance, CAThe failure of the pilot to attain and maintain adequate airspeed during the initial takeoff climb, which resulted in a stall/spin and subsequent collision with a building.Sep 21, 1997 · N543JL · DestroyedNTSB LAX97LA332Accident · No injuriesLimited investigationFinal reportCessna 172M · Long Beach, CAthe student pilot's misjudged landing flare which led to a balloon and subsequent hard landing.Sep 14, 1997 · N61913 · Substantial damageNTSB LAX97LA326Accident · Minor injuriesLimited investigationFinal reportLampert M500 · San Carlos, CAloss of engine power for undetermined reasons, and the pilot's improper use of the flight controls following the loss of power. The pilot's lack of training/certification in rotorcraft operations was a factor in this accident.Sep 13, 1997 · N800GL · Substantial damageNTSB LAX97LA323Accident · No injuriesLimited investigationFinal reportNewberg PL-4A · Placerville, CAfailure of the pilot to maintain directional control of the aircraft during the rollout phase of the landing sequence, which resulted in a gound swerve.Sep 12, 1997 · N44PN · Substantial damageNTSB LAX97LA321Accident · No injuriesLimited investigationFinal reportCessna 152 · Murrieta, CAfailure of the flight instructor (CFI) to ensure an adequate preflight of the airplane, and his failure to properly quantify or verify the fuel onboard before departing on a dual instruction flight, which resulted in fuel exhaustion and a forced landing.Sep 10, 1997 · N65406 · Substantial damageNTSB LAX97LA317Accident · Minor injuriesLimited investigationFinal reportBell 206B · Napa, CAFailure of the pilot to perform an adequate preflight, which resulted in him failing to notice and release the tie down chains.Sep 8, 1997 · N770GG · Substantial damageNTSB LAX97LA316Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Madera, CAfuel exhaustion due to the pilot's failure to compute the fuel required and the fuel available. The pilot's decision to extend his downwind beyond gliding distance of the runway after entering the traffic pattern was a factor in this accident.Sep 7, 1997 · N81MK · Substantial damage