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 CHI99LA187Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5KB · Iowa City, IAthe pilot stalled the airplane. Factors included the instructor pilot's inadequate preflight briefing and improper in flight decision.Jun 17, 1999 · N4531R · Substantial damageNTSB NYC99LA149Accident · No injuriesLimited investigationFinal reportCessna 172L · Millinocket, METhe total loss of engine power for undetermined reasons.Jun 16, 1999 · N7897G · Substantial damageNTSB NYC99LA146Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Delphos, OHA blocked fuel line, from an unknown object, that resulted in fuel starvation, and total loss of engine power. A factor in the accident was the pilot's failure to maintain rotor rpm during the autorotation.Jun 16, 1999 · N57CR · Substantial damageNTSB NYC99LA145Accident · Serious injuriesLimited investigationFinal reportHunter Myers 145 · Wapakoneta, OHLoss of engine power for undetermined reasons.Jun 16, 1999 · N42240 · Substantial damageNTSB DEN99LA104Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Canon City, COThe pilot's poor judgement due to his intentional and continued flight into instrument meteorological conditions. Factors were the existing weather conditions that included clouds and obscuration.Jun 16, 1999 · N9355M · DestroyedNTSB CHI99LA186Accident · No injuriesLimited investigationFinal reportNorth American Navion L-17A · Osceola, WIthe pilot's mismanagement of the fuel system in that he had the fuel selector positioned to a tank which did not contain sufficient fuel for the flight. Factors associated with the accident were the crop and the ditch which the airplane encountered during the…Jun 16, 1999 · N109F · Substantial damageNTSB SEA99LA086Accident · No injuriesLimited investigationFinal reportCessna 150M · Bellingham, WACompensation for wind conditions was inadequate. Gusting wind conditions was a factor.Jun 15, 1999 · N9349U · Substantial damageNTSB NYC99FA140Accident · 4 fatalField investigationFinal reportSikorsky S-76A · Jackson, KYthe failure of the PIC to adequately supervise the SIC, and maintain a positive climb. Factors were the fog and dark night.Jun 15, 1999 · N2743E · DestroyedNTSB MIA99LA184Accident · No injuriesLimited investigationFinal reportDonald White Velocity XL/RG · Fort Pierce, FLThe owner/pilot mechanic's failure to adjust the newly installed wing fuel caps resulting in the loss of engine power while in cruise flight due to fuel starvation and the subsequent collision with transmission wires while attempting a forced landing to a…Jun 15, 1999 · N19DW · Substantial damageNTSB LAX99LA217Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Needles, CAThe pilot's inadequate compensation for the gusty crosswind condition and subsequent failure to maintain alignment with the road used for takeoff, which resulted in a collision with a construction sign during the initial climb.Jun 15, 1999 · N6448B · Substantial damageNTSB LAX99GA216Accident · Serious injuriesFinal reportHughes OH-6A · Tucson, AZFuel exhaustion resulting from pilot's failure to perform adequate fuel consumption calculations. The unreliable and inoperative fuel level indicating system components and the operator's operation of the aircraft with known deficiencies were factors in the…Jun 15, 1999 · N6187C · DestroyedNTSB ANC99LA077Accident · Minor injuriesLimited investigationFinal reportCessna 180A · Fairbanks, AKThe pilot's inadequate in-flight planning/decision during a go-around. A factor was the pilot's failure to maintain the proper glide path to the runway.Jun 15, 1999 · N5218D · Substantial damageNTSB SEA99LA084Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Easton, WAThe flight instructor's delayed remedial action. Factors include the student allowing the aircraft to climb too steeply at too low an airspeed, and the soft/rough terrain on which the aborted takeoff took place.Jun 14, 1999 · N62800 · Substantial damageNTSB NYC99LA141Accident · No injuriesLimited investigationFinal reportPrendergast Seawind · Martinsburg, WVThe air-intake's inner liner separating from its outer liner, which blocked airflow to the fuel servo, resulting in a loss of engine power. A factor in the accident was the owner/builder's inadequate inspection of the airplane.Jun 14, 1999 · N8190J · Substantial damageNTSB MIA99FA180Accident · 4 fatalField investigationFinal reportCessna 421C · Charlotte, NCThe failure of the pilot to shutdown the right engine and feather the propeller after a reported loss of power in the engine shortly after takeoff resulting in the airplane descending, colliding with trees and then the ground.Jun 14, 1999 · N421LL · DestroyedNTSB CHI99LA192Accident · Minor injuriesLimited investigationFinal reportRussell Sport Trainer · Ft. Calhoun, NEthe pilot used an improper engine starting procedure in that he failed to reduce the throttle setting and to assure the airplane was adequately secured prior to starting.Jun 14, 1999 · N57HR · Substantial damageNTSB SEA99GA085Accident · 2 fatalFinal reportCessna 182R · Enterprise, ORThe pilot's failure to maintain aircraft control while maneuvering in a canyon, and the mentor's failure to take adequate remedial action. Factors included box canyon terrain and high density altitude conditions.Jun 13, 1999 · N9458H · DestroyedNTSB NYC99LA148Accident · No injuriesLimited investigationFinal reportAdams Rotorway EXEC-90 · Evington, VAThe pilot's selection of unsuitable terrain for a run on landing. A factor was the dirt bank.Jun 13, 1999 · N8235W · Substantial damageNTSB NYC99LA143Accident · No injuriesLimited investigationFinal reportFlaherty RV-6 · Jeannette, PAThe pilot-in-command misjudged altitude during a simulated forced landing.Jun 13, 1999 · N81081 · Substantial damageNTSB MIA99LA183Accident · Serious injuriesLimited investigationFinal reportSouth Mississippi Light Aircra Buccaneer II · Panacea, FLThe intentional continued operation of the airplane by the pilot-in-command with known deficiencies with the pitot system after takeoff, resulting in erroneous airspeed indications, and inadvertent stall by the pilot resulting in the uncontrolled descent into…Jun 13, 1999 · N618BC · Substantial damageNTSB MIA99LA182Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Seymour, TNThe failure of the pilot to perform a go-around earlier resulting in a long landing, insufficient runway remaining to stop, and subsequent in flight collision with a marked power line during an aborted landing.Jun 13, 1999 · N5494K · Substantial damageNTSB MIA99LA179Accident · 1 fatalLimited investigationFinal reportPiper PA-28R-180 · Wimauma, FLa passenger deplaning the airplane while the engine was running struck the propeller.Jun 13, 1999 · N7485J · No damageNTSB MIA99LA178Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Charlotte, NCThe pilot misjudged the flare during the landing.Jun 13, 1999 · N142JM · Substantial damageNTSB LAX99LA215Accident · 1 fatalLimited investigationFinal reportAB Sportine Aviacija Genesis 2 · Minden, NVThe flight control stabilator becoming disconnected during the initial ground tow. Factors in the accident were the inadequate preflight by the pilot and communications with the pilot not possible.Jun 13, 1999 · N240BG · DestroyedNTSB FTW99LA169Accident · No injuriesLimited investigationFinal reportCessna 414 · Springdale, ARThe failure of the right main landing gear torque tube support bracket/pivot bearing which resulted in the failure of the landing gear locking mechanism.Jun 13, 1999 · N475JN · Substantial damageNTSB FTW99LA163Accident · Minor injuriesLimited investigationFinal reportCanadian Car & Foundry Harvard MK IV · Mckinney, TXThe pilot's failure to maintain directional control on landing. Contributing factors were the elevator control restriction, the pilot's inadequate preflight, the ditch, and gusty conditions.Jun 13, 1999 · N59TS · Substantial damageNTSB CHI99LA171Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Austin, MNThe loss of engine power for an undetermined reason. Factors associated with the accident were the low altitude of the helicopter, which precluded an emergency autorotation, and the crop field.Jun 13, 1999 · N64292 · Substantial damageNTSB ANC99LA076Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12 · Cantwell, AKA loss of engine power for an undetermined reason.Jun 13, 1999 · N43373 · Substantial damageNTSB NYC99LA142Accident · No injuriesLimited investigationFinal reportMorrow RV-6 · Bradford, PAThe pilot's improper flare which resulted in a hard landing, and subsequent collapse of the nose gear.Jun 12, 1999 · N173AB · Substantial damageNTSB NYC99LA139Accident · No injuriesLimited investigationFinal reportAero Commander 500S · Windsor Locks, CTHydraulic system contamination which prevented normal landing gear extension. A factor was the misjudged landing flare by the flying pilot.Jun 12, 1999 · N33PG · Substantial damageNTSB NYC99LA138Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28 · Cincinnati, OHThe pilot's inadequate evaluation of the weather conditions at the time of departure, which resulted in a downwind takeoff. A factor in the accident was the change in wind direction.Jun 12, 1999 · N9588 · Substantial damageNTSB MIA99LA174Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Seneca, SCThe PIC's improper fuel management resulting in loss of engine power during approach to landing due to fuel starvation and the subsequent collision with trees and a residence during an emergency landing. Contributing to the accident was the PIC's failure to…Jun 12, 1999 · N6407N · Substantial damageNTSB MIA99LA173Accident · Minor injuriesLimited investigationFinal reportCessna 182R · Sevierville, TNA loss of propeller governor control due to oil contamination.Jun 12, 1999 · N6126E · Substantial damageNTSB FTW99LA167Accident · No injuriesLimited investigationFinal reportCessna 172D · Jonesboro, ARThe pilot's inadequate preflight planning and preparation, and her delayed aborted takeoff. Factors were the high density altitude and the tall grass on the airstrip.Jun 12, 1999 · N2460Y · Substantial damageNTSB FTW99LA165Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Panhandle, TXThe pilot's failure to maintain directional control of the airplane during the landing roll. A factor was the noise heard by the pilot that resulted in his decision to execute a precautionary landing.Jun 12, 1999 · N2699M · Substantial damageNTSB DEN99LA101Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Grand Junction, COThe pilot's inadequate preflight planning and preparation for the runway and the environment in which he intended to fly. Factors were high-density altitude and a dirt runway.Jun 12, 1999 · N7556R · Substantial damageNTSB DEN99LA100Accident · No injuriesLimited investigationFinal reportButler SX-300 · Hill Afb, UTA failure of the left main landing gear attachment for undetermined reasons.Jun 12, 1999 · N120J · Substantial damageNTSB CHI99LA184Accident · Serious injuriesLimited investigationFinal reportBoeing 777-222 · Madison, WIthe pilot-in-command's inadequate evaluation of the weather conditions. Factors associated with the accident were the turbulence encountered and the seat belt sign was not illuminated.Jun 12, 1999 · N781UA · No damageNTSB CHI99LA182Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Vincennes, INthe pilot's failure to maintain directional control of the airplane during the soft field takeoff. Factors associated with the accident were inadequate airspeed and the cable fence which was contacted.Jun 12, 1999 · N6843J · Substantial damageNTSB NYC99LA137Accident · No injuriesLimited investigationFinal reportCessna 172 · Ravenna, OHThe pilot-in-command's failure to maintain aircraft control during landing.Jun 11, 1999 · N62953 · Substantial damageNTSB MIA99WA176Accident · No injuriesForeign investigationCessna 210L · Gt. Harbour Cay, BahamasJun 11, 1999 · N1765X · DestroyedNTSB MIA99LA181Accident · No injuriesLimited investigationFinal reportRobinson R-44 · Sevierville, TNThe induced fatigue fracture of a component in the engine-to-transmission rotor drive system resulting in a disconnection of the drive system during cruise flight caused by inadequate inspection processes by the manufacturer and the subsequent autorotative…Jun 11, 1999 · N49669 · Substantial damageNTSB MIA99LA175Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Fort Myers, FLThe pilot's failure to verify that the retractable landing gear were down and locked for landing.Jun 11, 1999 · N5238P · Substantial damageNTSB FTW99LA168Accident · No injuriesLimited investigationFinal reportCessna T188C · Panhandle, TXThe partial loss of engine power as a result of the low compression in the number 5 cylinder. A factor was the lack of suitable terrain for the forced landing.Jun 11, 1999 · N9659J · Substantial damageNTSB FTW99LA166Accident · No injuriesLimited investigationFinal reportTaylorcraft F21 · Pleasanton, TXThe pilot's inadvertent flight into adverse weather, which resulted in a loss of aircraft control. A factor was the whirl wind weather condition.Jun 11, 1999 · N2806W · Substantial damageNTSB DEN99LA103Accident · No injuriesLimited investigationFinal reportCessna 172N · Grand Junction, COA hard landing when the pilot failed to sufficiently flare the aircraft for touch down. Factors were high-density altitude, and the pilot's lack of total flight experience.Jun 11, 1999 · N359DS · Substantial damageNTSB CHI99LA183Accident · No injuriesLimited investigationFinal reportGrumman American G-164B · Goodland, KSthe fracture of the rocker arm bolt. Contributing factors were the pilot's low altitude and the crops.Jun 11, 1999 · N6515K · Substantial damageNTSB CHI99GA185Accident · 2 fatalFinal reportPiper PA-18-150 · Baudette, MNthe pilot inadvertently stalled the airplane. A factor was the low altitude.Jun 11, 1999 · N305NR · DestroyedNTSB ANC99LA075Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Big Lake, AKThe pilot's inadvertent stall during takeoff. Factors associated with the accident are wind gusts and turbulence.Jun 11, 1999 · N2668P · Substantial damageNTSB ANC99FA074Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Tanana, AKUndetermined.Jun 11, 1999 · N41078 · Destroyed