NTSB investigations, 1997, FL

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, FL per year, 1962–2026: 10,190 cases
19627
19636
1964199
1965231
1966227
1967258
1968206
1969197
1970214
1971205
1972234
1973254
1974238
1975218
1976203
1977220
1978250
1979242
1980261
1981208
1982190
1983219
1984230
1985212
1986217
1987200
1988187
1989183
1990147
1991158
1992131
1993147
1994175
1995136
1996137
1997146
1998162
1999143
2000138
2001120
2002134
2003136
2004120
2005150
2006133
2007150
2008133
2009103
2010103
2011110
2012101
201391
2014101
201599
201696
201797
2018120
2019113
202092
202197
202282
202383
2024103
2025105
202682

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\" = 'FL' 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 ATL98FA030Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Tallahassee, FLThe pilot's failure to maintain the proper glidepath and adequate obstacle clearance which resulted in collision with a power transmission line.Dec 23, 1997 · N8074Z · DestroyedNTSB MIA98LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Everglades City, FLthe pilot's improper fuel management and improper in-flight planning/decision, which resulted in fuel exhaustion, loss of engine power, and a forced landing. Related factors were: the light conditions at dusk, and the lack of suitable terrain for a forced…Dec 22, 1997 · N9640J · Substantial damageNTSB ATL98LA029Accident · 1 fatalLimited investigationFinal reportLutz EAA Biplane P-2 · Wellington, FLfailure of the pilot to ensure the fuel selector was properly positioned to a tank with adequate fuel before takeoff, which resulted in fuel starvation and loss of engine power; failure of the pilot to accomplish the emergency procedure (restart the engine…Dec 22, 1997 · N913AM · Substantial damageNTSB ATL98LA028Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Eustis, FLfailure of the pilot to maintain directional control of the airplane during the landing roll, which resulted in a ground swerve and subsequent collision with a parked airplane. Related factors were: the pilot's lack of experience in tailwheel aircraft, the…Dec 22, 1997 · N83589 · Substantial damageNTSB ATL98LA027Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Monticello, FLthe pilot's inadequate preflight planning/preparation, and failure to ensure that the airplane would be able to clear trees during takeoff. Related factors were: the high/wet vegetation on the grass runway, and the proximity of trees to the runway.Dec 19, 1997 · N5789L · DestroyedNTSB ATL98FA025Accident · 2 fatalField investigationFinal reportCessna A150K · Jacksonville, FLthe pilot's failure to maintain adequate flying speed following a banner pick up, which resulted in a stall and an uncontrolled collision with the ground. A related factor was: the pilot allowed the maximum certificated gross weight of the airplane to be…Dec 17, 1997 · N1218M · Substantial damageNTSB ATL98LA021Accident · No injuriesLimited investigationFinal reportHughes TH-55 · Bushnell, FLThe pilot's failure to maintain clearance from the trees during a hover. A factor was the pilot's diverted attention.Dec 9, 1997 · N74914 · Substantial damageNTSB ATL98LA019Accident · 2 fatalLimited investigationFinal reportSiggi's Airplane Works D-4 Fascination · Leesburg, FLstructural failure of the right wing, during the initial climb after takeoff, which resulted in an uncontrolled descent to the ground.Dec 6, 1997 · DMSMV · DestroyedNTSB MIA98FA040Accident · 3 fatalField investigationFinal reportCommander 114B · Cross City, FLVFR flight by the noninstrument-rated pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft, due to spatial disorientation, which resulted in an uncontrolled descent and collision with the terrain (tree,…Nov 30, 1997 · N302RS · DestroyedNTSB ATL98LA016Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Summerland Key, FLthe pilot's inadequate compensation for the wind conditions and failure to flare the airplane for landing. The gusty crosswind was a related factor.Nov 26, 1997 · N201LY · Substantial damageNTSB ATL98LA022Accident · No injuriesLimited investigationFinal reportChristen Industries S-2B · Fort Lauderdale, FLThe undetermined malfunction of the right brake and the pilot's failure to maintain directional control during the landing rollout. A factor was the quartering tailwind.Nov 23, 1997 · N317JK · Substantial damageNTSB ATL98LA013Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Opa Locka, FLthe pilot's continued flight into adverse weather conditions, and failure to maintain clearance above the ground while attempting a VFR approach to an airport with low clouds. The low clouds (ceiling) and condition of light at dusk were related factors.Nov 22, 1997 · N45834 · Substantial damageNTSB MIA98IA035Incident · No injuriesIncident investigationFinal reportDouglas DC-8F-55 · Miami, FLThe inadequate overhaul of the No. 4 engine start valve resulting in the valve remaining open after engine start; and the subsequent free run state of the starter resulting in a starter overheat, disintegration and fire.Nov 20, 1997 · N55FB · Minor damageNTSB ATL98LA010Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Punta Gorda, FLThe flight instructor's improper short field takeoff procedure and his decision to abort the takeoff after rotation.Nov 20, 1997 · N93286 · Substantial damageNTSB MIA98LA034Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Palatka, FLthe student pilot's failure to properly secure the oilcap/dipstick within it's integral oil filler tube during his preflight inspection.Nov 18, 1997 · N68327 · Substantial damageNTSB MIA98LA030Accident · No injuriesLimited investigationFinal reportCessna 150M · Ormond Beach, FLa loss of engine power for undetermined reasons.Nov 13, 1997 · N6062K · Substantial damageNTSB MIA98LA029Accident · No injuriesLimited investigationFinal reportCessna 172P · Naples, FLLoss of engine power for undetermined reasons.Nov 8, 1997 · N97074 · Substantial damageNTSB MIA98LA032Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Clarksville, FLthe pilot's improper flare and touchdown.Nov 3, 1997 · N4502X · Substantial damageNTSB MIA98LA022Accident · No injuriesLimited investigationFinal reportCessna 172 · Crystal River, FLThe certified flight instructors improper supervision of the rated pilot during a crosswind landing resulting in an in-flight collision with the left wing of the airplane and the runway, subsequent loss of directional control on landing rollout, and collision…Nov 3, 1997 · N4105F · Substantial damageNTSB MIA98LA019Accident · No injuriesLimited investigationFinal reportCessna 402B · Fort Lauderdale, FLThe pilot's improper management of fuel resulting in a total loss of engine power on both engines due to fuel exhaustion.Nov 2, 1997 · N69312 · DestroyedNTSB MIA98LA018Accident · 1 fatalLimited investigationFinal reportSaldairiaga Buccaneer II · Clermont, FLfailure of the pilot to maintain adequate airspeed, while maneuvering at a low altitude, which resulted in an inadvertent stall and subsequent in-flight collision with terrain.Nov 1, 1997 · N813LJ · DestroyedNTSB MIA98LA017Accident · Serious injuriesLimited investigationFinal reportde Havilland DH-8-201 · Jacksonville, FLThe passengers failure to secure her seatbelt as directed by the flight crew (seatbelt sign illuminated) on initial takeoff climb resulting in her ejection from her seat during an encounter with turbulence.Nov 1, 1997 · N988HA · No damageNTSB MIA98LA014Accident · No injuriesLimited investigationFinal reportAerofab Lake LA-250 · Miami, FLloss of engine power for an undetermined reason(s), which resulted in a forced landing and subsequent encounter with rough water.Oct 29, 1997 · N85HG · Substantial damageNTSB ATL98FA008Accident · 3 fatalField investigationFinal reportCessna 402B · Tampa, FLThe pilot's failure to follow the landing checklist and extend the landing gear for landing, and his failure to maintain VMC during a go-around. Factors were: the pilot's diverted attention due to a non-stabilized instrument approach and his lack of recent…Oct 27, 1997 · N69293 · Substantial damageNTSB ATL98LA006Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Industries DA20-A1 · West Palm Beach, FLthe pilot's inadvertent use of the wrong runway, and his improper decision to continue the approach behind a large airplane (MD-80), which resulted in a wake turbulence encounter, loss of aircraft control, and collision with terrain.Oct 21, 1997 · N534SS · Substantial damageNTSB ATL98LA003Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Miami, FLexcessive wear to the number one valve stem and valve stem keepers that resulted in the separation of the valve assembly.Oct 19, 1997 · N7814U · Substantial damageNTSB MIA98LA013Accident · No injuriesLimited investigationFinal reportCessna 172G · Panacea, FLThe pilot's improper use of carburetor heat resulting in loss of engine power due to carburetor icing and an in flight collision with trees during a forced landing.Oct 17, 1997 · N4690L · Substantial damageNTSB MIA98LA012Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Pompano Beach, FLThe improper use of collective control by the dual student which prevented the flight instructor from stopping an uncontrolled roll to the left.Oct 17, 1997 · N333PH · Substantial damageNTSB MIA98IA006Incident · No injuriesIncident investigationFinal reportBeech 18 [C-45H] · Orlando, FLthe failure of the landing gear chain from the main landing gear torque shaft to the nose gear box coming off the sprocket, causing the landing gear to be out of sequence between the main gear and the nose gear.Oct 9, 1997 · N486JB · Minor damageNTSB MIA98LA005Accident · Minor injuriesLimited investigationFinal reportCessna P172D · Umatilla, FLThe improper fuel tank selector position by the pilot-in-command resulting in the total loss of engine power due to fuel starvation.Oct 4, 1997 · N8582X · Substantial damageNTSB MIA98LA002Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-82 · Cross City, FLThe in-flight encounter with turbulence associated with a nearby level 6 thunderstorm with moderate rain while deviating.Oct 2, 1997 · N33502 · No damageNTSB MIA98IA001Incident · No injuriesIncident investigationFinal reportGrumman G-73 · Fort Lauderdale, FLthe partial failure of a component of the hydraulic system resulting in the collapse of the nose landing gear during the landing roll.Oct 1, 1997 · N168WS · Minor damageNTSB ATL97LA144Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Belleview, FLthe pilot's improper in-flight planning/decision, and his delay in initiating a go-around, which resulted in a hard touchdown, loss of directional control, and collision with objects (fence and trees).Sep 28, 1997 · N3402Z · Substantial damageNTSB ATL97LA136Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Zellwood, FLfailure of mechanics to adequately torque the crankcase through-bolts following a top overhaul, which subsequently resulted in a crankshaft failure. Soft/uneven terrain in the emergency landing area was a related factor.Sep 22, 1997 · N53172 · Substantial damageNTSB MIA97LA250Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Miami, FLThe failure of the pilot to properly plan his descent and approach for a forced landing following partial loss of engine power resulting in the aircraft landing short of the intended landing runway. A factor in the accident was improper inspection of the…Sep 19, 1997 · N4315X · Substantial damageNTSB MIA97FA249Accident · 2 fatalField investigationFinal reportCessna 177RG · Sebring, FLcontinued flight by the pilot into adverse weather conditions, and his failure to maintain aircraft control, which resulted in an uncontrolled descent until impact in a lake. The adverse weather condition (thunderstorm) was a related factor.Sep 19, 1997 · N2562V · DestroyedNTSB MIA97TA246Accident · No injuriesFinal reportHughes 269A · Tarpon Springs, FLthe loss of engine power for undetermined reasons.Sep 17, 1997 · N6786M · Substantial damageNTSB MIA97LA253Accident · No injuriesLimited investigationFinal reportCessna 411 · Williston, FLthe pilot-in-command's excessive taxi speed.Sep 13, 1997 · N12WT · Substantial damageNTSB MIA97FA242Accident · 1 fatalField investigationFinal reportMooney M20F · Coral Springs, FLThe pilot's misjudging the distance vs. altitude resulting in the collision with the water short of the intended touchdown point of the rough field. Contributing to the accident was the total loss of engine power due to failure of the No. 3 cylinder…Sep 11, 1997 · N6417Q · Substantial damageNTSB ATL97LA127Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Clewiston, FLThe crack in the #8 cylinder head which led to the loss of power. A factor was the soft terrain.Aug 29, 1997 · N7307C · Substantial damageNTSB ATL97LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · West Palm Beach, FLthe flight instructor's (CFI's) inaccurate assessment of fuel available for the flight, and his improper in-flight planning/decision by continuing the training flight with minimal fuel, which resulted in fuel exhaustion and loss of engine power.Aug 26, 1997 · N6216Q · Substantial damageNTSB ATL97LA123Accident · 1 fatalLimited investigationFinal reportJurka P51D Mustang · Fort Pierce, FLloss of engine power for undetermined reason(s); and failure of the pilot to maintain adequate airspeed, while starting to maneuver for an emergency landing, which resulted in loss of aircraft control (stall) and collision with terrain.Aug 24, 1997 · N151MS · DestroyedNTSB MIA97LA238Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Kissimmee, FLa hard landing resulting in a wing contacting the runway. A factor in this accident was the nose landing gear would not extend due to the steering ball being off its track.Aug 21, 1997 · N55322 · Substantial damageNTSB MIA97IA237Incident · Minor injuriesIncident investigationFinal reportBoeing 737-300 · Tampa, FLin-flight collision with a bird.Aug 21, 1997 · N602SW · Minor damageNTSB ATL97LA122Accident · Minor injuriesLimited investigationFinal reportZenair 701 · Spruce Creek, FLThe failure of the engine for undetermined reasons, while maneuvering close to the ground. Factors included the soft terrain and the conditions favorable for carburetor icing.Aug 11, 1997 · N105RC · Substantial damageNTSB ATL97FA118Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Palm Bch Garden, FLloss of engine power for undetermined reasons and the pilot's failure to maintain flying speed.Aug 11, 1997 · N8213P · DestroyedNTSB ATL97FA115Accident · 2 fatalField investigationFinal reportMooney M20F · Tallahassee, FLfatigue failure of the crankshaft for undetermined reasons. Related factors were: darkness, and obstructions (trees) in the emergency landing area.Aug 11, 1997 · N3455X · DestroyedNTSB DCA97MA059Accident · 5 fatalClass 1 · MajorFinal reportDouglas DC-8-61 · Miami, FLThe airplane being misloaded to produce a more aft center of gravity and a correspondingly incorrect stabilizer trim setting that precipitated an extreme pitch-up at rotation, was (1) the failure of Fine Air to exercise operational control over the cargo…Aug 7, 1997 · N27UA · DestroyedNTSB MIA97LA230Accident · No injuriesLimited investigationFinal reportCessna R172E · Mary Esther, FLThe loss of engine power for undetermined reasons.Aug 6, 1997 · N2427 · Substantial damageNTSB MIA97LA224Accident · No injuriesLimited investigationFinal reportCessna 152 · Cape Coral, FLLoss of engine power for undetermined reasons resulting in a forced landing to unsuitable terrain.Aug 1, 1997 · N93011 · Destroyed