NTSB investigations, 1997, AL

180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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, AL per year, 1962–2026: 2,501 cases
19621
19631
196461
196592
196670
196785
196868
196975
197089
197173
197276
197382
197467
197571
197677
197782
197872
197950
198050
198148
198261
198360
198441
198545
198648
198745
198836
198933
199032
199130
199240
199333
199427
199542
199632
199717
199827
199929
200017
200125
200227
200330
200427
200522
200624
200729
200828
200913
20108
201117
201225
201310
201424
201523
201612
201719
201820
201915
202017
202115
202221
202319
202411
202518
202617

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\" = 'AL' 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 ATL98LA018Accident · 1 fatalLimited investigationFinal reportJohn T. Simpson Challenger II · Rainbow City, ALThe pilot's failure to maintain adequate airspeed which resulted in a stall and subsequent impact with the ground. A related factor was the pilot's lack of flying experience.Dec 6, 1997 · N11644 · DestroyedNTSB MIA98LA036Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Hazel Green, ALthe pilot's miscalculating the aircraft's fuel consumption for the flight, resulting in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.Nov 28, 1997 · N3908L · Substantial damageNTSB MIA98LA031Accident · 1 fatalLimited investigationFinal reportde Havilland DHC-6-6 · Elberta, ALa passenger's inadvertent encounter with a rotating propeller.Nov 8, 1997 · N1022S · Minor damageNTSB MIA97LA236Accident · No injuriesLimited investigationFinal reportCessna 182Q · Butler, ALThe failure of the pilot to maintain directional control during a landing attempt after adding power to recover from a bounced landing.Aug 18, 1997 · N86TC · Substantial damageNTSB MIA97LA212Accident · Minor injuriesLimited investigationFinal reportContinental Copters MK5A · Sylacauga, ALThe failure of the pilot to maintain main rotor rpm resulting in the helicopter descending and colliding with trees.Jul 24, 1997 · N62108 · Substantial damageNTSB MIA97LA199Accident · No injuriesLimited investigationFinal reportSloan RV-6 · Muscle Shoals, ALthe pilot's failure to see-and-avoid the bales of hay duirng the takeoff roll, which resulted in an in-flight collision with a bale at liftoff and subsequent in-flight collision with terrain.Jun 28, 1997 · N626BA · Substantial damageNTSB MIA97LA153Accident · No injuriesLimited investigationFinal reportCessna 182P · Mobile, ALthe pilot's inadequate compensation for wind conditions and failure to maintain directional control during landing rollout, which resulted in a collision with a runway light.May 4, 1997 · N1530M · Substantial damageNTSB ATL97LA066Accident · No injuriesLimited investigationFinal reportPiper PA-22-180 · Russellville, ALThe loss of engine power for undetermined reasons. A factor was conditions were favorable for the formation of carburetor ice.May 1, 1997 · N5778Z · Substantial damageNTSB ATL97LA059Accident · No injuriesLimited investigationFinal reportCessna 210D · Huntsville, ALcorrosion and subsequent failure of the elevator trim tab, which resulted in vibration and failure of the elevator. Failure of maintenance personnel to comply with a service bulletin was a related factor.Apr 14, 1997 · N3761Y · Substantial damageNTSB MIA97LA137Accident · No injuriesLimited investigationFinal reportCessna 185D · Wetumpka, ALloss of engine power during a go-around for undetermined reason(s).Apr 11, 1997 · N285BG · Substantial damageNTSB MIA97LA118Accident · No injuriesLimited investigationFinal reportCessna 210M · Troy, ALThe pilot's failure to obtain the proper touchdown point during an emergency landing resulting in an overrun and subsequent nose over. A factor in the accident was a reported partial loss of engine power for undetermined reasons.Apr 3, 1997 · N761VX · Substantial damageNTSB ATL97LA053Accident · Minor injuriesLimited investigationFinal reportCatchot Hauler · Centerville, ALthe engine manufacturer's failure to install ballast resistors in the ignition system, which resulted in an electrical short in the dual ignition system and subsequent loss of engine power.Apr 1, 1997 · N301A · Substantial damageNTSB MIA97LA103Accident · Serious injuriesLimited investigationFinal reportHughes TH-55 · Cullman, ALa loss of engine power for undetermined reasons and the pilot-in-command's failure to maintain control of the helicopter. Factors in this accident were: an improper autorotation as a result of improper collective use and resulting failure to maintain main…Mar 28, 1997 · N818D · Substantial damageNTSB MIA97LA102Accident · No injuriesLimited investigationFinal reportBeech A23-19 · Bessemer, ALthe student pilot's misjudged landing flare and the CFI's inadequate supervision by not taking timely remedial action.Mar 27, 1997 · N300JL · Substantial damageNTSB MIA97FA095Accident · 3 fatalField investigationFinal reportCessna T210L · Meridianville, ALthe pilot's improper decision to takeoff downwind which resulted in his failure to maintain control of the airplane. The winds were a factor.Mar 6, 1997 · N2142S · DestroyedNTSB MIA97LA096Accident · Serious injuriesLimited investigationFinal reportCessna 182E · Huntsville, ALTotal loss of engine power due to fuel exhaustion for undetermined reasons.Mar 4, 1997 · N3392Y · Substantial damageNTSB ATL97FA034Accident · 2 fatalField investigationFinal reportCessna A150L · Trinity, ALfailure of the pilot to maintain flying airspeed, while maneuvering at low altitude, which resulted in a stall and subsequent collision with a tree, utility line, and the ground.Feb 1, 1997 · N50TB · Destroyed