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 CHI85FA036Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · North Freedom, WIAt an early morning predeparture wx briefing the pilot was advised of deteriorating afternoon wx pilot flew cross country conducted business and departed late afternoon with no wx brief no flt plan departure area and destination both reporting IMC while…NTSB CHI85FA035Accident · 2 fatalField investigationFinal reportGulfstream 690C · Wooster, OHWhile on final approach to rwy 09 the acft struck a 42 ft power pole with the right wing. The wing was torn from the acft. The acft landed inverted 400 ft east of the pole. The rwy threshold lights are displaced 165 ft from the rwy end for night operations.…NTSB MIA85IA021Incident · No injuriesIncident investigationFinal reportPiper PA-60 · Jacksonville, FLThe acft swerved left off the rwy during the landing roll. An exam of the left main landing gear strut revealed that the collar had failed permitting the lower portion of the landing gear strut to shift. The shift was transmitted tothe tire causing it to…NTSB FTW85FA032Accident · Serious injuriesField investigationFinal reportBell 206B · Lane City, TXDuring cruise at 600 ft AGL a bang was heard & acft experienced a vibration. When turning toward a fld to land a second bang was heard & vibration ceased. However, an uncommanded rt yaw was experienced & the nose began to tuck under. Acft contacted terrain…NTSB CHI85FA034Accident · No injuriesField investigationFinal reportHughes 500D/369D · Mc Cordsville, INThe helicopter landed hard during an autorotative descent while on a test flt & chopped off the tail boom. The plt stated he lost power at 150 ft AGL & entered autorotation. Investigation revealed that the fuel quantity float had become intangled with the…NTSB ATL85LA024Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Lincoln, TNThe acft was making a swath run spraying crops when the engine suddenly lost power with 200 yards of level field remaining for an emergency landing. After touchdown the plt turned the acft to avoid a collision with trees. During the turn the nose of the acft…NTSB MKC85LA010Accident · No injuriesLimited investigationFinal reportAspen Quickie 2 · Grand Island, NEThe plt stated that he was practicing landings & had less than three hours total time in the Q2. He said he flared high & bounced three times. During the third bounce the front wing, to which the main landing gear is attached, broke & the acft ran off the…NTSB MIA85LA020Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA-315-B · West Bay, FLThe acft crashed following a loss of tail rotor control while on an external load agricultural flt. Witnesses stated that during a landing attempt at a loading area the acft started spinning, the ext load was jettisoned, and the acft hit the ground and rolled…NTSB MIA85LA019Accident · No injuriesLimited investigationFinal reportBeech 76 · Ft.Walton Beach, FLDuring takeoff on a multiengine instructioanl flt, the instructor (CFI) simulated an eng failure by retarding power on the left eng. The student elected to land on the remaining rwy. He retarded the right eng power & dove for the rwy, but the acft touched…NTSB FTW85LA030Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Terrell, TXAcft was substantially damaged during an autorotative landing after the plt heard a 'loud pop' from the rear of the helicopter. Investigation revealed the spines on the lower pulley shaft coupling were severly stripped.NTSB DEN85FA026Accident · 1 fatalField investigationFinal reportCessna 340 · Las Vegas, NMThe pilot was carrying illegal cargo (marijuana) in N4001Q. During a low high speed pass at night over an intended landing area,the aircraft struck rising terrain. There was approximately 800 lbs of marijuana on the aircraft.NTSB BFO85FA004Accident · 2 fatalField investigationFinal reportde Havilland DH 82 Tiger Moth · Keyser'S Ridge, MDThe flt was the final leg of a flt from winchester, VA that had been discontinued the day before due to adverse weather conditions. Two weather briefings were obtained on the day of the accident, both of which included the statement that VFR flight was not…NTSB NYC85FA015Accident · 2 fatalField investigationFinal reportEnstrom 280C · Butler, PAThe helicopter struck the static line of a high voltage transmission line while on a flt to photograph an apartment complex. The owner of the complex accompanied the plt on the flt, there after the acft was to be used for passenger sightseeing flts as part of…NTSB LAX85LA035Accident · No injuriesLimited investigationFinal reportBell 47-G2 · Castroville, CAAt the beginning of a swath run a total loss of power occurred. During the hard forced landing, the main rotor blades severed the tail boom. The helicopter fuel tanks were found empty after the accident.NTSB LAX85LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Firebird Lake, AZThe CFI reported that while flying in the flt school's designated practice area at 3800 ft MSL she reduced the throttle to idle for the purpose of simulating an in-flt emerg for her student. The student responded properly. The CFI stated she cleared the eng,…NTSB LAX85LA033Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Lower Lake, CAThe plt reported that he originally planned to start the acft eng in order to charge the battery. The eng started using the acft starter so the plt decided to fly. He set the parking brake & with the eng running at a 'fast idle', exited the acft, intending to…NTSB FTW85LA027Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Lipan, TXAcft experienced a partial eng failure in flight. During the forced landing, the nose gear dug into terrain and the acft flipped over. Investigation revealed that the no. 3 cyl barrel was cracked about 90% around the circumference. Metallurgical examination…NTSB DEN85LA022Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Longmont, COThe pilot stated that he encountered a strong gust of wind from the right and lost directional control. The acft struck the ground with the left wing tip and nose and flipped over.NTSB CHI85LA033Accident · No injuriesLimited investigationFinal reportCessna 172 · Chicago, ILThe pvt plt stated that he was aware of a nose wheel shimmy on the acft before flt but was advised by the operator that it was safe to fly. He stated that upon landing, when the nose wheel touched down, it began to shimmy violently and the nose tire blew.…NTSB CHI85LA030Accident · No injuriesLimited investigationFinal reportMoore Quicksilver MX II · Aurora, ILPlt landed in open field to tighten his scarf, which had become loose and posed a possible hazard. A second ultralight landed to see of the plt had problems, then departed toward the east, successfuly negotiating a 10 kt x-wind. Plt elected to takeoff in same…NTSB ATL85LA021Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Cumming, GADespite a fss forecast of thunderstorm activity for the next 24 hours the plt departed in order to evaluate wx situation for himself. Conditions were as forecasted and the plt elected to return to the arpt from which he had departed. Due to the movement of…NTSB ATL85FLT02Accident · Minor injuriesFinal reportCessna 177RG · White Mills, KYThe plt made a gear-up forced landing after experiencing a total loss of power during cruise flt. Post accident inspection of the aircraft revealed less than 12 ounces of fuel on board. Plt stated he did not visually check the fuel quantity on the day of the…NTSB ANC85LA014Accident · No injuriesLimited investigationFinal reportde Havilland Otter DHC-3 · Dan Creek, AKAccording to the plt the acft hit a downdraft, landed hard and struck the wing on the rwy surface. The wind was reported from 360 deg 15 KTS gusting to 20 KTS.NTSB NYC85LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Farmington, PAAccording to the plt, during the landing flare the wind shifted causing the acft to drift off the left side of the rwy striking rwy lights and a pole. Winds were from 230 deg at 10 KTS gusting to 15.NTSB LAX85LUQ01Accident · No injuriesFinal reportJack L. Bigham Bede 5B · Camarillo, CAThe plt was performing a go around when the prop drive failed. A forced landing was made on a soft fld adjacent to a taxiway during which the landing gear collapsed. Examination of the acft disclosed the prop drive belt laying in the fuselage.NTSB LAX85LA032Accident · No injuriesLimited investigationFinal reportCessna 152 · Fillmore, CAAccording to the pilot, unforecast wx was encountered in cruise at 6,500 ft. the student became lost and elected to make a precautionary landing in an unimproved field. The nose gear collapsed on touchdown and the acft nosed over coming to rest inverted. No…NTSB LAX85LA029Accident · No injuriesLimited investigationFinal reportBeech C24R · Montague, CAThe acft made a forced landing in a pasture and collided with a cow after the engine quit. The plt said he has noticed the landing gear in transit light come on at about 10 minute intervals during the flt. He said he had noticed a red fluid dripping from the…NTSB FTW85LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Cooper, TXLoss of pwr occurred in cruise flt, 25 NM before final destination, forced landing executed in soft muddy field and acft nosed over during landing roll. No fuel was found in fuel tanks. Plt stated he thought the acft had been topped off by FBO prior to his…NTSB FTW85LA026Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hinton, OKDuring takeoff on an instructional flt with a CFI aboard, the acft struck a grain wagon. The CFI stated that on takeoff, the student lifted off prematurely and the acft struck the parked vehicle. The CFI took no corrective action.NTSB FTW85FA025Accident · 1 fatalField investigationFinal reportCessna 180 · Amarillo, TXLast radio contact was a clearence to descend to 5,000 ft MSL to which the plt responded 'two romeo delta.' Cloud tops were near 5,000 ft MSL. Acft impacted in a high speed dive aprx 10 deg past verticle. Plt received com/inst certificate on 12/14/84 and this…NTSB DEN85LA021Accident · No injuriesLimited investigationFinal reportCessna 320B · Glen Canyon, UTOn takeoff roll, plt noted 5 inch difference in manifold pressure between the engs. Acft began to drift to the right. Plt applied corrective difference power, rudder and aileron to correct drift, but stated a gust of wind caused further right drift. Right…NTSB CHI85LA028Accident · Serious injuriesLimited investigationFinal reportSwift GC-1A · Fraser, MIAccording to the plt, he took off on rwy 18 & was climbing thru about 250 ft AGL when the eng lost power & he made a forced landing. However, a co-owner, who was on board, stated that the plt had retarded the throttle, then the acft stopped stopped climbing,…NTSB CHI85IA032Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10-30 · Chicago, ILShortly after takeoff, the flight crew heard a noise from the right side of the aircraft, which sounded like an engine compressor stall. The #3 engine was shut down & the crew made an uneventful landing at the departure airport. Pieces of cowling from the…NTSB CHI85FA031Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Joliet, ILA pvt plt invited a CFI to accompany the x-country flt because he was not instrument rated and marginal wx was forecast. On return trip from atlanta the CFI filed an IFR flt plan. During the flt, the rt fuel tank was run dry. Upon reaching the chicago area,…NTSB BFO85FA003Accident · No injuriesField investigationFinal reportPiper PA-23-250 · Washington, DCAfter a high & fast apch, acft touched down beyond midfield on rwy 36 at dca. Plt delayed initiating a go around until he was sure the acft would not stop in the rwy remaining. On initial climb the acft struck two apch lights at the departure end of the rwy,…NTSB ATL85LA023Accident · Minor injuriesLimited investigationFinal reportFour Seasons Aviations American Aerolight · Springville, ALAt aprx 150 ft the plt heard a noise and observed a fire involving the rear portion of the acft. The plastic fuel tank ruptured and burning fuel was sucked aft through the pusher prop. The ballistic parachute was deployed and opened as the acft hit a 60 ft…NTSB ANC85LA013Accident · No injuriesLimited investigationFinal reportMaule M-6 · Homer, AKShortly after touchdown the acft veered left. Right rudder was applied causing the acft to over correct back to the right. In an effort to regain directional control left rudder was applied. The acft ground looped to the right collapsing the left main landing…NTSB NYC85FA014Accident · 2 fatalField investigationFinal reportCessna 150M · Providence, RIAcft collided with the waters of narragansett bay at a location aprx 1 mile from boys town arpt (destination of record),in water aprx 8 ft deep. The wx was IMC at departure (1845 EDT) and the ATP instrument rated plt had requested and been granted a special…NTSB MKC85LA009Accident · No injuriesLimited investigationFinal reportPiper PA32RT-300T · Columbia, MOThe plt was high on the ILS approach and flew a VFR very low circling approach after clearance to change from rwy 2 to rwy 20. The tower controller said the acft was so low that at one point he lost sight of the acft. He advised the plt that he appeared to be…NTSB MIA85LA018Accident · No injuriesLimited investigationFinal reportCessna 172P · Titusville, FLThe acft landed in a field after experiencing an eng failure in cruise flt. Investigation revealed the accident occurredon the return leg of a x-country flt. The plt stated he visually checked the acft fuel tanks prior to departure and estimated ample fuel…NTSB FTW85LA029Accident · No injuriesLimited investigationFinal reportDouglas DC3C · El Paso, TXDue to low oil pressure and high oil temp the right eng was secured. During the precautionary landing gear extension was delayed until aprx 800 ft AGL. Since the right eng powers the only hydraulic pump a landing gear down and locked condition was not…NTSB FTW85LA024Accident · 1 fatalLimited investigationFinal reportBeech 58P · Beeville, TXWhen the plt called the fss at 1426 EDT & filed an IFR flt plan, the fss person began providing a wx briefing. The plt interrupted the wx briefing & said he would check back later. He called back at 2016 EDT, but talked to another briefer & only asked for…NTSB FTW85IA028Incident · No injuriesIncident investigationFinal reportSwearingen SA226TC · Tulsa, OKDuring cruise, the crew experienced a loss of hydraulic pressure & smoke in the cockpit, then donned their oxygen masks. They used the emerg gear extension system & made a safe emerg landing. An exam revealed a cracked 2000 PSI aluminum hydraulic line had…NTSB DEN85LA020Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA316B · Lima, MTAprx 35 min prior to the accident the seismic operations being conducted about 10 mi NE were secured due to poor visibility and high winds. The plt estimated wind to have been from 180 deg at 40 KTS gusting to 60. As the plt approached the landing zone…NTSB CHI85LA029Accident · No injuriesLimited investigationFinal reportLight Aero Avid Flyer 1 · Allegan, MIPlt stated he noted a momentary flutter in the right flaperon while in cruise at 80 KTS. He then heard a bang and looking at right wing, observed at least two of the outboard flaperon hinge attachments had broken. The acft then entered a 30-degree right bank…NTSB ATL85LA022Accident · No injuriesLimited investigationFinal reportBeech 95 · Birmingham, ALPlt reported apch was high and fast but when the nose gear touched down during the normal landing, the nose gear tire blew. A witness stated the acft porpoised several times and then impacted on the nose gear resulting in the blown out tire.NTSB ANC85FA012Accident · No injuriesField investigationFinal reportMaule M-6-235 · Kenai, AKThe acft bounced twice at a point about 1000-1500 ft down the rwy and then started to ground loop according to a witness. During the ground loop the acft pitched up and climbed steeply to about 40 ft AGL and stalled. The right wing dropped and the acft…NTSB MKC85LA005Accident · No injuriesLimited investigationFinal reportBeech A36 · North Platte, NEThe plt stated that he had been using fuel from the rt wing fuel tank to compensate for a lateral imbalance during the flt. The fuel selector was on the rt tank when the eng failed. The plt said he switched tanks after the eng failed but was unable to restart…NTSB DEN85LA018Accident · No injuriesLimited investigationFinal reportBeech C-45H · Heber City, UTWhile in cruise flt, plt noted gradual left eng oil press drop from normal 70 PSI to 20 PSI. Plt shut down left eng, feathered prop and diverted to alternate airport. En route to alternate plt attempted to restart left eng to avoid single-engine landing. Plt…NTSB BFO85FA002Accident · 4 fatalField investigationFinal reportPiper PA-32R-301 · Salisbury, MDAfter contacting millville fss 4 times for wx info the acft departed lincoln park, NY, at 1858 EDT with destination listed on the IFR flt plan as easton, MD. En route the plt diverted to Salisbury, MD, due to wx. After being cleared forthe rwy 32 ILS the acft…