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 LAX88FA094Accident · 2 fatalField investigationFinal reportCessna 172 · Temple City, CAPilot of N63CA improper visual look-out. Contributing to this accident was the controller's failure to observe the faster moving airplane approaching the single engine Cessna from the rear.NTSB CHI88LA055Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Barron, WIThe pilot misjudged altitude and distance and touched down short of the runway and struck a snowbank. Pax stated that the pilot cut pwr about 200 ft from the runway; the aircraft began to sink fast. The pilot applied power too late to prevent the undershoot.…NTSB SEA88FA039Accident · 3 fatalField investigationFinal reportBeech B23 · Hamer, IDThe two non instrument rated pilots (owner/pilot in command and second pilot) as well as a passenger departed medicine hat, alberta, Canada, on a pleasure flight to las vegas, Nevada. Upon arrival at great falls, Montana, both pilots were briefed on the…NTSB MIA88T#A01Accident · No injuriesClass 3Final reportPiper PA-31-350 · Jacksonville, FLNTSB DEN88LA057Accident · No injuriesLimited investigationFinal reportCessna 172N · Duchesne, UTThe student plt was performing a cross country training flight. At his first stop, during the takeoff portion of a touch and go landing, the aircraft swerved to the left and struck a three foot snow bank on the left side of the runway. The plt reported that…NTSB FTW88IA052Incident · No injuriesIncident investigationFinal reportDassault-Breguet DA-10 · Dallas, TXThe flight experienced in-flight fire resulting from an electrical short in an auxiliary circuit breaker panel installed after aircraft manufacture. The short resulted from the use of a mounting bracket that chafed against the input wires. The flightcrew…NTSB BFO88LA015Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Danville, VAEngine power loss occurred when the acft was in the traffic pattern. The plt made a forced landing in an open field about 2 miles from the airport. The investigation disclosed less than 1 gal of fuel in the selected rt tank.NTSB SEA88LA037Accident · No injuriesLimited investigationFinal reportCessna 172P · Vashon Island, WADuring landing roll the pilot made an intentional groundloop to avoid trees at the end of the short, wet, S0D runway. The pilot reported that the use of brakes was ineffective. He stated that he made the landing using 30 degs of flaps at an airspeed of 60…NTSB NYC88IA067Incident · No injuriesIncident investigationFinal reportMitsubishi MU-2B-35 · Teterboro, NJThe MU-2 made a departure and while climbing through approximately 800 ft AGL, there was an inadvertent auto-pilot engagement. The nose pitched down and right. Both pilots got on the controls and control was maintained. A normal landing was made at the point…NTSB MKC88LA044Accident · No injuriesLimited investigationFinal reportCessna 206 · Wichita, KSDuring a night ldg with strong gusty x-winds, the PIC lost control during the roll out and careened off the runway substantialy damaging the acft. The PIC stated the windshield was partially coated with ice making forward visibility difficult.NTSB MKC88FA043Accident · Minor injuriesField investigationFinal reportAerospatiale AS-350B · Omaha, NEThe pilot picked the aircraft up to a hover and made a hovering turn in preparation for departure. The nose of the aircraft began to rise. The pilot stated later that he could not control the aircraft. The aircraft began to descend and the tail rotor struck a…NTSB MKC88FA042Accident · 1 fatalField investigationFinal reportGulfstream 500B · Pierceville, KSThe acft dptd garden city under extremely poor wx cond's. more than half way to dodge city, the PIC rptd eng pblms to Kansas city (ARTCC). Vectors were provided to the dodge city arpt, but the PIC did not maintain assigned hdgs. The acft headed back towards…NTSB MIA88LA091Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-301 · Port Saint Joe, FLWhile on a business flt, unable to locate the landing site with darkness approaching & low supply of fuel, the plt performed a precautionary landing on a soft dirt road. During the landing roll the acft nosed over & came to rest. The plt did not file an acc…NTSB LAX88LA092Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Lakeport, CADuring ldg rollout the acft veered off the rwy, went into a ditch & collided with terrain causing substantial damage. The surface winds were estimated at only 5 KTS. The plt acknowledged that the accident might have been prevented if he had been less…NTSB FTW88LA075Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS-355-F1 · Grand Prairie, TXThe acdt occurred on the 2nd flt of transition trng for an experienced helicopter plt. The trng on this flt included sim tail rotor failure run-on landings. The CFI demonstrated 2 landings and the trainee took the controls for the 3rd. The landings were being…NTSB FTW88IA055Incident · No injuriesIncident investigationFinal reportSwearingen SA227-AC · College Station, TXThe aircraft's nose gear struck a deer during the takeoff roll and the takeoff was aborted. The aircraft taxied back to the terminal and was examined by the flight crew. No damage was found. It then departed on its scheduled flight. It flew 18 flights during…NTSB DEN88LA056Accident · No injuriesLimited investigationFinal reportCessna 150M · Delta, UTDuring the landing roll, the acft swerved to the right into a snowbank and nosed over. The plt said he found snow packed between the landing gear wheel and wheel pants restricting the wheel from rotating. In his recommendation for prevention, the plt stated…NTSB DCA88MA017Accident · 9 fatalMajor investigationFinal reportFairchild SA-227AC · Bayfield, COThe aircraft was operating as Continental express flight 2286. During the approach in IFR conditions, the aircraft went below the minimum descent altitude then struck the terrain at 7180 feet MSL. Exam of the aircraft did not disclose any pre-impact failures…NTSB CHI88FA048Accident · Serious injuriesField investigationFinal reportBoeing 767-200 · Chicago, ILA flight attendant and a passenger received serious and minor injuries respectively during an inflight encounter with severe turbulence during an enroute descent. Greater than moderate turbulence was forecast to be in the area and severe turbulence had been…NTSB ATL88LA101Accident · No injuriesLimited investigationFinal reportRockwell 112A · Juliette, GAThe airplane struck a transmission cable over a river at about 100 ft AGL. The plt rptd that he inadvertently stalled the airplane while turning to reverse direction during an aerial photo flt, and that he felt a 'bump' during recovery. After returning to the…NTSB ATL88LA083Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-6-200 · Charlotte, NCDuring the final approach on the instrument landing system, the pilot descended below the glidepath. The aircraft collided with a tree and struck the ground short of the runway threshold.NTSB SEA88LA038Accident · No injuriesLimited investigationFinal reportCessna 150M · Port Angeles, WADuring cruise the pilot noticed a gradual loss of RPM. Carburetor heat was applied but the pilot stated that he noted no improvement in the engine power. The power loss continued to deteriorate so a landing was made onto a rough field where the nose gear…NTSB MKC88FA041Accident · 1 fatalField investigationFinal reportPiper PA-31T-620 · Hazelwood, MOProper glide path not maintained by p.I.c., decision height not identified by the p.I.c., missed approach not performed by the p.I.c. turning on lights in overcast.NTSB MKC88DPG01Accident · 1 fatalFinal reportMeyer VARI-EZE · Little Rock Afb, ARPilot received a wx briefing and was told VFR was not recommended. The pilot did not file a flight plan and flew an aircraft not equipped for IFR into weather with 100-feet obscured ceiling and .3 mile visibility. The aircraft crashed into the ground at a…NTSB MIA88LA090Accident · Serious injuriesLimited investigationFinal reportDouglas DC-9-82 · Hickman, KYThe capt left the seat belt sign on after takeoff. The flight attendants made a followup announcement for the passengers to remain seated and keep their seatbelts fastened due to the turbulence they were encountering. A passenger elected to get up from her…NTSB CHI88IA045Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-42 · Waterloo, IANTSB ATL88FA082Accident · Serious injuriesField investigationFinal reportPiper PA-23 · Augusta, GANTSB MIA88LA089Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · San Juan, PRThe pilot, while on an on-demand air taxi flight, switched to an empty fuel tank in preparation for landing and the engine failed. The pilot then executed a forced landing to the grass short of the runway and the landing gear failed.NTSB LAX88LA096Accident · No injuriesLimited investigationFinal reportCessna 402C · Prescott, AZNTSB LAX88LA091Accident · No injuriesLimited investigationFinal reportAerospatiale SA-341G · Bowie, AZNTSB FTW88MA048Accident · 1 fatalMajor investigationFinal reportHawker Siddeley 125-600A · Houston, TXBfr tkof, a plt of xa-kut was briefed that the Houston hobby (hou) wx was IFR with '. . . Indefinite ceiling zero sky obscured visibility's 1/16 of a mile and fog . . .' He was also adzd IFR conds were forecast until 0900 CST, gradually improving to marginal…NTSB FTW88LA167Accident · Serious injuriesLimited investigationFinal reportAdams A-60 · Austin, TXThe balloon was deflated by the passenger when he pulled the crown line. Contributing to this was the pilot's poor judgement in relinquishing the line to the passenger.NTSB FTW88LA053Accident · No injuriesLimited investigationFinal reportBeech V35B · Temple, TXThe pilot failed to execute a missed approach when he descended through decision height.NTSB DEN88LA055Accident · Minor injuriesLimited investigationFinal reportCessna 402 · Albuquerque, NMThe ATP rated plt and a commercial rated passenger were taking a scheduled cargo flight from Albuquerque to las cruces, new Mexico. The runway was covered with snow, ice and water from a snow storm the previous night. It was snowing lightly at the time of the…NTSB CHI88LA044Accident · No injuriesLimited investigationFinal reportBeech A36 · St Paul, MNNTSB CHI88FA046Accident · 3 fatalField investigationFinal reportPiper PA-23-250 · Carbondale, ILShortly after reporting the outer marker while executing an ILS runway 18 approach in actual instrument meteorological conditions, the aircraft deviated left of the localizer centerline. At a position approximately 1/2 mile outside the middle marker and about…NTSB ATL88FA081Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Barnardsville, NCNTSB SEA88LA035Accident · No injuriesLimited investigationFinal reportCessna 172 · Everett, WAThe student pilot had landed with full flaps prior to the application of full power for takeoff. The aircraft veered to the left side of the runway into mud and nosed over inverted. The aircraft's flap indicator had been placarded inoperative by the operator.NTSB NYC88LA066Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Stowe, VTThe Cessna 210 took off and shortly thereafter experienced a loss of power. The pilot was unable to get the engine restarted and made an off-airport landing in a grove of trees. On-scene examination by the FAA showed that the fuel selector was on the left…NTSB MKC88FA040Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Creve Coeur, MOWitnesses stated that the aircraft suddenly started a vertical climb from a straight and level flight attitude. The airplane lost momentum while in the climb, then it nosed down and dove towards the ground. It exploded upon impact and was destroyed in the…NTSB MIA88FA088Accident · Serious injuriesField investigationFinal reportChristen Industries A-1 · Pompano Beach, FLThe plt stated that as he pushed the control stick forward in an attempt to raise the tail, the acft violently pitched up, stalled and broke right, the right wing struck the ground, & the acft rolled over & came to rest inverted. Post crash examination of the…NTSB LAX88LA090Accident · Serious injuriesLimited investigationFinal reportAero Commander 200D · Chico, CAAt the end of a cross country flt, while in the pattern turning from base to final, the plt stated that the arpt environment was lost. At the same time, the instrument white lights, under the glareshield began to flicker which drowned out the normal…NTSB LAX88LA089Accident · Serious injuriesLimited investigationFinal reportRobinson R22 · Sun City, AZNTSB LAX88FA088Accident · 4 fatalField investigationFinal reportCessna 182L · Newhall, CAPilots decision to continue VFR flight after encountering instrument meteorological conditions.NTSB DEN88FA054Accident · 3 fatalField investigationFinal reportGulfstream American AA-5A · Elbert, COThe acft collided with slightly rising terrain with the rt wing slightly down and the nose attitude level. Following the first contact, the acft skipped about 90 ft and the 2nd impact was in a more pronounced rt wing low and nose down attitude. The canopy was…NTSB ANC88LA026Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Iliamna, AKThe pilot was maneuvering at low altitude in low visibility when he encountered a complete white-out condition. The pilot lost control in flight and crashed on a frozen lake.NTSB MIA88LA087Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Tampa, FLDuring the landing roll the acft veered off the rwy, travelled through a retention pond, nosed over & came to rest. According to a plt who landed shortly after the accident, he had his hands full landing on the same rwy due to a 'stiff crosswind'. The pilot…NTSB LAX88FA087Accident · 1 fatalField investigationFinal reportCessna T210N · Lost Hills, CAOn a dark night with light drizzle falling the pvt plt, who was not instrument rated, departed from an uncontrolled arpt for a x-c flt. The plt made a downwind departure, & his altitude on the x-wind leg was estimated by a passing truck driver at 200 ft AGL.…NTSB FTW88LA049Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Littlefield, TXThe connecting rod cap attaching bolt failed in flight which caused the engine to stop. The pilot was on final approach at the time but was unable to reach the runway. A forced landing was made in a farm field short of the airport. Upon touchdown the aircraft…NTSB CHI88LA049Accident · No injuriesLimited investigationFinal reportCessna 172L · Buffalo, MN