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.
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
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 MIA90LA122Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Daytona Beach, FLThe failure of the pilot of the tailwheel equipped airplane to maintain a visual lookout while taxiing.NTSB LAX90LA175Accident · No injuriesLimited investigationFinal reportPiper PA23-160 · Flagstaff, AZThe failure of the pilot to maintain directional control and to feather the propeller. A factor was erratic power from the left engine due to the jamming of the fuel selector valve in an intermediate position.NTSB LAX90LA174Accident · Minor injuriesLimited investigationFinal reportCessna 172 · California City, CAThe pilot's improper landing flare. A factor related to accident was the gusty wind condition.NTSB NYC90LA109Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Warehouse Point, CTThe pilot failed to maintain directional control during a landing with a gusty crosswind.NTSB NYC90LA108Accident · No injuriesLimited investigationFinal reportCessna 172M · Granville, NYThe improper recovery from a bounced landing which resulted in loss of control and collision with a ditch.NTSB MKC90LA117Accident · Serious injuriesLimited investigationFinal reportBell 47G · Wynne, ARLanding gear skid entangled with a fuel hose. A factor was the pilot's inadequate preflight inspection.NTSB MKC90FA107Accident · No injuriesField investigationFinal reportBeech A35 · Washington, MOImproper static balance of the ruddervators following rebuilding/repainting, which resulted in empennage flutter.NTSB MIA90WA121Accident · No injuriesForeign investigationBell 222-UT · Lavega, Dominican RepublicNTSB CHI90DEK04Accident · Minor injuriesFinal reportRobinson R-22 · St. Mary'S, OHThe pilot's failure to see and avoid wires in his operating area.NTSB ANC90LA068Accident · No injuriesLimited investigationFinal reportArtic Interstate S1B1 · Talkeetna, AKFuel contamination which precluded the engine from developing the necessary power to clear the mountain ridge.NTSB SEA90LA077Accident · No injuriesLimited investigationFinal reportPiper PA-15 · Wenatchee, WAThe pilot's failure to maintain directional control during landing.NTSB NYC90FA106Accident · 1 fatalField investigationFinal reportCessna 150H · Shirleysburg, PAPilot incapacitation due to a heart attack.NTSB MIA90LA120Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Marathon, FLFailure of the input drive gear of the tail rotor gear box for undetermined reasons because the drive gear was not recovered from the ocean.NTSB LAX90FA170Accident · 1 fatalField investigationFinal reportBell 206B · Carmel Valley, CAThe pilot's inadequate visual lookout and improper climb.NTSB FTW90DRD08Accident · No injuriesFinal reportSchweizer G-164B · Basile, LAThe pilot's inadequate evaluation of the weather information. A related factor to the accident was the tailwind.NTSB BFO90LA042Accident · No injuriesLimited investigationFinal reportBell 47D · Baltimore, MDThe pilot applied excessive cyclic control, causing the main rotor to flex and severe the tail cone.NTSB NYC90GA105Accident · 4 fatalFinal reportBellanca 17-31A · Davis Park, NYThe airplane impacting the water at a high speed for unknown reason(s).NTSB NYC90DHJ01Accident · 1 fatalFinal reportToussaint/Quad City Challenger II · East Moriches, NYFailure of the unlicensed pilot to maintain airspeed on final approach, which resulted in a stall and collision with the ground. Factors related to the accident were: the pilot's lack of flight training, experience, and qualification.NTSB LAX90LA173Accident · No injuriesLimited investigationFinal reportBeech N35 · Los Banos, CAThe pilot's failure to maintain directional control of the aircraft during the takeoff roll.NTSB LAX90LA172Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Mesa, AZThe pilot-in-command's failure to maintain safe airspeed and inadvertent stall. Contributing to the accident was the pilot's misjudging fuel supply.NTSB CHI90LA127Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Anderson, INThe pilot-in-command failed to select the fuel valve to a tank containing usable fuel resulting in fuel starvation.NTSB ANC90LA069Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Goose Bay, AKLoss of control by the student pilot by prematurely attempting to maneuver the airplane.NTSB NYC90FA104Accident · No injuriesField investigationFinal reportShort Brothers SD3-60-200 · Jamaica, NYPilot factor in that the pilot taxied into a hold position that was too close to a departing B-747, which resulted in the a/c being blown into a blast fence. Contributing was the lack of available information from the aircraft manufacturer which would have…NTSB MIA90TL#04Accident · Minor injuriesClass 3Final reportHughes TH-55 · Isle Of Capri, FLNTSB MIA90LA119Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Shelby, MSThe pilot's inadequate preflight planning and attempted flight with insufficient fuel on board to complete the flight.NTSB LAX90LA171Accident · No injuriesLimited investigationFinal reportHughes 369E · Firebaugh, CAFailure by company maintenance to perform a mandatory compressor section inspection that resulted in the undetected erosion of the compressor vanes and engine failure. Contributing to the accident was the failure of the pilot to maintain adequate main rotor…NTSB LAX90LA169Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · El Monte, CAThe failure of the pilot in command to adequately configure the aircraft for the takeoff portion of a touch and go.NTSB CHI90LA133Accident · No injuriesLimited investigationFinal reportChampion 7EC · Hamilton, OHFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve.NTSB BFO90LA043Accident · Serious injuriesLimited investigationFinal reportBoeing B-737 · Washington, DCThe aircraft encountered turbulence, resulting in injury to a flight attendant.NTSB ATL90LA112Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Chamblee, GAFailure of the student (rated) pilot to maintain control of the helicopter, and insufficient supervision by the instructor pilot (CFI).NTSB MIA90FA118Accident · 2 fatalField investigationFinal reportCessna 172K · Mayaguez, PRThe pilot's failue to conduct proper preflight preparations, resulting in a takeoff at 175 pounds over maximum allowable gross weight, with full flaps extended, and on the improper runway for wind conditions which resulted in the airplane being unable to…NTSB DEN90LA108Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Powderville, MTPilot failed to maintain terrain clearance during descent on an aerial application swath run, resulting in an in flight collision with the terrain. That the pilot misjudged the pull up altitude is considered a contributing factor.NTSB CHI90LA125Accident · No injuriesLimited investigationFinal reportPiper PA22-150 · Akron, OHPilot's failure to maintain aircraft control while taxiing in gusty crosswind conditions.NTSB BFO90FA045Accident · 6 fatalField investigationFinal reportCessna 210N · Shady Grove Cor, VAVFR flight by the non-instument rated pilot into instrument meteorological conditions (IMC), his loss of aircraft control, due to spatial disorientation, and his exceeding the design stress limits of the aircraft, while recovering from an uncontrolled…NTSB MIA90FA117Accident · Minor injuriesField investigationFinal reportHughes 269C · Fort Pierce, FLImproper touchdown during the autorotation by the dual student (ATP), his failure to maintain runway alignment, inadequate supervision by the CFI, and inadequate crew coordination. A factor related to the accident was the obstruction (taxiway light).NTSB LAX90LA168Accident · No injuriesLimited investigationFinal reportRobinson R22 · Irvine, CAThe cfi's failure to maintain rotor RPM during the practice autorotation.NTSB ATL90FA111Accident · 1 fatalField investigationFinal reportCessna P206 · Liberty, NCA loss of engine power due to improper repairs to, and inadequate inspection of, the induction air box. The night light condition was a contributing factor.NTSB SEA90LA073Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Newberg, ORThe pilot did not maintain directional control duing the landing.NTSB NYC90LA103Accident · No injuriesLimited investigationFinal reportRobinson R22 · Millville, NJThe student pilot's improper use of the flight controls, and inadequate supervision of the flight by the instructor (CFI). Contributing to the accident was the lack of total time and experience of both the student and instructor.NTSB NYC90LA102Accident · No injuriesLimited investigationFinal reportCessna 152 · West Milford, NJImproper planning/decision by the flight instructor (CFI). Related to the accident was the cfi's lack of experience as an instructor.NTSB NYC90DGM01Accident · Serious injuriesFinal reportAir Tractor AT-400 · Tyrone, PAThe pilot's failure to maintain adequate clearance from obstructions during low level aerial application operations. The pilot's inadequate visual lookout was a factor.NTSB LAX90DVG07Accident · Serious injuriesFinal reportGrumman G-164A · Gridley, CAFailure of the no.7 cylinder head which led to a forced landing and substantial damage to the aircraft when it nosed over after colliding with a ditch.NTSB FTW90LA107Accident · No injuriesLimited investigationFinal reportBell 206BIII · Kaplan, LARestricted movement of the right skid assembly causing the lateral center of gravity to be exceeded during the attempted take off.NTSB FTW90DPA03Accident · No injuriesFinal reportBell-Moore 47G-2A · Sivell Bend, TXClearance was not maintained by the pilot-in-command.NTSB DEN90LA107Accident · Minor injuriesLimited investigationFinal reportBeech B-55 · Watkins, COExecuting of a simulated single engine approach in wind conditions that exceeded the demonstrated crosswind capability of the airplane with both engines operating.NTSB DEN90DTK01Accident · 1 fatalFinal reportPiper PA-36-375 · Woonsocket, SDFailure of the pilot of N3634E to follow the briefed plan of operation, and failure of both pilots to see-and-avoid each other (inadequate visual lookout).NTSB CHI90LA124Accident · No injuriesLimited investigationFinal reportBeech A36 · Anderson, INThe pilot failed to adequately compensate for the wind conditions. The gusty crosswind was a factor.NTSB ATL90FA110Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Hilton Head, SCThe pilot's mismanagement of the fuel system through inadvertant selection of the 'off' position of the fuel selector valve handle.NTSB SEA90LA076Accident · 1 fatalLimited investigationFinal reportPiper PA-18-125 · Rogerson, IDThe pilot's intentional flight below safe altitudes while engaged in low-altitude 'buzzing' activities.NTSB SEA90LA075Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Pomeroy, WAA malfunctioning fuel injection system and the pilot's attempted operation above certificated maximum gross weight with a known deficiency in this equipment.