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 CHI95LA022Accident · No injuriesLimited investigationFinal reportCessna 210A · Manhattan, KStotal loss of engine power for reason(s) undetermined. A factor was the dark night.Oct 24, 1994 · N6663X · Substantial damageNTSB BFO95FA006Accident · 2 fatalField investigationFinal reportCessna T337G · Hyannis, MALoss of aircraft control for an undetermined reason. Darkness and the weather conditions were related factors.Oct 24, 1994 · N807J · DestroyedNTSB NYC95LA016Accident · No injuriesLimited investigationFinal reportAngel Avid/Heavy Hauler · Sutton, MAThe pilot's failure to maintain the fuel selector on the proper position.Oct 23, 1994 · N740FA · Substantial damageNTSB LAX95FA016Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Kettleman City, CAFailure of the student pilot to maintain control of the airplane for an unknown reason. Factors related to the accident were: darkness and the pilot's lack of qualification/instructor endorsement for a cross-country flight at night.Oct 23, 1994 · N2326G · DestroyedNTSB FTW95LA027Accident · Serious injuriesLimited investigationFinal reportGardner SEA REY · Hartman, ARFailure of the pilot to follow the landing checklist and retract the landing gear for a water landing.Oct 23, 1994 · N703SR · Substantial damageNTSB FTW95LA026Accident · Serious injuriesLimited investigationFinal reportGeorge Spacewalker 1 · Mountain View, OKThe pilot's failure to maintain minimum required airspeed for flight.Oct 23, 1994 · N64BG · Substantial damageNTSB CHI95LA021Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Bloomington, ILthe pilot's failure to maintain airspeed during the landing which resulted in a stall. A factor related to the accident was the loss of engine power for undetermined reasons.Oct 23, 1994 · N90875 · Substantial damageNTSB CHI95LA019Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Houghton, MIinaccurate planning by the pilot which resulted in the failure to assure an adequate fuel supply to complete the flight. A factor associated with the accident was the lack of a suitable landing site for the forced landing.Oct 23, 1994 · N6464J · Substantial damageNTSB BFO95LA007Accident · No injuriesLimited investigationFinal reportCessna A185F · N New Portland, METhe pilot's failure to verify the landing gear was in the proper position for landing.Oct 23, 1994 · N9667Q · Substantial damageNTSB ATL95FA007Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Newville, ALFailure of maintenance personnel to properly install the marmon clamp on the discharge side of the turbocharger.Oct 23, 1994 · N999BW · DestroyedNTSB NYC95LA017Accident · Minor injuriesLimited investigationFinal reportPitts S-1C · Galeville, NYInadequate maintenance inspection which resulted in disengagement of the rudder clevis bolt and the inflight loss of control during aerobatic manuevers.Oct 22, 1994 · N7037W · DestroyedNTSB MIA95LA011Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-34 · Mulberry, FLThe failure of the pilot-in-command to perform an adequate preflight inspection resulting in a leaking brake going undetected. This resulted in the failure of the brake due to loss of hydraulic fluid and collision with a sign and a ditch when the aircraft…Oct 22, 1994 · N7679 · Substantial damageNTSB FTW95LA025Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Tres Piedras, NMThe pilot's inadequate inflight planning which led to maneuvering at slow airspeed to avoid terrain which resulted in further loss of airspeed and an aerodynamic stall.Oct 22, 1994 · N2721L · DestroyedNTSB FTW95FA020Accident · 1 fatalField investigationFinal reportBrantly Helicopter B-2 · Artesia, NMThe pilot's impairment of judgment and performance due to drugs, and his failure to maintain clearance from a powerline.Oct 22, 1994 · N5905X · DestroyedNTSB CHI95LA024Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Grand Forks, NDthe fatigue failure of the crankshaft.Oct 22, 1994 · N587PA · Substantial damageNTSB CHI95LA023Accident · No injuriesLimited investigationFinal reportCessna 172F · Cross Plains, WIthe pilot's failure to use carburetor heat. Factors were carburetor icing conditions and rough/uneven terrain.Oct 22, 1994 · N7969U · Substantial damageNTSB CHI95LA020Accident · No injuriesLimited investigationFinal reportCessna 182P · Bremen, INthe pilot's failure to perform a go-around prior to touchdown. Factors to the accident were the tailwind, excessive airspeed, the rough terrain and the powerlines.Oct 22, 1994 · N9878E · Substantial damageNTSB NYC95LA015Accident · No injuriesLimited investigationFinal reportCessna 172B · Honesdale, PAthe fuel selector was in the improper position, which resulted in a total loss of engine power, due to fuel starvation, a forced landing, and subsequent impact with a stone wall.Oct 21, 1994 · N7491E · Substantial damageNTSB MIA95LA007Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Ormond Beach, FLThe pilot's failure to maintain directional control during landing, resulting in an on-ground loss of control, and collision with terrain.Oct 21, 1994 · N18539 · Substantial damageNTSB FTW95LA031Accident · No injuriesLimited investigationFinal reportHerron Little Wing Autogyro · Little Rock, ARThe fractured tail wheel mounting bracket and loose tailwheel. A factor was the pilot's continued flight testing after experiencing tail wheel shimmy on the prior test flight.Oct 21, 1994 · N45LW · Substantial damageNTSB FTW95LA028Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Lubbock, TXThe pilot's failure to maintain clearance with the irrigation equipment. A factor was pilot fatigue.Oct 21, 1994 · N8523S · Substantial damageNTSB FTW95LA024Accident · No injuriesLimited investigationFinal reportMooney M20C · Greeley, COInadvertent landing gear retraction by the pilot flying the aircraft. A factor was inadequate supervision by the flight instructor.Oct 21, 1994 · N6958V · Substantial damageNTSB CHI95LA017Accident · No injuriesLimited investigationFinal reportCessna 210L · Higginsville, MOA coyote (animal) that ran onto the runway as the airplane was landing.Oct 21, 1994 · N616WB · Substantial damageNTSB ANC95LA005Accident · No injuriesLimited investigationFinal reportAeronca Sedan AR-15 · Nikolai, AKThe pilot's continued flight into adverse weather. Factors to the accident were falling snow, an obstruction of the fuel system vents, restriction of the fuel flow and lack of a suitable landing area.Oct 21, 1994 · N1428H · Substantial damageNTSB LAX95LA018Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Rialto, CAthe flight instructor's loss of airplane control during the landing flare as a result of his inadequate supervision of the flight and delayed corrective action over his presolo student's control inputs.Oct 20, 1994 · N8760F · Substantial damageNTSB CHI95FA018Accident · 5 fatalField investigationFinal reportPiper PA-23-250 · Sellersburg, INFailure of the pilot to follow IFR procedures by allowing the aircraft to deviate left of the ILS localizer course, by not maintaining the proper ILS glide path, and by continuing descent below the ILS decision height.Oct 20, 1994 · N40509 · DestroyedNTSB ATL95LA006Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Jakin, GAThe loss of engine power for undetermined reasons.Oct 20, 1994 · N8960H · Substantial damageNTSB ATL95FA005Accident · 2 fatalField investigationFinal reportGulfstream American AA-5A · Lexington, NCThe pilot's operation of the aircraft with a known deficiency (foreign material or particle in the pitot tube), which led to a false airspeed indication and premature lift-off of the aircraft during takeoff, and the pilot's improper remedial action that…Oct 20, 1994 · N26966 · DestroyedNTSB LAX95LA013Accident · No injuriesLimited investigationFinal reportStan G. Hallam RV-6 · Bridgeport, CAthe pilot's poorly planned approach, his failure to maintain the proper airspeed and descent rate, and his failure to perform the necessary remedial action.Oct 19, 1994 · N93SJ · Substantial damageNTSB LAX95LA012Accident · No injuriesLimited investigationFinal reportPitts S-2B · Chandler, AZthe pilot's failure to maintain proper alignment with the runway during landing rollout. A contributing factor was sun glare.Oct 19, 1994 · N15KR · Substantial damageNTSB ANC95LA007Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Palmer, AKThe pilot's selection of unsuitable terrain for landing. Snow covered terrain in the landing area was a factor in the accident.Oct 19, 1994 · N97821 · Substantial damageNTSB NYC95LA014Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Haymarket, VAThe pilot's failure to extend the landing gear which resulted in a gear up landing. A factor was the pilot's diverted attention.Oct 18, 1994 · N54VT · Substantial damageNTSB LAX95IA011Incident · No injuriesIncident investigationFinal reportCessna 402 · Grand Canyon, AZthe fracture and failure of the left main landing gear bellcrank which jammed the landing gear in the retracted position.Oct 18, 1994 · N402SW · Minor damageNTSB CHI95LA016Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Ft. Wayne, INthe in-flight collision with birds(geese). A factors associated with the accident was the building which was contacted.Oct 18, 1994 · N83KK · Substantial damageNTSB CHI95LA015Accident · No injuriesLimited investigationFinal reportQuestair Venture · Wheeling, ILThe inadvertent deployment of the nosewheel steering. A factor in this accident was the inadequate design of the rudder pedal pivot point height above the cockpit floor by the design personnel.Oct 18, 1994 · N62V · Substantial damageNTSB FTW95IA022Incident · No injuriesIncident investigationFinal reportCanadair CL 600 · Nacogdoches, TXThe flight crew's improper use of the anti-ice system, which resulted in engine ice, subsequent ice ingestion, and engine flameout. Factors related to the accident were: failure of the flight crew to follow the checklist procedures after flight into adverse…Oct 17, 1994 · N600RE · Minor damageNTSB LAX95LA010Accident · No injuriesLimited investigationFinal reportBeech C-23 · Kahului, HIthe student pilot's improper recovery from a bounced landing, improper in-flight decision, and his failure to attain the proper climb airspeed during the initial takeoff resulting in an inadvertent stall. The student pilot's lack of total experience,…Oct 16, 1994 · N60054 · Substantial damageNTSB FTW95LA018Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Fredericksburg, TXImproper maintenance resulting in an engine fire, and the pilot's improper propeller feathering procedure, causing the propeller not to feather and the airplane's engine out capability to be exceeded. A factor was the unsuitable terrain conditions.Oct 16, 1994 · N821AC · Substantial damageNTSB CHI95LA014Accident · Serious injuriesLimited investigationFinal reportMooney M-20J · Aberdeen, SDthe pilot's failure to assure adequate maintenance was performed on the airplane and the resulting intentional flight with known deficiencies. Factors associated with the accident were the pilot's failure to follow the aircraft flight manual and the improper…Oct 16, 1994 · CGJRA · Substantial damageNTSB CHI95FA012Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Winfield, ILCollision with the ground for an undetermined reason. The pilot's psychological condition was a probable factor.Oct 16, 1994 · N9089U · DestroyedNTSB BFO95LA005Accident · Minor injuriesLimited investigationFinal reportS M A N Hydroplum Petrel · Center Village, OHLoss of engine power due to a malfunction of the fuel pump.Oct 16, 1994 · N1601Z · Substantial damageNTSB NYC95LA028Accident · No injuriesLimited investigationFinal reportRans/Hine S-10 · Hampton, NHa seized piston in the foward cylinder due to a lean mixture.Oct 15, 1994 · N104AH · Substantial damageNTSB NYC95LA013Accident · Minor injuriesLimited investigationFinal reportCessna 182M · Worthington, PAThe failure of the aileron control cable which resulted in the inflight loss of control and collision with trees.Oct 15, 1994 · N70751 · Substantial damageNTSB NYC95LA012Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28A · Shelburne, VTThe pilot's inadequate compensation for wind conditions which resulted in a loss of tail rotor effectiveness.Oct 15, 1994 · N9238 · Substantial damageNTSB NYC95LA010Accident · No injuriesLimited investigationFinal reportBoeing Stearman PT-17 · Fitchburg, MAThe pilot's failure to adequately compensate for the crosswind condition during landing, which resulted in a ground loop and the subsequent wing tip collision with the runway.Oct 15, 1994 · N4923N · Substantial damageNTSB NYC95LA009Accident · 1 fatalLimited investigationFinal reportAerospatiale AS-355 · Jonesville, VAThe pilot's failure to maintain clearance from the power lines.Oct 15, 1994 · N5787A · DestroyedNTSB MIA95LA006Accident · No injuriesLimited investigationFinal reportCessna 172-F · Clearwater, FLThe student pilot's failure to adequately compensate for the crosswind condition. Contributing to the accident was the pilot's lack of total experience.Oct 15, 1994 · N8356U · Substantial damageNTSB LAX95LA009Accident · No injuriesLimited investigationFinal reportCessna 177RG · Laytonville, CAwere the pilot's failure to maintain the proper airspeed and attain the proper touchdown point.Oct 15, 1994 · N7577V · Substantial damageNTSB LAX95LA008Accident · Serious injuriesLimited investigationFinal reportRey Avid Flyer · Bakersfield, CAthe inadequate maintenance on the engine's liquid cooling system fittings and lines.Oct 15, 1994 · N827H · DestroyedNTSB LAX95LA007Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Atherton, CAthe pilot's inadequate fuel consumption calculations and failure to refuel the aircraft while en route.Oct 15, 1994 · N67358 · Substantial damage