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 BFO94LA111Accident · Minor injuriesLimited investigationFinal reportClassic Waco YMF5 · Put-In-Bay, OHThe total loss of engine power for undetermined reasons. The lack of suitable terrain for a forced landing was a factor.Jun 19, 1994 · N5YM · Substantial damageNTSB ATL94LA124Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Blowing Rock, NCThe pilot's selection of unsuitable terrain (remote, wooded, mountainous) for an intentional crash landing.Jun 19, 1994 · N63872 · DestroyedNTSB ATL94LA123Accident · 1 fatalLimited investigationFinal reportMarvin E. Eubanks VP-1 · New Bern, NCThe loss of engine power for unknown reasons, and the failure of the pilot to maintain control of the aircraft during the emergency landing.Jun 19, 1994 · N5163R · DestroyedNTSB ATL94LA122Accident · 1 fatalLimited investigationFinal reportStephen Akro · Advance, NCThe pilot's failure to maintain airspeed.Jun 19, 1994 · N69TA · DestroyedNTSB LAX94LA259Accident · Serious injuriesLimited investigationFinal reportMascari Discovery S-12 · Salinas, CAThe failure of the muffler assembly due to preexisting cracking in the oxidized area of the weld, with subsequent damage and separation of the propeller and reduction gear box. A related factor was the excessive taxispeed which resulted in the airplane…Jun 18, 1994 · N999 · DestroyedNTSB LAX94LA258Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Apple Valley, CAthe pilot's failure to maintain an adequate airspeed in the takeoff initial climb and the resultant inadvertent entry into a stall/mush condition. High density altitude and downdraft conditions were factors in the accident.Jun 18, 1994 · N4553R · Substantial damageNTSB DCA94MA061Accident · 12 fatalClass 1 · MajorFinal reportLearjet 25D · Chantilly, VAThe poor decisionmaking, poor airmanship, and relative inexperience of the captain in initiating and continuing an unstabilized instrument approach that led to a descent below the authorized altitude without visual contact with the runway environment.…Jun 18, 1994 · XABBA · DestroyedNTSB BFO94LA115Accident · No injuriesLimited investigationFinal reportTaylorcraft F19 · Orrington, METhe pilot misjudged his altitude and airspeed which resulted in a hard landing. Related factors were the soft, and upslope field.Jun 18, 1994 · N2000U · Substantial damageNTSB BFO94LA107Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Forest Hill, MDThe loss of engine power during for undetermined reasons.Jun 18, 1994 · N7825P · Substantial damageNTSB BFO94LA106Accident · No injuriesLimited investigationFinal reportMooney M20C · Leesburg, VAThe pilot's failure to maintain the minimum descent altitude until the published approach fix. Factors related to the accident was pilot fatigue, low ceilings, obscuration, and fog.Jun 18, 1994 · N6679U · Substantial damageNTSB BFO94FA108Accident · 1 fatalField investigationFinal reportCessna 152 · Mohawk, NYThe pilot's failure to maintain adequate airspeed. A factor is the pilot's overconfidence in his ability.Jun 18, 1994 · N4833B · DestroyedNTSB BFO94FA104Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Warren Grove, NJThe pilot disregarded weather evaluations, attempted VFR flight into IMC and failed to maintain altitude and clearance from the terrain.Jun 18, 1994 · N62701 · DestroyedNTSB SEA94LA150Accident · Serious injuriesLimited investigationFinal reportSchell RV-6A · Crowheart, WYThe pilot in command's failure to maintain adequate altitude. A factor was downdraft conditions.Jun 17, 1994 · N48TS · DestroyedNTSB FTW94LA201Accident · Minor injuriesLimited investigationFinal reportGamble BD-4 · Leadville, COThe pilot's failure to maintain directional control. Factors were an unreliable airspeed indicator and excessive landing approach airspeed.Jun 17, 1994 · N76DG · Substantial damageNTSB FTW94IA198Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-72-212 · Caddo, OKThe fuel nozzle drain leak due to a defective o-ring.Jun 17, 1994 · N632AS · Minor damageNTSB CHI94LA206Accident · No injuriesLimited investigationFinal reportPiper PA-28 · St. Joseph, MOthe loss of engine power due to the failure of the number two cylinder.Jun 17, 1994 · N5025S · Substantial damageNTSB CHI94LA205Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Lambertville, MIThe inadequate maintenance of the airplane resulting in a foreign object in the induction system.Jun 17, 1994 · N737YW · Substantial damageNTSB CHI94LA204Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30 · Tomahawk, WIThe loss of engine power due to an undetermined reason. Factors in the accident were the lack of suitable terrain in preventing the pilot from making a safe forced landing.Jun 17, 1994 · N8218R · DestroyedNTSB CHI94LA201Accident · Serious injuriesLimited investigationFinal reportAeronca 15AC · Napoleon, MIa loss of engine power for unknown reasons. A factor related tot he accident were the trees encountered.Jun 17, 1994 · N5114Y · Substantial damageNTSB BFO94LA105Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Elizabethtown, KYThe pilot's failure to maintain directional control. A factor related to the accident was: the helicopter was outside the height-velocity envelope (for a successful autorotation), when loss of directional control occurred.Jun 17, 1994 · N2346J · Substantial damageNTSB BFO94LA102Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Oxford, CTThe pilot's inadvertent encounter with fog during landing.Jun 17, 1994 · N4093U · Substantial damageNTSB BFO94LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250B · Kent, OHThe pilot's failure to maintain directional control.Jun 17, 1994 · N5257Y · Substantial damageNTSB BFO94FA103Accident · 3 fatalField investigationFinal reportBeech A-36 · Brainerd, MNThe pilot's failure to follow the published missed approach procedure, and his failure to obtain and/or maintain adequate altitude to avoid collision with the terrain. Factors in the accident were: the pilot's lack of instrument flying experience, and the…Jun 17, 1994 · N1525G · DestroyedNTSB ATL94FA121Accident · 1 fatalField investigationFinal reportGrumman American AA-5B · Youngstown, FLSpatial disorientation experienced by the pilot, which resulted in his failure to maintain aircraft control. Factors were the conditions conducive to spatial disorientation (dark night lighting conditions, high cloud cover, thunderstorms), and the pilot's…Jun 17, 1994 · N74693 · DestroyedNTSB FTW94LA200Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Pioneer, LAFuel exhaustion due to the pilot's failure to refuel. A factor was a lack of suitable terrain for the forced landing.Jun 16, 1994 · N10112 · Substantial damageNTSB FTW94LA199Accident · No injuriesLimited investigationFinal reportCessna T210N · Santa Teresa, NMA power loss due to engine driven fuel pump failure. A factor was the lack of suitable terrain for a forced landing.Jun 16, 1994 · N199CH · Substantial damageNTSB LAX94LA254Accident · 1 fatalLimited investigationFinal reportSchweizer G-164B · Live Oak, CAFailure of the pilot to remain clear of power lines. A factor related to the accident was: the pilot's impairment due to use of drugs that were not approved for use while flying.Jun 15, 1994 · N8392K · DestroyedNTSB LAX94FA257Accident · 2 fatalField investigationFinal reportCessna 421C · Carlsbad, CAA loss of engine power for undetermined reasons. The pilot's failure to raise the flaps and maintain altitude were factors in the accident.Jun 15, 1994 · N421AG · DestroyedNTSB LAX94FA256Accident · 2 fatalField investigationFinal reportFouga CM 170 · Long Beach, CAA loss of power to both engines due to fuel contamination and, the pilot-in-command's failure to maintain an adequate airspeed during the subsequent emergency, which resulted in an inadvertent stall. Factors in the accident were: 1) the manufacturer's…Jun 15, 1994 · N344FM · DestroyedNTSB CHI94LA200Accident · No injuriesLimited investigationFinal reportCessna 152 · Springfield, MOThe pilot's failure to refuel prior to fuel exhaustion. The lack of suitable terrain available for the forced landing is a related factor.Jun 15, 1994 · N69227 · Substantial damageNTSB CHI94FA202Accident · 2 fatalField investigationFinal reportBell 47G2 · Baldwin, ILThe inadequate maintenance (inspection of aircraft) by maintenance personnel, which resulted in a loss of engine power due to fuel exhaustion. Related factors are the unsafetied fuel filter, and low altitude at which the helicopter operated.Jun 15, 1994 · N4992G · DestroyedNTSB BFO94LA100Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Raynham, MAFailure of the number four cylinder piston rings.Jun 15, 1994 · N8029Z · Substantial damageNTSB SEA94LA149Accident · Minor injuriesLimited investigationFinal reportHiller-Soloy UH-12L4 · Clarkston, WADisconnection of the ballast bar aft retaining pin. Factor(s) were: tail rotor blade separation and reduced aircraft control.Jun 14, 1994 · N67264 · Substantial damageNTSB FTW94LA195Accident · 1 fatalLimited investigationFinal reportGrumman G-164D · Gilbert, LAThe inadvertent stall while performing aerobatic maneuvers at an inadequate altitude.Jun 14, 1994 · N164MC · DestroyedNTSB BFO94LA099Accident · 2 fatalLimited investigationFinal reportUpton Mustang II · Churchtown, OHThe pilot's performance of a maneuver that exceeded the design stress limits of the airplane.Jun 14, 1994 · N49YP · DestroyedNTSB MIA94WA219Accident · No injuriesForeign investigationCessna 401A · Congotown, Congo - KinshasaJun 13, 1994 · N60EM · Substantial damageNTSB MIA94LA160Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140D · Pine Island, FLThe pilot-in-command's failure to obtain takeoff performance data pertinent to the present conditions, his attempted excessive climb rate for conditions, and his failure to maintain airspeed while in a climb after takeoff. This resulted in the inadvertent…Jun 13, 1994 · N888HA · Substantial damageNTSB FTW94LA194Accident · No injuriesLimited investigationFinal reportCessna 177 · Watonga, OKWas the pilot's failure to maintain the proper glidepath, his failure to compensate for existing wind conditions, and his failure to maintain clearance with the fence. A factor was the weather.Jun 13, 1994 · N2867X · Substantial damageNTSB CHI94LA198Accident · No injuriesLimited investigationFinal reportBeech 18 · Belleville, MIthe failure of the fuel line on the unique STC'd engine installation. A related factor is the improper installation of a fuel line by company maintenance personnel.Jun 13, 1994 · N231LJ · Substantial damageNTSB ANC94LA069Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilot's excessive use of the wheel brakes.Jun 13, 1994 · N7690H · Substantial damageNTSB SEA94LA146Accident · No injuriesLimited investigationFinal reportCessna 170A · Wolf Creek, MTPoor in flight planning. The mountainous terrain was a factor.Jun 12, 1994 · N1389D · Substantial damageNTSB MIA94LA159Accident · 1 fatalLimited investigationFinal reportHruby Cayuse · Bay St. Louis, MSThe pilot-in-command's attempt to continue the takeoff when the engine was not producing full power and his attempt to reverse course to return to the airport without sufficient altitude to complete the turn.Jun 12, 1994 · N12057 · DestroyedNTSB LAX94LA253Accident · No injuriesLimited investigationFinal reportSchumacher Swearingen SX-300 · Kingman, AZthe pilot's inadvertent raising the flaps during a go-around attempt. A factor in the accident was the gusty crosswind condition.Jun 12, 1994 · N2H · Substantial damageNTSB LAX94LA252Accident · Minor injuriesLimited investigationFinal reportTwibell Richard Dale Tiny TWO · Hesperia, CAA loss of engine power for undetermined reasons.Jun 12, 1994 · N52535 · Substantial damageNTSB CHI94LA197Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Millstadt, ILthe pilot's inadequate aircraft preflight inspection and failure to refuel the airplane prior to fuel exhaustion. Related factors are the loose fuel cap (siphoning) and the uneven terrain encountered during the forced landing.Jun 12, 1994 · N94752 · Substantial damageNTSB CHI94DET01Accident · Minor injuriesFinal reportArthur Alan Blind FOX III Speedster · Watervliet, MIa total loss of engine power due to carburetor icing.Jun 12, 1994 · N61AB · Substantial damageNTSB BFO94LA098Accident · Minor injuriesLimited investigationFinal reportBellah Rotorway Executive · Johnson City, NYThe failure of the tail rotor drive belt due to undetermined reasons. This led to a loss of directional control and an autorotation.Jun 12, 1994 · N727TB · Substantial damageNTSB BFO94LA097Accident · 1 fatalLimited investigationFinal reportFalen Commander 503 · Georgetown, OHThe gyroplane's uncontrolled descent into terrain due to undetermined reasons.Jun 12, 1994 · UNREG · DestroyedNTSB ATL94LA120Accident · No injuriesLimited investigationFinal reportBeech P35 · Bluffton, SCA loss of engine power due to oil starvation. This resulted from an undertorqued condition of the oil filter adapter, and the subsequent fretting of the adapter threads.Jun 12, 1994 · N982Q · Substantial damageNTSB MIA94LA158Accident · No injuriesLimited investigationFinal reportCessna 152 · Gainesville, FLThe pilot's improper flare and improper recovery from a bounced landing. .Jun 11, 1994 · N46140 · Substantial damage