NTSB investigations

19,222 cases where NTSB found Aircraft.

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\", '01'))
  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 ANC16LA048Accident · No injuriesLimited investigationFinal reportStinson 108 · Haines, AKThe pilot’s failure to maintain directional control of the airplane during the landing roll with a quartering tailwind, which resulted in a ground loop and overstress failure of the left main landing gear wheel axle.Jul 18, 2016 · N343C · Substantial damageNTSB WPR16LA142Accident · No injuriesLimited investigationFinal reportBell UH 1H · Mt. Adams, WAThe pilot’s failure to maintain yaw control as he slowed the helicopter during a landing approach, which resulted in the loss of helicopter control due to the loss of tail rotor effectiveness.Jul 17, 2016 · N790RJ · Substantial damageNTSB WPR16LA141Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Minden, NVThe failure of a main landing gear leg during takeoff due to corrosion, which resulted in a nose-over during the subsequent landing on a grassy area.Jul 17, 2016 · N2759K · Substantial damageNTSB GAA16CA384Accident · Minor injuriesData collectionFinal reportBoeing A75 · St. James, MOThe pilot's loss of control while performing an aerobatic maneuver resulting in an inadvertent spin and collision with trees and terrain.Jul 17, 2016 · N4558N · Substantial damageNTSB ERA16CA259Accident · Minor injuriesData collectionFinal reportHirn Associates Zodiac CH601XL · Hedgesville, WVThe pilot’s inadvertent activation of the elevator trim, which resulted in a premature takeoff and subsequent loss of airplane control and collision with trees.Jul 17, 2016 · N650WP · Substantial damageNTSB GAA16CA382Accident · Minor injuriesData collectionFinal reportGonzalez Manuel A RV 7 · Langley, WAThe pilot's decision to land with a tailwind, which resulted in, landing long, a runway overrun, and impact with a berm and nose over.Jul 16, 2016 · N228MG · Substantial damageNTSB GAA16CA379Accident · Minor injuriesData collectionFinal reportJesse Saint/Troy Townsend/Etha CH-801 · Beaumont, KSThe pilot's incorrect pitch control during the landing flare in gusty crosswind conditions, which resulted in a hard bounced landing and a nose over.Jul 16, 2016 · N801G · Substantial damageNTSB ERA16LA261Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Calhoun, GAThe helicopter owner’s failure to ensure the helicopter’s airworthiness and the inadequate inspection and maintenance of the helicopter's landing gear dampers, which resulted in ground resonance during throttle application. Contributing to the damage of the…Jul 16, 2016 · N6148D · Substantial damageNTSB ERA16LA258Accident · 1 fatalLimited investigationFinal reportPiper PA24 · Westwood, MAThe pilot's improper fuel management, which resulted in exhaustion of the fuel in the selected fuel tank and a total loss of engine power due to fuel starvation.Jul 16, 2016 · N11MT · Substantial damageNTSB ERA16FA257Accident · 3 fatalField investigationFinal reportPiper PA 28R-201 · Esperance, NYThe pilot's inadequate preflight weight and balance and performance planning, which resulted in the airplane being over gross weight. Also causal were the pilot's decision not to use the entire runway for takeoff, his premature liftoff, and his failure to…Jul 16, 2016 · N2241Q · DestroyedNTSB CEN16LA299Accident · No injuriesLimited investigationFinal reportEngineering & Research 415 C · Mt Morris, ILThe pilot's loss of airplane control during a forced landing in gusting crosswind conditions and the airplane’s subsequent bounce on the runway following a loss of engine power. Contributing to the accident was the loss of engine power due to carburetor icing.Jul 16, 2016 · N99307 · Substantial damageNTSB GAA16CA376Accident · No injuriesData collectionFinal reportCessna 182 · Stevensville, MTThe pilot's failure to maintain adequate clearance from ground equipment during takeoff, which resulted in an impact with irrigation pipes, a loss of directional control, an impact with a fence, and a nose over.Jul 15, 2016 · N9928B · Substantial damageNTSB ERA16LA260Accident · No injuriesLimited investigationFinal reportSorensen Danny Pitts S1 S · Somerville, TNThe failure of the left landing gear leg due to fatigue, which resulted in a ground loop during landing. Contributing to the accident was the airplane builder's installation of a custom-built landing gear rather than the landing gear included with the…Jul 15, 2016 · N4714H · Substantial damageNTSB GAA16CA378Accident · No injuriesData collectionFinal reportPiper PA46R · Denver, COThe pilot's improper nose down pitch attitude during touchdown resulting in a propeller strike, hard bounced landing, and nose landing gear collapse.Jul 14, 2016 · N465BP · Substantial damageNTSB GAA16CA374Accident · Minor injuriesData collectionFinal reportCessna 150 · Cleveland, GAFailure of the left main landing gear attachment during the landing roll, which resulted in a left landing gear collapse, and damage to the left wing and aileron.Jul 11, 2016 · N23483 · Substantial damageNTSB GAA16CA373Accident · No injuriesData collectionFinal reportCanadian Car & Foundry Harvard · Somerset, KYThe pilot's failure to maintain directional control during the landing roll, which resulted in runway excursion, and collision with an airport sign.Jul 11, 2016 · N99CV · Substantial damageNTSB ERA16LA253Accident · 1 fatalLimited investigationFinal reportBell 429 · Georgetown, DEThe emergency response team's failure to ensure that the system operator was secured to the helicopter, which resulted in his fall during the recurrent rescue hoist training operation.Jul 11, 2016 · N1SP · No damageNTSB ERA16LA252Accident · Minor injuriesLimited investigationFinal reportCessna 310 · Bartow, FLThe pilot's failure to move the fuel selectors to the “main” position in accordance with the Before Landing checklist, which resulted in fuel starvation and the total loss of power of both engines.Jul 11, 2016 · N100CP · Substantial damageNTSB ERA16LA251Accident · Serious injuriesLimited investigationFinal reportTumbling Goose 12S · Zellwood, FLA total loss of engine power during descent for reasons that could not be determined because impact damage precluded a complete examination of the fuel servo.Jul 11, 2016 · N867TG · DestroyedNTSB ERA16FA248Accident · 1 fatalField investigationFinal reportBell Helicopter Textron Canada 407 · Hickory, KYCompany maintenance personnel's inappropriate removal without replacement of the safety wires on the collective lever pin screws during a recent maintenance inspection, which resulted in the screws backing out and led to a loss of collective control in flight.Jul 11, 2016 · N427TV · Substantial damageNTSB GAA16CA472Accident · No injuriesData collectionFinal reportCessna 172 · Kahului, HIThe pilot's incorrect pitch control during the landing flare, which resulted in a porpoise and hard landing.Jul 10, 2016 · N335SP · Substantial damageNTSB GAA16CA372Accident · Minor injuriesData collectionFinal reportBell OH 58 · Surprise, AZWhile at a low altitude, the pilot's decision to do an abrupt descending right downwind turn which resulted in flying through his own vortices and an impact with terrain.Jul 10, 2016 · N588MP · Substantial damageNTSB GAA16CA366Accident · No injuriesData collectionFinal reportHelio H 295 · Grants Pass, ORThe pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a runway excursion and a ground loop.Jul 10, 2016 · N9185Z · Substantial damageNTSB ERA16LA254Accident · Serious injuriesLimited investigationFinal reportBuckeye Dream Machine · Hartford, KYA partial loss of engine power for reasons that could not be determined and the pilot’s failure to maintain directional control during the aborted takeoff.Jul 10, 2016 · N3519T · Substantial damageNTSB ERA16LA247Accident · Minor injuriesLimited investigationFinal reportMormile Francis W Aventura II · West Pittsfield, METhe pilot's failure to maintain airplane control after a total loss of engine power due to carburetor icing, which accumulated because the carburetor heat was not functioning.Jul 9, 2016 · N932MC · Substantial damageNTSB WPR16LA139Accident · No injuriesLimited investigationFinal reportCessna 140 · Salinas, CAThe fatigue failure of a bulkhead-skin joint that supported the main landing gear leg, which resulted in the collapse of the left main landing gear. Contributing to the failure were the non-original structural configuration of the 60-year-old airplane and the…Jul 8, 2016 · N89965 · Substantial damageNTSB GAA16CA369Accident · No injuriesData collectionFinal reportStinson 108 · Red Lodge, MTA deer running across the runway and impacting the left side of the airplane, resulting in a loss of directional control, a runway excursion, and a ground loop.Jul 8, 2016 · N955C · Substantial damageNTSB CEN16LA259Accident · No injuriesLimited investigationFinal reportCessna 152 · Bridgeport, TXThe pilot's unstabilized approach and uneven braking due to insufficient runway remaining, which resulted in a loss of directional control during landing. Contributing to the accident was the bound flap jackscrew, which jammed the flaps and led to the pilot’s…Jul 8, 2016 · N5331B · Substantial damageNTSB CEN16FA261Accident · 4 fatalField investigationFinal reportPiper PA 32R-300 · Houston, TXThe pilot's failure to maintain adequate airspeed after becoming distracted by the open baggage door while operating in the airport traffic pattern, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall at…Jul 8, 2016 · N32KK · DestroyedNTSB GAA16CA377Accident · No injuriesData collectionFinal reportPiper PA 44 · Keene, NHThe flight instructor’s failure to use carburetor heat during the approach while operating in atmospheric conditions that were conducive to carburetor icing, which resulted in a loss of engine power due to carburetor icing.Jul 7, 2016 · N190ND · Substantial damageNTSB GAA16CA367Accident · No injuriesData collectionFinal reportCessna 182 · Searcy, ARThe pilot landed long and failed to stop before the end of the runway, which resulted in a runway overrun and impact with trees. Contributing to the accident was the pilot's failure to maintain a stabilized approach.Jul 7, 2016 · N9046T · Substantial damageNTSB ENG16IA027Incident · No injuriesIncident investigationFinal reportBoeing 757 · Jamaica, NYMaintenance personnel's failure to ensure proper installation of a fuel tube O-ring, which resulted in an undercowl engine fire during initial climb.Jul 7, 2016 · N706TW · Minor damageNTSB CEN16LA256Accident · No injuriesLimited investigationFinal reportGulfstream American AA 5 · Cheyenne, WYThe airplane’s encounter with low-level wind shear during takeoff, which resulted in an off-airport landing.Jul 7, 2016 · N26908 · Substantial damageNTSB GAA16CA370Accident · No injuriesData collectionFinal reportCessna 180 · New Durham, NHThe pilot's failure to maintain directional control during landing after encountering a boat wake, which resulted in the airplane veering left, impacting the water's surface, and subsequently becoming submerged.Jul 6, 2016 · N767MH · Substantial damageNTSB ERA16LA272Accident · No injuriesLimited investigationFinal reportHarrity William V Glasair (SH2F) · Maynardville, TNThe in-flight failure of the No. 3 cylinder connecting rod for reasons that could not be determined during postaccident examination.Jul 6, 2016 · N67WH · Substantial damageNTSB DCA16FA199Accident · 2 fatalClass 2 · FieldFinal reportBell 525 · Italy, TXA severe vibration of the helicopter that led to the crew's inability to maintain sufficient rotor rotation speed (Nr), leading to excessive main rotor blade flapping, subsequent main rotor blade contact with the tail boom, and the resultant in-flight…Jul 6, 2016 · N525TA · DestroyedNTSB CEN16LA251Accident · No injuriesLimited investigationFinal reportChampion 7EC · Placedo, TXThe inadequate annual inspection of the fuel system that failed to detect a deteriorated fuel line and a misrigged fuel selector, which resulted in fuel starvation and a subsequent total loss of engine power. Contributing to the accident was the mechanic’s…Jul 6, 2016 · N9891B · Substantial damageNTSB GAA16CA368Accident · No injuriesData collectionFinal reportAvions Mudry ET Cie CAP · Spring Branch, TXThe flight instructor's inability to maintain directional control during the landing roll as a result of the malfunctioning brake master cylinder.Jul 5, 2016 · N42415 · Substantial damageNTSB CEN16LA246Accident · No injuriesLimited investigationFinal reportCessna 172 · Wonder Lake, ILThe flight instructor's inadequate supervision and lack of remedial action due to his diverted attention to a radio call, which resulted in the airplane landing short of the runway.Jul 5, 2016 · N6576H · Substantial damageNTSB WPR16LA135Accident · No injuriesLimited investigationFinal reportBert N Norris RV-6 · St. Maries, IDA partial loss of engine power due to carburetor icing, which resulted from the pilot’s failure to apply carburetor heat.Jul 4, 2016 · N916BN · Substantial damageNTSB CEN16FA241Accident · 1 fatalField investigationFinal reportBoeve Earl Seawind · Buena Vista, COThe pilot's failure to maintain control of the airplane during a forced landing following a partial loss of engine power, which resulted in a hard landing and nose over. The reason for the loss of engine power could not be determined due to the severity of…Jul 4, 2016 · N46EB · DestroyedNTSB ANC16CA040Accident · No injuriesData collectionFinal reportCessna 180 · Nome, AKThe pilot's failure to maintain an adequate glide path during landing, which resulted in the airplane landing short of the runway and impacting a barricade. Contributing to the accident was the airport manager's improper placement and marking of a metal…Jul 4, 2016 · N9203T · Substantial damageNTSB GAA16CA356Accident · Minor injuriesData collectionFinal reportCessna 182 · Llano, CAThe pilot's failure to attain an adequate airspeed and his intentional aerodynamic stall, which resulted in an impact with terrain and a post-impact fire.Jul 3, 2016 · N1642T · DestroyedNTSB ERA16FA238Accident · 1 fatalField investigationFinal reportGerdts Mark E RV7A · Weston, FLThe pilot's loss of airplane control for reasons that could not be determined based on the available evidence.Jul 3, 2016 · N1075F · DestroyedNTSB ERA16CA241Accident · No injuriesData collectionFinal reportCessna 305 · Shirley, NYThe pilot's failure to maintain directional control while landing. Contributing to the accident was the pilot's decision to accept an advised runway rather than determine actual airport winds, which resulted in the airplane landing with a quartering tailwind.Jul 3, 2016 · N12633 · Substantial damageNTSB CEN16LA255Accident · Minor injuriesLimited investigationFinal reportPiper PA 25-235 · Arlington, WIThe pilot’s failure to establish proper airspeed and angle-of-attack during takeoff with the airplane at its maximum gross weight in elevated density altitude and gusting tailwind conditions, which resulted in an aerodynamic stall.Jul 3, 2016 · N6803Z · Substantial damageNTSB CEN16LA244Accident · No injuriesLimited investigationFinal reportPollack Quicksilver SPRINT2S · Bullard, TXA loss of airplane control during landing for reasons that could not be determined, because the airplane sank and was not recovered.Jul 3, 2016 · N250AB · Substantial damageNTSB WPR16LA134Accident · No injuriesLimited investigationFinal reportBell OH 58A · Brawley, CAThe engine's degraded performance due to excessive wear of the engine bleed valve, which prevented it from closing during the accident flight. Contributing to the accident was the operator's failure to overhaul the bleed valve within the…Jul 2, 2016 · N6251G · Substantial damageNTSB WPR16LA133Accident · No injuriesLimited investigationFinal reportCessna 172 · Salmon, IDA loss of engine power due to water in the fuel system. Contributing to the accident was an inadequate preflight inspection that failed to eliminate water from the fuel system.Jul 2, 2016 · N7748U · Substantial damageNTSB GAA16CA360Accident · No injuriesData collectionFinal reportCessna 172 · Pembroke Pines, FLThe student pilot's failure to maintain directional control during the landing flare, which resulted in a runway excursion, and impact with a sign.Jul 2, 2016 · N65645 · Substantial damage