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 NYC99FA169Accident · Minor injuriesField investigationFinal reportBell 206L-3 · Woodbridge, NJThe pilot's improper takeoff procedure, which resulted in a loss of tailrotor effectiveness.Jul 6, 1999 · N4NJ · Substantial damageNTSB LAX99LA234Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · San Luis Obispo, CAA loss of engine power due to contamination of the induction system and the carburetor throat. Factors in the accident were a prior undetected carburetor fire, which caused a deterioration in the air duct material.Jul 6, 1999 · N3477Q · Substantial damageNTSB FTW99LA182Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Iowa, LAThe pilot's failure to maintain clearance with the crops being sprayed. A factor was the pilot's diverted attention.Jul 6, 1999 · N6703Q · Substantial damageNTSB FTW99LA180Accident · Minor injuriesLimited investigationFinal reportBellanca BL17-30A · Brownfield, TXThe pilot's inadvertent stall while attempting to clear powerlines. Factors were the loss of engine power due to fuel starvation and the pilot's improper use of the fuel tank selector.Jul 6, 1999 · N9520E · Substantial damageNTSB DEN99FA114Accident · 2 fatalField investigationFinal reportCessna 182J · La Veta, COThe pilot's inadvertent flight into instrument meteorological conditions and his failure to maintain control of the aircraft. Factors were low ceiling and the pilot's lack of instrument experience.Jul 6, 1999 · N3334F · DestroyedNTSB CHI99LA226Accident · No injuriesLimited investigationFinal reportCessna 177RG · Weldon Springs, MOthe loss of engine oil for undetermined reasons. A factor was the trees.Jul 6, 1999 · N1937Q · Substantial damageNTSB CHI99LA216Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Fisher, MNthe pilot's failure to maintain clearance from the crop during an aerial application spray run.Jul 6, 1999 · N8029K · Substantial damageNTSB CHI99LA214Accident · No injuriesLimited investigationFinal reportWeatherly 620B · Timber Lake, SDthe pilots selection of the shorter runway and his failure to abort the takeoff. Factors to the accident were the high density altitude, the fence and the fence posts.Jul 6, 1999 · N350WR · Substantial damageNTSB CHI99LA211Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Addison, ILThe pilot's improper fuel selector positioning resulting in fuel starvation during cruise.Jul 6, 1999 · N739ND · Substantial damageNTSB ANC99LA085Accident · No injuriesLimited investigationFinal reportCessna 177RG · Fairbanks, AKThe pilot's failure to extend the airplane landing gear. A factor in the accident was an interference with the pilot's habit pattern.Jul 6, 1999 · N45367 · Substantial damageNTSB SEA99IA106Incident · No injuriesIncident investigationFinal reportJohn Hubbard Glasair II S · Florence, ORAircraft control was not maintained. Inadequate compensation for wind conditions and gusts were factors.Jul 5, 1999 · N322S · Minor damageNTSB NYC99LA166Accident · No injuriesLimited investigationFinal reportCessna 140 · Beckley, WVThe pilot's loss of aircraft control during the landing roll, which resulted in an inadvertent ground loop.Jul 5, 1999 · N72992 · Substantial damageNTSB NYC99LA165Accident · 2 fatalLimited investigationFinal reportLakeland Ultralites Kolb Mark III · Clark, PAThe pilot's improper decision to perform an aerobatic maneuver with inadequate altitude for recovery/clearance.Jul 5, 1999 · N901JL · DestroyedNTSB NYC99LA158Accident · No injuriesLimited investigationFinal reportBoeing Stearman E75 · Marston Mills, MAThe inadvertent control interference of the airplane's brakes by the passenger. A factor related to the accident was the pilot in commands insufficient passenger briefing.Jul 5, 1999 · N1658M · Substantial damageNTSB LAX99LA243Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Quincy, CAthe pilot's failure to attain and maintain an adequate airspeed for the existing wind conditions, and, his failure to abort the takeoff when it became apparent that the aircraft performance was not as anticipated. Factors in the accident were the tailwind and…Jul 5, 1999 · N2175Q · Substantial damageNTSB DEN99FA113Accident · 2 fatalField investigationFinal reportPitts S-2B · Steamboat Sprgs, COIntentional aerobatics performed by the pilot at an altitude insufficient to make a safe recovery.Jul 5, 1999 · N321MB · DestroyedNTSB CHI99LA212Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Lyons, KSThe pilot's inadequate fuel management leading to fuel exhaustion.Jul 5, 1999 · N45078 · Substantial damageNTSB CHI99LA209Accident · No injuriesLimited investigationFinal reportCessna 180A · White Bear Lake, MNthe pilot's inability to get the airplane to climb for undetermined reason, and the pilot landing the floatplane on the lake with the wheels extended. Factors contributing to this accident were the pilot's failure to perform a before landing checklist,…Jul 5, 1999 · N9780B · Substantial damageNTSB ANC99LA087Accident · Minor injuriesLimited investigationFinal reportTaylorcraft F-19 · Anchorage, AKThe pilot's diverted attention in the cockpit, and his failure to maintain control of the airplane.Jul 5, 1999 · N3676T · Substantial damageNTSB LAX99FA242Accident · 1 fatalField investigationFinal reportBeech 58 · Hilo, HIThe pilot's improper fuel system modifications resulting in inadequate fuel flow to the left engine during a critical phase of flight. Factors in the accident were the operation at an over gross weight condition with a CG more than 2 inches aft of the rear…Jul 4, 1999 · N971GA · DestroyedNTSB FTW99LA181Accident · Minor injuriesLimited investigationFinal reportPitts Special S-1C · Temple, TXThe loss of engine power due to fuel starvation, as a result of fuel moving away from the fuel supply outlets during maneuvering with a low fuel level, and the pilot's failure to maintain clearance with the power lines during the ensuing forced landing.Jul 4, 1999 · N69CS · Substantial damageNTSB CHI99LA225Accident · No injuriesLimited investigationFinal reportMooney M20J · Harbor Springs, MIthe pilot's inadequate compensation for the wind conditions and his failure to maintain clearance with the trees. Factors associated with the accident were the gusty winds, wind shear, and the trees.Jul 4, 1999 · N201HG · Substantial damageNTSB CHI99LA217Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Dongola, ILthe failure of the pilot to maintain a proper glidepath on the landing approach, and the failure of the pilot to select a proper touchdown point. Factors to the accident were the lack of runway lights, the dusk light condition, and the ditch.Jul 4, 1999 · N1996T · Substantial damageNTSB CHI99LA210Accident · No injuriesLimited investigationFinal reportErcoupe 415-CD · Jacksonville, ILA material defect in the sloshing compound. Factors were the blocked fuel system, inspection not identifying material defect, and the crop field.Jul 4, 1999 · N127G · Substantial damageNTSB CHI99FA213Accident · 1 fatalField investigationFinal reportLarson Smith Miniplane DSA-1 · Blackduck, MNAircraft control not being maintained by the pilot. Factors to the accident were the aerobatic maneuvers being flown by the pilot and the encountered spiral.Jul 4, 1999 · N535Y · Substantial damageNTSB ATL99LA104Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Chuckey, TNThe loss of engine power for undetermined reasons.Jul 4, 1999 · N9361J · Substantial damageNTSB ATL99LA103Accident · Serious injuriesLimited investigationFinal reportAdams A55S · Woodstock, GAA loose connection between the fuel line fitting and the burner assembly which resulted in a fire.Jul 4, 1999 · N9808S · DestroyedNTSB ANC99LA089Accident · No injuriesLimited investigationFinal reportCessna 140 · Sitka, AKThe pilot's inadequate compensation for crosswind conditions. Factors in the accident were a crosswind, and the pilot's lack of total experience in the type of airplane.Jul 4, 1999 · N3579V · Substantial damageNTSB ANC99LA086Accident · No injuriesLimited investigationFinal reportCessna 150F · Fairbanks, AKThe pilot's inadequate compensation for a crosswind. Factors in the accident were a crosswind, and an inadvertent ground loop.Jul 4, 1999 · N7911F · Substantial damageNTSB SEA99LA101Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Auburn, WATotal mechanical failure of the hydraulic tappet. A factor was an overdue major overhaul per manufacturer's recommendations.Jul 3, 1999 · N531PC · Substantial damageNTSB SEA99LA100Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Garden Valley, IDLoss of engine power due to fuel exhaustion because the pilot failed to refuel the airplane. A ditch in the landing area was a contributing factor in the accident.Jul 3, 1999 · N3528Y · Substantial damageNTSB NYC99LA164Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · New Castle, VAThe pilot tookoff with the fuel tank selector in an improper position (OFF), resulting in fuel starvation.Jul 3, 1999 · N4494Z · Substantial damageNTSB LAX99LA245Accident · No injuriesLimited investigationFinal reportHughes 369D · Oakdale, CAThe disintegration and failure of the oil pump drive spur gear aft bearing, which resulted in failure of the oil pump and subsequent oil starvation to the engine's turbine module. A factor in the accident was the failure of company maintenance personnel to…Jul 3, 1999 · N8661F · Substantial damageNTSB LAX99LA244Accident · No injuriesLimited investigationFinal reportCessna 180 · North Las Vegas, NVThe pilot's failure to adequately compensate for the existing crosswind condition and maintain directional control of the aircraft.Jul 3, 1999 · N180HW · Substantial damageNTSB FTW99LA179Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Theriot, LAThe pilot's inadequate preflight inspection which led to a contaminated fuel supply and subsequent loss of engine power. A factor was the lack of suitable terrain available for the forced landing.Jul 3, 1999 · N8360T · Substantial damageNTSB DEN99LA112Accident · No injuriesLimited investigationFinal reportMooney M20C · Big Piney, WYThe pilot's failure to maintain directional control of the aircraft during landing touchdown. A related factor was the gusty crosswind.Jul 3, 1999 · N6253U · Substantial damageNTSB DEN99FA119Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Coaldale, COThe pilot's failure to maintain control of the airplane for reasons for reasons undetermined.Jul 3, 1999 · N4753A · DestroyedNTSB CHI99LA215Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Page, NDthe pilot's failure to compensate for the wind conditions. Factors were the sudden windshift and the crops.Jul 3, 1999 · N6633K · Substantial damageNTSB NYC99LA151Accident · No injuriesLimited investigationFinal reportLearjet 60 · Hyannis, MAThe flightcrew's inadequate coordination and their failure to utilize checklists. Also causal was the captain's improper decision to continue the approach to a runway with insufficient length. A factor in the accident was the improper maintenance.Jul 2, 1999 · N219FX · Substantial damageNTSB LAX99LA240Accident · Minor injuriesLimited investigationFinal reportCessna 421B · Polacca, AZThe pilot's inadequate preflight inspection, which failed to determine the fuel supply in each fuel tank, and his mismanagement of the fuel supply, which resulted in fuel starvation.Jul 2, 1999 · N5943M · Substantial damageNTSB FTW99LA178Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Houston, TXThe pilot's failure to maintain the proper descent rate during a forced landing, which resulted in a runway undershoot. Factors were the total loss of engine power for an undetermined reason and the dusk light conditions.Jul 2, 1999 · N5788 · Substantial damageNTSB FTW99FA177Accident · 1 fatalField investigationFinal reportBeech V35 · Baton Rouge, LAThe pilot's performance of an abrupt maneuver immediately after takeoff, which resulted in an inadvertent stall.Jul 2, 1999 · N5608S · DestroyedNTSB CHI99LA207Accident · No injuriesLimited investigationFinal reportPiper J-3C · Independence, IAThe insufficient information from the weather forecast resulting in an in-flight encounter with turbulence/gusts and the subsequent precautionary landing. Contributing factors were the gusty/turbulent conditions and the terrain condition (crop).Jul 2, 1999 · N3371N · Substantial damageNTSB CHI99LA206Accident · No injuriesLimited investigationFinal reportBeech 58 · Wheeling, ILthe landing gear extension not performed by the pilot. A contributing factor was the checklist not followed by the pilot.Jul 2, 1999 · N3240R · Substantial damageNTSB CHI99FA208Accident · No injuriesField investigationFinal reportMcDonnell Douglas DC-9-32 · Milwaukee, WIThe vehicle driver's inadvertent application of the accelerator pedal while backing towards the aircraft.Jul 2, 1999 · N502ME · Substantial damageNTSB ATL99LA105Accident · Minor injuriesLimited investigationFinal reportBell 47 · Trenton, GAThe loss of main rotor rpm due to improper use of the flight controls by the pilot. Factors were the tailwind and trees.Jul 2, 1999 · N23590 · Substantial damageNTSB SEA99LA103Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Billings, MTThe separation of the left main landing gear shock strut for undetermined reasons.Jul 1, 1999 · N3513A · Substantial damageNTSB NYC99FA163Accident · 1 fatalField investigationFinal reportPiper PA-31T · Deerfield, VALoss of control of the airplane due to pilot incapacitation following a heart attack.Jul 1, 1999 · N602RM · DestroyedNTSB FTW99TA183Accident · Minor injuriesFinal reportMcDonnell Douglas 500-E · Oklahoma City, OKDuring a practice autorotation, the pilot flared the helicopter too low, which resulted in the tailboom contacting the ground. A factor was the dark night light conditions.Jul 1, 1999 · N686F · Substantial damageNTSB DEN99LA111Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Boulder, COThe pilot's failure to maintain control of the aircraft during landing roll.Jul 1, 1999 · N4785F · Substantial damage