NTSB investigations

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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, newest first

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
  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 NYC98LA144Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1A · Madison, CTWas the failure of the pilot to maintain directional control of the airplane during an aborted landing. A factor was the winds which were variable and gusty.Jul 18, 1998 · N9418L · DestroyedNTSB MIA98WA203Accident · Serious injuriesForeign investigationCessna 172F · Grand Turk, United KingdomJul 18, 1998 · N5682R · No damageNTSB MIA98LA201Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Belzoni, MSThe malfunction in the engine blower section, resulting in oil starvation, the seizure of the engine.Jul 18, 1998 · N8488V · Substantial damageNTSB LAX98FA236Accident · 3 fatalField investigationFinal reportSikorsky CH-54A · Yucca Valley, CAAn in-flight main rotor blade spar separation as a result of the pilot-in-command's decision to continue to fly the aircraft after it had failed an AD directed BIM check. Factors were the failure of the operator's chief pilot to maintain proper supervision…Jul 18, 1998 · N64KL · DestroyedNTSB IAD98RA090Accident · 7 fatalForeign investigationBell UH-1H · Nueva Colonia, ColombiaJul 18, 1998 · N159NTSB IAD98LA081Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Dover, DEThe pilot's failure to attain the proper touchdown point.Jul 18, 1998 · N5907R · Substantial damageNTSB FTW98FA325Accident · 1 fatalField investigationFinal reportCommander 114TC · West Jordan, UTA brittle fracture of the clamp that joins the exhaust pipe to the turbocharger. The pipe separated and hot exhaust gases escaped into the engine compartment. The engine lost power due to the high heat vaporizing fuel in the fuel line. Factors were inadequate…Jul 18, 1998 · N61174 · DestroyedNTSB CHI98MA260Accident · 2 fatalMajor investigationFinal reportNorth American NA-265-80 · Florence, KSthe pilot's overconfidence in his personal ability, his improper in-flight decision to attempt aerobatics, and his loss of control of the airplane.Jul 18, 1998 · N547JL · DestroyedNTSB CHI98LA303Accident · Minor injuriesLimited investigationFinal reportCook Teenie TWO · Stevensville, MIThe pilot's inadequate preflight planning and preparation which resulted in fuel exhaustion and subsequent loss of engine power.Jul 18, 1998 · N40512 · Substantial damageNTSB CHI98LA263Accident · No injuriesLimited investigationFinal reportCessna 150H · Frankfort, INthe improper maintenance installation by other maintenance personnel. Factors were a missing lubricating oil drain plug, the safety wire for the plug and the roadway.Jul 18, 1998 · N22047 · Substantial damageNTSB CHI98LA262Accident · Serious injuriesLimited investigationFinal reportAeronca 11BC · Blue Springs, NEthe pilot's inadequate visual outlook to avoid impact with a wire. Factors were sunglare and the wire (static).Jul 18, 1998 · N9156E · Substantial damageNTSB CHI98LA259Accident · 1 fatalLimited investigationFinal reportAnderson T Craft Special · Pick City, NDThe pilot's failure to maintain sufficient altitude/clearance with terrain. A factor was the pilot's attempted low altitude acrobatic maneuver.Jul 18, 1998 · N91XX · DestroyedNTSB CHI98LA257Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Napoleon, MIthe pilot inadequate pre-flight planning. Factors in this accident were the airplane's weight and balance limitations had been exceeded by the pilot and an improper top overhaul of the engine's cylinder by the mechanic.Jul 18, 1998 · N54R · DestroyedNTSB ANC98LA102Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Kodiak, AKThe loss of engine power due to carburetor icing and the pilot's improper use of the carburetor heat control. A factor associated with the accident is the rough and uneven terrain at the forced landing area.Jul 18, 1998 · N8162C · Substantial damageNTSB ANC98LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Bethel, AKThe fracture of the flap handle position locking pin, which resulted in an uncommanded raising of the flaps during takeoff. A factor was the pilot's decision to takeoff with a suspected problem in the flap system.Jul 18, 1998 · N1793J · DestroyedNTSB ANC98LA100Accident · Minor injuriesLimited investigationFinal reportPiper PA-14 · Big Lake, AKThe pilot's inadequate preflight procedure of failing to ensure his seat was engaged, which resulted in the seat slipping aft during takeoff.Jul 18, 1998 · N5133H · Substantial damageNTSB SEA98LA140Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Caldwell, IDThe pilot-in-command's misjudgment of clearance with a power line, resulting in a collision with the line. Factors included a power line and dark night light conditions in the spray area.Jul 17, 1998 · N7951 · Substantial damageNTSB MIA98LA202Accident · No injuriesLimited investigationFinal reportAir Tractor 502 · Clewiston, FLThe pilot's failure to attain adequate airspeed. A tailwind was a contributing factor.Jul 17, 1998 · N9184R · Substantial damageNTSB MIA98LA199Accident · No injuriesLimited investigationFinal reportCessna 150M · Ormond Beach, FLThe student pilot's failure to maintain directional control.Jul 17, 1998 · N704FE · Substantial damageNTSB MIA98LA198Accident · Serious injuriesLimited investigationFinal reportVelocity Standard RG · Sebastian, FLA loss of power control due to a disconnected throttle linkage. Also causal was the inadequate maintenance by the owner/builder.Jul 17, 1998 · N96HV · Substantial damageNTSB MIA98FA200Accident · 1 fatalField investigationFinal reportPiper PA-31-310 · Miami, FLThe pilot's inadequate preflight inspection which led to fuel contamination and subsequent loss of engine power. Also causal was the pilot's failure to maintain single engine flying speed (VMC).Jul 17, 1998 · N7578L · DestroyedNTSB LAX98LA233Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400 · Tranquillity, CAThe pilot's failure to detect and avoid a set of wires during a night aerial application flight. Factors in the accident were the pilot's failure to perform an adequate preflight inspection of the field to determine obstruction locations and the dark night…Jul 17, 1998 · N2373V · Substantial damageNTSB LAX98FA235Accident · 2 fatalField investigationFinal reportPZL-Bielsko SZD 50-3 · California City, CAThe failure of the first and/or second pilot to obtain and maintain control of the aircraft after stalling and entering a spin.Jul 17, 1998 · N7215L · DestroyedNTSB FTW98LA323Accident · Serious injuriesLimited investigationFinal reportSchweizer SGU 2-22E · Canon City, COThe pilot's misjudgment of distance/altitude and his premature deployment of the spoilers, resulting in a undershoot and hard landing.Jul 17, 1998 · N9920J · Substantial damageNTSB FTW98LA315Accident · No injuriesLimited investigationFinal reportBell 47-GB31 · Olathe, COThe pilot's inadequate in-flight planning which resulted in an encounter with his own wake turbulence. Related factors were high density altitude and wake turbulence.Jul 17, 1998 · N92HA · Substantial damageNTSB FTW98LA313Accident · Serious injuriesLimited investigationFinal reportShoemaker S-12 Aeraile · Marion, ARThe non-certificated pilot's failure to maintain minimum required airspeed resulting in an inadvertent stall. A factor was the pilot's lack of total flight experience.Jul 17, 1998 · N82584 · Substantial damageNTSB CHI98LA310Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Leland, ILControl interference between the pilot-in-command and the student. An excessive descent rate and inadequate flare by the student during landing are contributing factors. The inadequate supervision by the pilot-in-command is an additional factor.Jul 17, 1998 · N75HM · Substantial damageNTSB CHI98LA261Accident · No injuriesLimited investigationFinal reportCessna 182A · Springbrook, WIThe pilot's improper attitude and excessive sink rate during landing. The terrain condition was a contributing factor in the accident.Jul 17, 1998 · N2139G · Substantial damageNTSB CHI98LA258Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Springfield, MOthe pilot in command's inadequate preflight planning/preparation and inaccurate fuel consumption calculations that caused the aircraft's fuel supply to be exceeded. Factors to the accident were the dark light condition and the rough/uneven terrain condition.Jul 17, 1998 · N2953Y · Substantial damageNTSB ATL98LA098Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Niceville, FLProper touchdown point not attained. Factors were a tailwind and wet grass.Jul 17, 1998 · N704YG · Substantial damageNTSB ANC98LA099Accident · Minor injuriesLimited investigationFinal reportCessna 207 · King Salmon, AKThe disconnection of the mixture control cable from the mixture control arm. Factors associated with this accident were the inadequate 100 hour inspections performed by company mechanics.Jul 17, 1998 · N1763U · Substantial damageNTSB SEA98LA138Accident · 2 fatalLimited investigationFinal reportRockwell S-2R · Burley, IDA failure of both pilots to see and avoid each other's aircraft due to inadequate visual lookout.Jul 16, 1998 · N5036X · 2 aircraft · Substantial damageNTSB MIA98WA212Incident · No injuriesForeign investigationDouglas DC-9-41 · Buenos Aires, ArgentinaJul 16, 1998 · LVYOA · Minor damageNTSB FTW98LA314Accident · No injuriesLimited investigationFinal reportCessna 172N · Broomfield, COThe pilot's improper landing flare which resulted in a hard landing.Jul 16, 1998 · N172AT · Substantial damageNTSB FTW98LA312Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Watkins, COThe pilot misjudged his altitude. Contributing to the accident were unfavorable wind and dark night conditions.Jul 16, 1998 · N444BP · Substantial damageNTSB CHI98LA256Accident · No injuriesLimited investigationFinal reportCessna 177 · Cassville, WIan undetermined event which resulted in engine failure on landing roll out during attempted restart fuel ignited and an undetermined event in the airplane's fuel system which resulted in a fire.Jul 16, 1998 · N3461T · DestroyedNTSB SEA98LA139Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M18B · Hingham, MTRestricted aileron travel for undetermined reasons.Jul 15, 1998 · N4326M · Substantial damageNTSB SEA98LA137Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Pacific City, ORThe pilot's improper compensation for wind conditions (landing with a tail wind.) Related factors were tail wind conditions, a short runway, and diminished brake system effectiveness.Jul 15, 1998 · N9199D · Substantial damageNTSB NYC98FAMS2Accident · 2 fatalMissing aircraftFinal reportNauer Lancair 4P · Atlantic Ocean (Atlantic Ocean)Undetermined.Jul 15, 1998 · N88PP · DestroyedNTSB MIA98LA197Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13H/M47A · Citronelle, ALThe pilot's failure to control the helicopter's altitude while overflying an area of rising terrain and trees.Jul 15, 1998 · N1001F · Substantial damageNTSB MIA98FA196Accident · 1 fatalField investigationFinal reportCessna 150E · Panama City Bch, FLThe failure of the pilot to maintain airspeed (Vs) and the inadvertent stall by the pilot. Contributing to the accident was the intentional operation of the airplane by the pilot in an over gross weight condition resulting in a higher stall speed, and failure…Jul 15, 1998 · N3549J · Substantial damageNTSB IAD98LA079Accident · No injuriesLimited investigationFinal reportBoeing A75N1 (PT17) · West Milford, NJLoss of engine power for undetermined reasons.Jul 15, 1998 · N60019 · Substantial damageNTSB FTW98FA310Accident · 1 fatalField investigationFinal reportAir Command International C-147A · Caddo Mills, TXThe pilot's failure to maintain rotor rpm while maneuvering, which resulted in the main rotor blades contacting the tail section of the gyroplane.Jul 15, 1998 · N147GY · DestroyedNTSB CHI98LA252Accident · Serious injuriesLimited investigationFinal reportPiper PA28-151 · Anthon, IAThe pilot-in-command's improper preflight planning, preparation and fuel management resulting in an unscheduled landing and impact with a pole.Jul 15, 1998 · N1473X · Substantial damageNTSB ANC98LA098Accident · No injuriesLimited investigationFinal reportCessna 185E · Mcgrath, AKThe loss of engine power for a undetermined reasons. A contributing factor was the trees.Jul 15, 1998 · N2750J · Substantial damageNTSB SEA98LA135Accident · No injuriesLimited investigationFinal reportCessna 152 · Miltonfreewater, ORThe pilots failure to maintain proper terrain clearance. Factors contributing to the accident are high density altitude and rising terrain.Jul 14, 1998 · N24823 · Substantial damageNTSB NYC98LA143Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BL-65 · Bedford, PAThe pilot's inadequate preflight inspection in which he failed to secure the oil filler cap, and his misjudgment of distance and altitude from the runway.Jul 14, 1998 · N27616 · Substantial damageNTSB LAX98LA232Accident · No injuriesLimited investigationFinal reportBeech A36TC · Boulder City, NVloss of engine power for undetermined reasons over unsuitable terrain.Jul 14, 1998 · N999AJ · DestroyedNTSB FTW98LA326Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS 4A · Salina, UTThe pilot's selection of unsuitable terrain to conduct a landing. Contributing was the loss of thermal lift and high vegetation.Jul 14, 1998 · N41MN · Substantial damageNTSB CHI98LA253Accident · Serious injuriesLimited investigationFinal reportCameron A105 · Howell, MIThe pilot's failure to visually recognize hazards associated with meteorological phenomenon. A contributing factor was the weather condtion.Jul 14, 1998 · N1601A · No damage