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 LAX93LA001Accident · No injuriesLimited investigationFinal reportCessna 170B · Prescott, AZFailure of the pilot to maintain directional control and improper use of the flight controls and brakes.Oct 2, 1992 · N2515D · Substantial damageNTSB FTW93LA004Accident · No injuriesLimited investigationFinal reportCessna 150F · Hughes, ARThe loss of control during the landing roll. A factor was the partial loss of engine power.Oct 2, 1992 · N8119F · Substantial damageNTSB FTW93FA002Accident · 1 fatalField investigationFinal reportClatanoff Rotorway Exec · Wimberley, TXThe delamination of the skin on a main rotor blade.Oct 2, 1992 · N41KC · DestroyedNTSB ATL93LA002Accident · No injuriesLimited investigationFinal reportBeech E-55 · Chattanooga, TNThe failure of an unknown person to follow proper procedures/directives by operating a radio-controlled model plane in airport traffic pattern airspace.Oct 2, 1992 · N10BS · Substantial damageNTSB ATL93LA001Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Aliceville, ALMaintenance personnel's failure to properly secure the fuel line from the fuel pump to the fuel injector during the engine installation, which resulted in a complete engine failure.Oct 2, 1992 · N8548P · Substantial damageNTSB ANC93LA004Accident · No injuriesLimited investigationFinal reportCessna 206U · Lime Village, AKPilot in command's poor preflight planning. A factor in the accident was the hazards on or near the gravel bar strip takeoff area.Oct 2, 1992 · N29245 · Substantial damageNTSB ANC93LA001Accident · No injuriesLimited investigationFinal reportChampion 7EC · Eureka, AKThe pilot-in command's inadequate preflight inspection which resulted in a power loss due to ice in the fuel system.Oct 2, 1992 · N4392C · Substantial damageNTSB SEA93LA005Accident · No injuriesLimited investigationFinal reportSchweizer SSG 2-33A · Heber City, UTThe proper alignment was not maintained by the pilot. A factor relating to the accident was the sign located beside the runway.Oct 1, 1992 · N2763H · Substantial damageNTSB SEA93LA001Accident · No injuriesLimited investigationFinal reportHughes 269C · Hillsboro, ORThe pilot in command's failure to maintain proper altitude during the hover. Factors contributing to the accident were the pilot in command's lack of total experience in rotorcraft and his diversion of attention while hovering.Oct 1, 1992 · N7400F · Substantial damageNTSB NYC93LA001Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Lincoln, PAThe pilot's premature liftoff and delay in aborting the takeoff.Oct 1, 1992 · N6374S · Substantial damageNTSB MIA93WA002Accident · No injuriesForeign investigationBoeing 727-200 · Martinique, FranceOct 1, 1992 · N726DH · Substantial damageNTSB MIA93LA001Accident · Serious injuriesLimited investigationFinal reportCessna 182H · Englewood, FLInadequate preflight of the airplane by the pilot in command which resulted in the total loss of engine power shortly after takeoff due to fuel contamination.Oct 1, 1992 · N2088X · Substantial damageNTSB LAX93T#A01Accident · No injuriesClass 3Final reportDouglas DC-7B · Kyburz, CAOct 1, 1992 · N848D · DestroyedNTSB FTW93LA001Accident · No injuriesLimited investigationFinal reportBeech D18S · Brookston, TXSmoke trailing from the left engine for an undetermined reason(s). Factors contributing to the accident were unsuitable terrain conditions.Oct 1, 1992 · N90460 · Substantial damageNTSB LAX92LA409Accident · Minor injuriesLimited investigationFinal reportCessna 310D · Minden, NVPilot's and mechanic's inadequate inspection of the aircraft and the pilot's poor inflight decision by not returning to the departure airport after experiencing the initial engine loss of power on takeoff. Contributing to this accident was fuel starvation due…Sep 30, 1992 · N6755T · Substantial damageNTSB LAX92FA410Accident · 2 fatalField investigationFinal reportRobinson R22-B · Martinez, CAAn undetermined divergence of the main rotor from its normal plane of rotation which resulted in rotor contact to the fuselage and passenger.Sep 30, 1992 · N8069X · DestroyedNTSB FTW92LA235Accident · No injuriesLimited investigationFinal reportErcoupe 415-G · Gallup, NMThe instructor pilot's lack of familiarity with the performance capability of the aircraft. Factors were the rising terrain and high density altitude.Sep 30, 1992 · N94424 · Substantial damageNTSB FTW92LA234Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Roswell, NMThe pilot failed to maintain the correct airspeed on final approach and allowed the aircraft to stall.Sep 30, 1992 · N2372V · Substantial damageNTSB ANC92LA182Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Taylor Road, AKThe pilot's inadequate compensation for wind conditions. Factors contributing to the accident were the gusting crosswinds and the pilot's lack of total experience in this type operation.Sep 30, 1992 · N79046 · Substantial damageNTSB SEA92LA218Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Troutdale, ORSeparation of the number 3 cylinder exhaust valve head and overloading of the nose gear strut. A factor contributing to the accident was the uneven terrain.Sep 29, 1992 · N8274C · Substantial damageNTSB NYC92WA186Accident · 4 fatalForeign investigationMcdonnell Douglas 500E · Niagara Falls, CanadaSep 29, 1992 · N588DB · 2 aircraft · DestroyedNTSB LAX92T#A17Accident · No injuriesFinal reportMBB BO-105 · Peach Springs, AZSep 29, 1992 · N617 · Substantial damageNTSB CHI92LA295Accident · Serious injuriesLimited investigationFinal reportFunk, D.D. B85C · Buffalo, MNThe contamination of the carburetor, inadequate maintenance inspection by maintenance personnel, and the inadequate maintenance servicing by the pilot/owner.Sep 29, 1992 · N1609N · Substantial damageNTSB CHI92LA294Accident · No injuriesLimited investigationFinal reportSocata TB-9 · Grand Forks, NDThe pilot's premature flare.Sep 29, 1992 · N150ND · Substantial damageNTSB ATL92LA186Accident · No injuriesLimited investigationFinal reportCessna 150M · Nashville, TNThe student pilot's inadequate inflight planning, which resulted in fuel exhaustion. A factor was his geographical disorientation.Sep 29, 1992 · N7764U · Substantial damageNTSB ANC92LA181Accident · No injuriesLimited investigationFinal reportCessna 185 · Petersburg, AKThe pilots inadequate compensation for wind during initial climb. A factor relating to accident was the gusty wind condition.Sep 29, 1992 · N4891Q · DestroyedNTSB SEA92LA215Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Helena, MTFuel exhaustion, the pilot in command's failure to refuel en route and the inability of the pilot in command to avoid the fence during the landing roll. Factors contributing to the accident were dark night conditions and the fence.Sep 27, 1992 · N1911U · Substantial damageNTSB LAX92LA406Accident · No injuriesLimited investigationFinal reportCessna 150B · Show Low, AZFuel exhaustion due to the pilot's inadequate preflight inspection of the aircraft and his failure to refuel the aircraft prior to departure.Sep 27, 1992 · N1104Y · Substantial damageNTSB DEN92LA094Accident · No injuriesLimited investigationFinal reportCessna 172N · Fort Collins, COThe pilot's failure to maintain directional control of the airplane. A factor was: crosswind.Sep 27, 1992 · N5222D · Substantial damageNTSB CHI92LA296Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Plattsmouth, NEThe pilot-in-command's failure to adequately compensate for wind conditions, and his not maintaining directional control.Sep 27, 1992 · N1270C · Substantial damageNTSB CHI92LA293Accident · Serious injuriesLimited investigationFinal reportCameron O-77 · North Omaha, NEThe pilot's abrupt touchdown during a balloon landing. A related factor is the unsuitable terrain selected.Sep 27, 1992 · N9539G · No damageNTSB CHI92LA292Accident · No injuriesLimited investigationFinal reportCessna 152 · Cape Girardeau, MOThe pilot's failure to recover from the bounced landing.Sep 27, 1992 · N69225 · Substantial damageNTSB BFO92LA154Accident · No injuriesLimited investigationFinal reportCessna 305A · Waynesville, OHThe chaffing of a landing gear brake line which caused the loss of hydraulic fluid and subsequent loss of braking action.Sep 27, 1992 · N5074Y · Substantial damageNTSB SEA92LA216Accident · No injuriesLimited investigationFinal reportCessna 182L · Vancouver, WAThe partial loss of engine power from failure of the no 5 piston, and the soft terrain at the forced ldg site, resulting in collapse of the nose landing gear.Sep 26, 1992 · N42324 · Substantial damageNTSB MIA92LA191Accident · Serious injuriesLimited investigationFinal reportLet L-13 · New Smyrna Bch, FLThe pilot's inadequate compensation for wind conditions. The downdraft was a factor in the accident.Sep 26, 1992 · N90861 · Substantial damageNTSB LAX92LA408Accident · 2 fatalLimited investigationFinal reportAir Command · Eureka, CAThe failure of the unqualified non certificated pilot to maintain control of the gyrocopter. A factor in the accident was the pilot's lack of total experience.Sep 26, 1992 · UNREG · Substantial damageNTSB LAX92LA404Accident · 1 fatalLimited investigationFinal reportLanceair 235 · Hollister, CAThe pilot performing the final segment of a visual approach at too low of an altitude resulting in an inflight collision with a guy wire.Sep 26, 1992 · N25EH · DestroyedNTSB LAX92LA403Accident · No injuriesLimited investigationFinal reportGolightly, Robert B. RV4 · Rialto, CAFuel starvation due to the pilot's improper management of the fuel system, and his failure to perform the emergency procedure of repositioning the fuel selector to a tank containing fuel.Sep 26, 1992 · N321RG · Substantial damageNTSB LAX92LA401Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Coachella, CAThe pilot's inadequate visual lookout and his failure to maintain an adequate clearance from the wires.Sep 26, 1992 · N57BA · Substantial damageNTSB LAX92LA400Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20 · Middletown, CAThe pilot's failure to connect the elevator control during assembly and failure to perform an adequate aircraft preflight check. Contributing to the accident was the pilots distraction by performing other tasks during the assembly procedure.Sep 26, 1992 · N789E · DestroyedNTSB FTW92FA232Accident · 1 fatalField investigationFinal reportCessna 310R · Idabel, OKThe pilot's descent below the minimum descent altitude. Factors were the pilot's improper IFR procedure, low ceiling, and dark night conditions.Sep 26, 1992 · N616CA · DestroyedNTSB FTW92DRG01Accident · 1 fatalFinal reportStits Playboy · Fredericksburg, TXThe inadvertent stall.Sep 26, 1992 · N5579V · DestroyedNTSB DEN92LA096Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Craig, COThe pilot's failure to maintain directional control.Sep 26, 1992 · N7181W · Substantial damageNTSB BFO92LA150Accident · 2 fatalLimited investigationFinal reportPiper PA-28-160 · Bethel, METhe pilot's failure to maintain adequate altitude to avoid the terrain. The dark night was a factor.Sep 26, 1992 · N5867W · DestroyedNTSB BFO92LA149Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Glenville, WVThe pilot failed to follow the takeoff procedure which to led to a partial loss of power during takeoff. Contributing to the accident was the trees.Sep 26, 1992 · N45657 · DestroyedNTSB BFO92LA148Accident · No injuriesLimited investigationFinal reportMooney M20E · Stow, MAFailure of the pilot to attain proper runway alignment during landing. Factors related to the accident were darkness, a lack of runway lighting on the left side of the runway, and the pilot's lack of visual ques.Sep 26, 1992 · N1338W · Substantial damageNTSB SEA92LA217Accident · No injuriesLimited investigationFinal reportCessna 140 · Moab, UTThe loss of engine power due to fuel exhaustion resulting from inaccurate fuel consumption calculations by the pilot. A factor relating to the accident was the terrain condition (ditch) in the landing area.Sep 25, 1992 · N2553N · Substantial damageNTSB LAX92LA402Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Gasquet, CAThe pilot failed to receive available wind information and selected the wrong landing runway. A contributing factor related to his expecting the local wind to be coming from the same direction as it had been reported at a neighboring airport.Sep 25, 1992 · N3410M · Substantial damageNTSB FTW92LA233Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Santa Fe, NMPilot's failure to compensate for the crosswind. A factor was the crosswind.Sep 25, 1992 · N759NN · Substantial damageNTSB CHI92LA291Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Lansing, MIThe pilot's inadequate planning and decision-making.Sep 25, 1992 · N5122S · Substantial damage