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 BFO90LA051Accident · No injuriesLimited investigationFinal reportCessna 172P · Chesterfield, VAThe student pilot's improper compensation for wind conditions and failure to maintain runway alignment.NTSB ATL90TL#02Accident · 1 fatalClass 3Final reportHughes TH-55 · Brantley, ALNTSB ATL90IA124Incident · No injuriesIncident investigationFinal reportDouglas DC-9-31 · Atlanta, GAFailure of the ac cross tie relay, which prevented the generators from being reconnected to the electrical system. A factor in the incident was the loss of the left generator in flight. Factors include inadvertently disconnecting the left generator while…NTSB ANC90LA078Accident · No injuriesLimited investigationFinal reportChampion Aeronca 7DC · Elmendorf, AKFailure of the pilot to properly tie down and chock the aircraft and/or obtain proper assistance, and his failure to properly set the throttle, while hand propping to start the engine.NTSB ANC90FA079Accident · No injuriesField investigationFinal reportCessna 195 · Anchorage, AKThe pilot's failure to follow wake turbulence avoidance procedures.NTSB SEA90LA089Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Ketchikan, AKThe pilot did not adequately compensate for the cross wind conditions while taxiing and failed to maintain clearance between the airplane and a tree on the shoreline. The crosswind was a factor related to the accident.NTSB SEA90LA088Accident · Minor injuriesLimited investigationFinal reportde Havilland DHC-2 · Chatham, AKThe total loss of engine power for undetermined reasons.NTSB LAX90LA204Accident · No injuriesLimited investigationFinal reportRobinson R22A · Torrance, CAThis accident was a dynamic roll over due to the right skid encountering soft soil during the forced landing.NTSB LAX90LA203Accident · No injuriesLimited investigationFinal reportRobinson R22 · Corona, CAThe student pilot's failure to maintain directional control, failue to maintain correct rotor RPM, and improper use of the flight controls.NTSB LAX90LA194Accident · No injuriesLimited investigationFinal reportCessna 152 · Atwater, CAThe pilot flared the airplane too high and improperly recovered from the bounced landing. Contributing to this accident was the pilot's improper use of the normal brakes and the soft terrain.NTSB FTW90FA111Accident · No injuriesField investigationFinal reportSchweizer 269C · Tallulah, LALoss of control due to a multiple bird strike and incorrect control inputs by the pilot in the flare. Contributing factors were the bird strike induced vibrations and the main rotor blade contact with the tail rotor drive shaft.NTSB CHI90LA142Accident · No injuriesLimited investigationFinal reportCessna 150F · Holland, MIThe pilot's inadequate compensation for wind conditions. The gusty crosswind was a related factor.NTSB CHI90LA141Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Plainfield, ILThe pilot's failure to insure that the landing gear was extended and locked prior to touchdown.NTSB BFO90FA050Accident · 4 fatalField investigationFinal reportRockwell 114 · Anawalt, WVFailure of the pilot to maintain proper altitude and clearance above the terrain. Factors related to the accident were: darkness, mountainous terrain, and low ceiling.NTSB NYC90FA117Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Rome, PAAn inflight loss of control due to spatial disorientation. Contributing to the accident was the pilot's lack of an instrument rating, and his decision to make the flight after receiving three separate briefings where he was told 'VFR flight not recommended.'NTSB MKC90LA116Accident · 1 fatalLimited investigationFinal reportRollins-Bowers FLY Baby 1A · Bemidji, MNThe wing attachment bolts were not installed resulting in inflight wing separation.NTSB LAX90LA200Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Cucamonga, CAThe pilot's continuing VFR flight into instrument meteorological conditions resulting in collision with terrain.NTSB LAX90LA199Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Sacramento, CAThe instructor pilot's failure to follow the aircraft manufacturer's checklist by neglecting to apply full carburetor heat at low power settings.NTSB CHI90LA139Accident · No injuriesLimited investigationFinal reportBeech B-55 · Detroit, MIThe pilot in command's execution of a turn shortly after takeoff resulting in loss of engine power due to fuel starvation and the pilot in command's execution of a turn back to the airport resulting in fuel starvation of the second engine which resulted in a…NTSB NYC90LA121Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Clayton Lake, METhe pilot's delayed decision to perform a go around.NTSB NYC90LA116Accident · Serious injuriesLimited investigationFinal reportStinson 108-1 · Athens, NYInflight loss of control due to loss of airspeed and subsequent stall when the pilot's seat back failed and the pilot hung onto the control wheel, resulting in an excessive nose high attitude.NTSB NYC90LA115Accident · Serious injuriesLimited investigationFinal reportSchweizer 1-26E · Wallkill, NYThe pilot's failue to maintain flying speed which resulted in a stall. A factor was the pilot's diversion of attention.NTSB NYC90LA114Accident · Minor injuriesLimited investigationFinal reportRolladen-Schneider Lsif Sailplane · Mayville, NYJammed flight controls in flight due to a bent aileron push-rod.NTSB NYC90LA113Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Rumford, METhe pilot made a steep turn to avoid the shore line and inadvertently stalled. Factors related to the accident were: the pilots decision to takeoff with a canoe strapped to one of the floats and his lack of experience in carrying a canoe on the floats.NTSB MIA90LA136Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Bunnell, FLThe dual students failure to flare properly during a simulated forced landing. Contributing to the accident was the failure of the flight instructor to properly monitor the student during the simulated forced landing.NTSB MIA90FA135Accident · Minor injuriesField investigationFinal reportCessna T303 · Deland, FLThe chafed and shorted electrical wiring between bus bars, which caused a partial electrical failure, resulted in a false fire warning indication, and prevented the restart of the right engine.NTSB LAX90WA201Accident · Minor injuriesForeign investigationCessna 182 · Luzon Island, PhilippinesNTSB LAX90LA198Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Glendale, AZFuel exhaustion. Resulting from the pilot's failure to perform refueling.NTSB LAX90LA197Accident · Minor injuriesLimited investigationFinal reportMooney M20A · Apache Junction, AZFailure of the pilot in command to properly manage the aircraft fuel quantity gauge indication and failure to complete the proper emergency procedure by switching fuel tanks. Contributing to the accident was improper maintenance performed by the pilot which…NTSB DEN90LA118Accident · No injuriesLimited investigationFinal reportCessna 310 · Ogden, UTThe failure of the main gear locking mechanism.NTSB CHI90LA138Accident · No injuriesLimited investigationFinal reportCessna 152 · Bad Axe, MIFailure of the pilot to abort the takeoff with sufficient runway to stop the aircraft. Contributing to the accident is a lack of total flying experience.NTSB CHI90LA137Accident · No injuriesLimited investigationFinal reportBeech A-23-19 · Stow, OHFailure of the pilot to attain runway alignment and maintain directional control after touchdown. Contributing to the accident was his landing at the wrong airport.NTSB CHI90LA135Accident · No injuriesLimited investigationFinal reportCessna 150F · White Cloud, MIFailure of the pilot to maintain control of the airplane during a landing flare and touchdown. The pilot's lack of total aviation experience is a factor in the accident.NTSB ANC90LA077Accident · No injuriesLimited investigationFinal reportCessna 185 · Northway, AKThe pilot lost control of the airplane during the post-landing taxi.NTSB SEA90FA086Accident · 3 fatalField investigationFinal reportRockwell Commander 114 · Atlanta, IDPoor preflight planning premature lift-off on takeoff by the pilot in command.NTSB NYC90DNA03Accident · No injuriesFinal reportBataller Kitfox · Marlboro, MAThe undetermined loss of engine power.NTSB MKC90MA115Accident · 2 fatalMajor investigationFinal reportPiper PA-46-310P · Naylor, MOThe pilot's failure to activate the pitot heat before flying in instrument meteorological conditions (IMC) above the freezing level, followed by his improper response to erroneous airspeed indications that resulted from blockage of the pitot tube by…NTSB FTW90LA110Accident · Serious injuriesLimited investigationFinal reportAdams A60S · Austin, TXImproper planning/decision by the pilot. The unfavorable wind and obstacles were related factors.NTSB CHI90LA178Accident · No injuriesLimited investigationFinal reportCessna 182 · Rich Hill, MOInadequate landing flare by the pilot.NTSB CHI90DEP04Accident · Serious injuriesFinal reportGoss KR-2 · Kenosha, WIFailure of the pilot to maintain control of the aircraft, while flying it with a laterally imbalanced condition. Factors related to the accident were: the pilot's lack of flying experience, and his lack of familiarity with this aircraft.NTSB ATL90LA122Accident · No injuriesLimited investigationFinal reportCessna 177 · Hazard, KYFailure of the pilot-in-command to execute a go-around, when an updraft caused the aircraft to be high on final.NTSB ATL90FA120Accident · 1 fatalField investigationFinal reportHispano Aviacion HA-200 · Tuskegee, ALImproper in-flight planning/decision by the pilot, and his failure to maintain altitude and clearance above the terrain, while perfoming low altitude, inverted flight. Factors related to the accident were: the lack of visual perception to the pilot at dusk…NTSB ATL90DKJ04Accident · No injuriesFinal report67 Flying Dutchman D1/LFD-13 · Tuscaloosa, ALMaintenance personnel who performed an improper modification of the propeller blade.NTSB NYC90LA112Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Lyons, NYA worn out brake on the left main gear. Factors related to the accident were: the owner's decision not to repair the left brake after the right brake had a similar failure 4 hours earlier.NTSB MKC90LA118Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Morton, ARThe pilot's failure to maintain directional control due to inadequate compensation for wind conditions.NTSB MIA90LA134Accident · Minor injuriesLimited investigationFinal reportAyres S2R-600 · Vero Beach, FLThe operation of the airplane with an unairworthy propeller by the operator.NTSB LAX90FA202Accident · No injuriesField investigationFinal reportRobinson R22B · Payson, AZControl interference which the CFI encountered during landing flare. Contributing factors related to the student not understanding communications from the CFI, the unclear language and the operator's inadequate certification of the airman.NTSB LAX90DUG06Accident · No injuriesFinal reportSabelino KR-2 · Chino, CAFailure of the brake system for undetermined reasons resulting in the pilot losing directional control during landing and veering off the runway.NTSB FTW90LA109Accident · No injuriesLimited investigationFinal reportCessna 172XP · Leona, TXEngine power loss due to a totally obstructed air intake manifold. Contributing to the accident was the unsuitable terrain in which the forced landing had to be performed.NTSB DEN90LA117Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Morgan, UTPilot's improper use of the brakes during landing roll.