NTSB investigations
176 cases where NTSB found Knowledge.
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 WHERE c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '020320')) 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.
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 WHERE c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '020320')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB WPR22LA341Accident · No injuriesClass 3 · LimitedFinal reportCessna 750 · Mesa, AZThe pilot’s improper decision to depart on the accident flight with a known hydraulic leak, resulting in an in-flight hydraulic system failure, and the pilot’s attempt to land during an unstabilized approach, which resulted in a loss of control during the…NTSB CEN22LA422Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Galena, AKThe pilot’s selection of unsuitable terrain for landing which resulted in a nose over.NTSB DCA22MA193Accident · 10 fatalClass 1 · MajorFinal reportDehavilland DHC-3 · Freeland, WAThe in-flight unthreading of the clamp nut from the horizontal stabilizer trim actuator barrel due to a missing lock ring, which resulted in the horizontal stabilizer moving to an extreme trailing-edge-down position rendering the airplane’s pitch…NTSB DCA22LA188Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-824 · Pharisburg, OHThe airplane’s inadvertent encounter with convective turbulence.NTSB CEN22LA373Accident · No injuriesClass 4 · LimitedFinal reportCessna 180C · Cantwell, AKThe pilot's excessive brake application during the landing roll that resulted in a nose over.NTSB CEN22LA340Accident · No injuriesClass 4 · LimitedFinal reportWeatherly 620A · Stewart, MNThe pilot’s failure to maintain adequate clearance from crops during an agricultural flight.NTSB CEN22LA302Accident · Minor injuriesClass 4 · LimitedFinal reportPitts S1 · Sturgeon Bay, WIThe pilot’s failure to maintain airplane control during landing, which resulted in a runway excursion and nose over. Contributing to the accident was the pilot’s inadequate preflight inspection and the pilot’s lack of flight control system knowledge.NTSB WPR22FA188Accident · 2 fatalClass 3 · FieldFinal reportCessna 172F · Show Low, AZThe pilot’s improper leaning of the engine during an extended period of time, which caused an exhaust valve to become stuck and led to the partial loss of engine power during the accident flight. Contributing to the accident was the pilot’s decision to…NTSB ERA22LA215Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 414 · Connellsville, PAThe pilot/mechanic’s failure to properly secure two airplane avionics units, which resulted in the trays supporting the units to sag downward and become lodged in the movement area of the elevator bellcrank during the accident takeoff.NTSB ANC22LA024Accident · No injuriesClass 3 · LimitedFinal reportCessna 172N · Talkeetna, AKThe pilot’s improper positioning of the fuel selector during takeoff, which resulted in fuel starvation and a subsequent total loss of engine power.NTSB CEN22LA130Accident · No injuriesClass 3 · LimitedFinal reportRaytheon Hawker 800XP · Aspen, COThe flight crew’s decision to takeoff in tailwind conditions that were consistently above the airplane’s tailwind limitation, which resulted in a runway overrun following an aborted takeoff. Contributing was the flight crew’s use of the instantaneous wind…NTSB CEN22LA110Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Fort Carson, COThe windshear encounter on short final approach, which resulted in an excessive decent rate and ground impact.NTSB DCA22LA069Accident · No injuriesClass 4 · LimitedFinal reportAirbus A320-232 · Hayden, COThe captain’s rotation of the airplane pitch before the rotation speed on takeoff due to his surprise about encountering head on landing traffic, which resulted in an exceedance of the airplane’s pitch limit and a subsequent tail strike. Contributing to the…NTSB ERA21LA380Accident · No injuriesClass 4 · LimitedFinal reportCessna 177 · Ayer, MAThe pilot’ improper preflight and inflight planning which resulted in fuel exhaustion.NTSB ERA21LA336Accident · No injuriesClass 3 · LimitedFinal reportGulfstream Aerospace G-IV · Fort Lauderdale, FLThe pilot-in-command’s (PIC) and second-in-command’s (SIC) failure during preflight inspection to ensure that the nose landing gear’s pip pin was properly installed, which resulted in separation of the pip pin during takeoff. Contributing to the accident was…NTSB CEN21LA388Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Iron Mountain, MIThe mechanics’ failure to follow procedures for high-thrust operations at the nontowered airport, which resulted in jet blast damage to an airplane taxiing nearby.NTSB CEN21LA250Accident · Minor injuriesClass 4 · LimitedFinal reportVans RV9 · West Portsmouth, OHThe pilot’s improper use of the airplane’s fuel system, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN21LA224Accident · Serious injuriesClass 3 · LimitedFinal reportDJI Matrice · Young Harris, GAThe remote pilot-in-command’s (RPIC) decision to physically hold onto the drone’s landing gear in flight, which resulted in the rotors striking his hand and causing serious injury. Contributing to the accident was the RPIC’s inadequate preflight planning and…NTSB CEN21FA198Accident · 4 fatalClass 3 · FieldFinal reportPiper PA-46-310P · Danville, ARThe pilot’s improper decision to continue flight in an area of moderate-to-heavy icing conditions, which resulted in exceedance of the airplane’s anti-icing system capabilities, a degradation of aircraft performance, and subsequent aerodynamic stall.NTSB CEN21FA130Accident · 2 fatalClass 3 · FieldFinal reportVelocity Vtwin · Janesville, WIThe exceedance of the maximum airspeed for flight with the landing gear extended, which resulted in a separation of the right main landing gear door that subsequently impacted the right propeller and resulted in a total loss of right engine power.…NTSB ERA21LA087Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA46 · Naples, FLThe inadvertent activation of the unguarded ferry tank fuel selector valve, which resulted in fuel starvation and a total loss of engine power.NTSB ERA21LA056Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Atlanta, GAThe Cessna pilot’s failure to tune his radio to the common traffic advisory frequency, which resulted in a lack of awareness of the other aircraft operating at the airport. Contributing to the accident was the Cessna pilot’s lack of understanding of the…NTSB ERA20CA226Accident · No injuriesClass 4 · Data collectionFinal reportCessna 150 · Shelby, NCThe pilot's inadequate preflight and inflight fuel planning, which resulted in fuel exhaustion.NTSB ERA20LA160Accident · No injuriesClass 3 · LimitedFinal reportHughes 369 · Pylesville, MDThe loss of engine power due to fuel starvation as a result of unporting of the fuel tank supply pickup while the helicopter was maneuvered to move a conductor wire. Contributing to the accident was the helicopter’s inappropriate configuration for the type of…NTSB WPR20LA024Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28R · Ogden, UTThe flight instructor’s failure to raise the landing gear using the alternate system, which resulted in a reduced climb rate and impact with an obstacle. Contributing to the accident was the flight instructor’s lack of understanding of the backup landing gear…NTSB WPR19FA235Accident · 1 fatalClass 3 · FieldFinal reportMeyers Midget 0100 · Big Spring, TXThe pilot’s failure to maintain situational awareness while conducting a roll, which resulted in his inability to recover from the maneuver before the airplane impacted the ground. Contributing to the accident was his inexperience in both aerobatic maneuvers…NTSB WPR19LA194Accident · Serious injuriesClass 3 · LimitedFinal reportBell 47G 3B 1 · Mosby, MTThe pilot’s failure to account for environmental conditions conducive to a loss of tail rotor effectiveness, which resulted in a loss of tail rotor effectiveness and subsequent loss of control. Contributing to the accident was the pilot’s inappropriate…NTSB CEN19FA170Accident · 1 fatalClass 2 · FieldFinal reportPiper PA28 · Huntsville, TXA total loss of engine power as a result of the pilot's inadvertent placement of the fuel selector to the "off" position.NTSB CEN19FA088Accident · 2 fatalField investigationFinal reportPiper PA46 · Shreveport, LAThe pilot's conduct of a departure into instrument meteorological conditions (IMC), which resulted in spatial disorientation and subsequent loss of airplane control. Contributing to the accident was the pilot's poor instrument flying skills and his decision…NTSB DCA19IA036Incident · No injuriesClass 3 · IncidentFinal reportBoeing 737 · Burbank, CA(1) The flight crewmembers’ decision, due to plan continuation bias, to continue the approach despite indications of windshear and a higher-than-expected tailwind and (2) the flight crew’s misperception of the airplane’s touchdown point, which was farther…NTSB GAA19CA014Accident · No injuriesData collectionFinal reportCessna 172 · Stockton, CAThe student pilot's failure to maintain directional control during takeoff.NTSB DCA18IA264Incident · No injuriesIncident investigationFinal reportLindstrand 105A · Driggs, IDthe drone pilot's decision to fly without pre-coordination, and without the requisite skills and knowledge, to maneuver the drone in close proximity to another aircraft.NTSB GAA18CA438Accident · No injuriesData collectionFinal reportMooney M20E · Great Falls, MTThe flight instructor’s incorrect use of the landing gear system and his and the pilot’s failure to ensure that the landing gear was extended, which resulted in a gear-up landing. Contributing to the accident was the flight instructor’s unfamiliarity with the…NTSB CEN18LA275Accident · No injuriesLimited investigationFinal reportWhittman Tailwind · Orient, OHThe pilot’s and the flight instructor's incorrect use of the modified mixture control, which resulted in a loss of engine power due to fuel starvation and a forced landing. Also causal was the inadequate systems knowledge of the experimental, amateur-built…NTSB CEN18FA259Accident · Serious injuriesField investigationFinal reportEurocopter Deutschland EC135 P1 · Chicago, ILThe pilot's inadvertent disabling of the No. 1 and No. 2 engines' electronic engine control systems, which resulted in engine and rotor overspeed conditions, a subsequent autorotation, and a hard landing. Contributing to the accident were the pilot's…NTSB ANC18CA052Accident · No injuriesData collectionFinal reportCessna 182 · Chugiak, AKThe pilot's mismanagement of the engine controls due to distraction in the traffic pattern, which resulted in a hard landing short of the runway.NTSB WPR18LA176Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA 18-150 · Yellow Pine, IDThe pilot’s failure to maintain adequate airspeed while conducting a go-around and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall/spin at too low of an altitude to recover. Contributing to the accident were…NTSB WPR18LA170Accident · Minor injuriesClass 3 · LimitedFinal reportSchweizer 269C · Las Vegas, NVThe pilot’s failure to take the appropriate corrective action for ground resonance, which resulted in a loss of helicopter control.NTSB WPR18FA143Accident · 1 fatalField investigationFinal reportI.C.A.-Brasov IS 29D · Avenal, CAThe pilot's improper installation of the wings onto the glider, which resulted in an in-flight wing separation. Contributing to the accident were the pilot's limited familiarity with the design and a lack of reliable assembly guidance.NTSB GAA18CA259Accident · Minor injuriesData collectionFinal reportCreech Jerry Creech Jerry CH 701 · Lusby, MDThe pilot’s improper landing flare, which resulted in a hard, bounced landing and runway excursion.NTSB GAA18CA234Accident · No injuriesData collectionFinal reportPiper PA28 · Wickenburg, AZThe student pilot’s failure to relinquish flight controls and premature flap reduction during approach to land.NTSB ERA18LA020Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Union City, TNThe pilot’s inadvertent slope landing and attempted recovery, which resulted in an incipient dynamic rollover, mast bumping, and separation of the main rotor.NTSB DCA17IA202Incident · No injuriesIncident investigationFinal reportDJI Phantom · Hoffman Island, NYthe failure of the sUAS pilot to see and avoid the helicopter due to his intentional flight beyond visual line of sight. Contributing to the incident was the sUAS pilot's incomplete knowledge of the regulations and safe operating practices.NTSB CEN17LA156Accident · No injuriesLimited investigationFinal reportLoomis Xenon 4 · Knoxville, IAA partial loss of engine power for reasons that could not be determined based on the available information. Contributing to the accident was the failure of the owners to obtain proper materials regarding the operation and maintenance of the engine.NTSB ERA17FA135Accident · 1 fatalField investigationFinal reportCessna 500 · Marietta, GAThe pilot's failure to maintain adequate airspeed while manually flying the airplane, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's inability control…NTSB GAA17CA179Accident · No injuriesData collectionFinal reportBurkhart Grob G 109B · Mokuleia, HIThe failure of the upper rudder hinge during flight due to severe corrosion. Contributing to the accident were the pilot’s inadequate preflight inspection and the lack of an annual inspection.NTSB GAA17CA135Accident · No injuriesData collectionFinal reportHughes OH 6A · Price, UTThe fuel truck driver’s failure to stop before impacting the helicopter’s main rotor blades.NTSB CEN17FA100Accident · 1 fatalField investigationFinal reportBell 206B · Galveston, TXThe pilot's failure to recognize the flight had encountered instrument meteorological conditions at night, which resulted in an unrecognized descent and collision with water.NTSB ANC17FA009Accident · 1 fatalClass 3 · FieldFinal reportBellanca 7GCBC · Fairbanks, AKThe pilot’s decision to operate the airplane at an altitude too low to allow for recovery from an intentional aerodynamic stall. Contributing to the accident was the pilot’s lack of knowledge of the stall performance characteristics of the airplane modified…NTSB GAA17CA082Accident · Serious injuriesData collectionFinal reportCameron A315 · Winters, CAThe passenger's improper egress from the balloon basket, which resulted in a serious injury.