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.

NTSB MIA87FA047Accident · 1 fatalField investigationFinal reportBeech C-55 · Ivel, KYThe plt who was originally scheduled to make the charter flt to pick up the pax was reluctant to do so due to low ceilings in the mountainous area at the destination. The owner of the company took the flt & the flt was observed by witnesses near the…Dec 10, 1986 · N7975M · DestroyedNTSB CHI87MA053Accident · 2 fatalMajor investigationFinal reportHughes 269B · Cross Plaines, INThe plt & observer were on a power line patrol flt. While proceeding southbound, they apchd an area were the lines were about 23 ft AGL & were crossed by another set of power lines, oriented in an east-west direction. The other power lines were about 45 ft…Dec 10, 1986 · N8982F · DestroyedNTSB ATL87MA041Accident · 6 fatalMajor investigationFinal reportBeech 100 · Windsor, MADrg arr for a LOC rwy 26 apch, the plt was adzd the abyss fan marker was notamed out-of-svc. With abyss inop, min dscnt alt (mda) was 2200'. After N65TD was clrd for the apch, radar svc was terminated & the flt was clrd to adzy freq. The crew contacted UNICOM…Dec 10, 1986 · N65TD · DestroyedNTSB ATL87LA040Accident · No injuriesLimited investigationFinal reportHughes 269C · Charlotte, NCWhile flying at 300' to 500' AGL on a cable patrol flt, the plt heard a loud loise. The rotor RPM started to decay & the eng RPM increased sharply. The plt initiated an autorotation to a parking lot, but had to maneuver to avoid trees & a vehicle. The…Dec 10, 1986 · N58188 · Substantial damageNTSB MIA87FA046Accident · 2 fatalField investigationFinal reportHughes 369HS · Zephyrhills, FLA witness stated that she heard the eng on the helicopter quit. She looked out her window and watched the helicopter hit the ground, bounce, hit again, flip over and the tail broke off. The helicopter then burst into flames and exploded. Exam of the eng…Dec 9, 1986 · N8390F · DestroyedNTSB LAX87LA060Accident · No injuriesLimited investigationFinal reportMooney M20C · Michigan Bar, CADuring the flare, just prior to touchdown, a deer ran across the runway from the right and subsequently collided with the left wing of the aircraft. The pilot reported there was no time to avoid an impact.Dec 9, 1986 · N5808Q · Substantial damageNTSB FTW87LA030Accident · No injuriesLimited investigationFinal reportCessna 305A · Mason, TXPrivate pilot of Cessna 305A ferrying aircraft from glascow, MT. To mc allen TX. Engine failed approximately 1 1/2 hours after departure from graham TX. Pilot attempted downwind landing on farm-to-market road and struck tree. Aircraft was destroyed. Pilot and…Dec 9, 1986 · N5211G · DestroyedNTSB ATL87FA039Accident · 1 fatalField investigationFinal reportCessna 170B · Madison, GAAlthough there were no witnesses to the crash, one witness did observe the acft taxiing at a very slow speed toward the dept end of the rwy. Abt 30 mins later the wreckage was fd in a fld east of the airstrip. Exam indicated it collided w the gd in a near…Dec 9, 1986 · N2464D · Substantial damageNTSB CHI87LA042Accident · No injuriesLimited investigationFinal reportCessna 152II · Anoka, MNThe acft was on the fifth touch & go of the student plt training flt when a loss of power occurred at 100-200 ft AGL during climbout. The CFI had to land the acft in unsuitable terrain which resulted in substantial damage to the acft. Examination of eng and…Dec 8, 1986 · N753AA · Substantial damageNTSB SEA87MA035Accident · 6 fatalMajor investigationFinal reportCessna TU206G · Jean, NVWhile en route at night on an IFR flt plan, the acft ran out of fuel. Subsequently, the plt was provided vectors toward a hiway for a forced lndg. However, before reaching the area of the hiway, the acft crashed on rising terrain at an elev of about 4000 ft.…Dec 7, 1986 · N732ZF · DestroyedNTSB SEA87LA020Accident · Serious injuriesLimited investigationFinal reportCessna 414A · Murtaugh, IDDuring the transition from a DME arc to the ILS final apch course, the plt allowed the acft to prematurely descend into the ground. The reason for the descent could not be determined. However, no pre-impact mechanical malfunction with the acft was found nor…Dec 7, 1986 · N37561 · DestroyedNTSB NYC87LA046Accident · No injuriesLimited investigationFinal reportBeech B23 · Trenton, METhe plt rprtd that after takeoff, the acft had climbed to 600 ft & was climbing at 300 ft/min, when the eng 'started to labor,' then quit running. He used carburetor heat & 'primed through power reduction,' but the eng would not restart. During an emerg lndg…Dec 7, 1986 · N7651R · Substantial damageNTSB MIA87FA045Accident · 1 fatalField investigationFinal reportNorth American Rockwell 112 · Jacksonville, FLThe acft, being flown by a non-instrument rated plt, appeared over the arpt without making contact with the tower while the arpt was under instrument flt conditions and the control zone was in operation. After making several erratic passes the plt contacted…Dec 7, 1986 · N1142J · DestroyedNTSB LAX87LA059Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Davis, CAA Cessna 152 nosed over in a rough plowed field after a partial loss of power while on a night VFR pleasure flight. The pilot indicated that he was on a date with his girl friend and offered to demonstrate negative gravity to her. He slowed the aircraft and…Dec 7, 1986 · N25592 · Substantial damageNTSB FTW87FA029Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Petersburg, TXAcft impacted in a 95 deg nose down attitude following a loss of control in IMC conditions while the non-instrument rated pvt plt was being vectored to the final app crs. Plt had filed IFR and had experienced difficulties thru out the flt. As he was given…Dec 7, 1986 · N4475F · DestroyedNTSB ATL87LA037Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Cullowhee, NCAfter not flying for about 7 yrs, the plt obtained flt instruction in preparation for a biennial flt review. His 1st flt was completed 4 days prior to the acdnt. The acdnt flt was to be devoted primarily to takeoffs & landings. The student plt was rprtd to…Dec 7, 1986 · N6860G · DestroyedNTSB ATL87FA038Accident · 2 fatalField investigationFinal reportCessna 185D · Hammonton, NJThe mid-air collision occurred while the Cessna 185 was attempting a steep climbout during takeoff from rwy 21 and the Mooney was making a landing to the same runway. Another aircraft attemped to warn both aircraft over the UNICOM freq. Neither aircraft…Dec 7, 1986 · N5878T · 2 aircraft · DestroyedNTSB ANC87LA019Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Shageluk, AKThe pilot stated he encountered freezing rain and due to the build-up on the aircraft, he stalled and crashed in an open area next to the airport.Dec 7, 1986 · N9940D · Substantial damageNTSB NYC87LA048Accident · No injuriesLimited investigationFinal reportCessna 150 · Poestenkill, NYThe pilot touched down hard, added power for a go around. Sluggish engine did not have enough power to clear trees at the end of the runway. Aircraft collided with trees. The plt after the acc said that after cutting off the carb head the eng seemed sluggish.…Dec 6, 1986 · N50714 · Substantial damageNTSB NYC87LA047Accident · No injuriesLimited investigationFinal reportPiper J-3 · East Moriches, NYDuring the takeoff roll on an instructional solo flight, the flight encountered a crosswind which pushed the Piper off the runway to the left colliding with trees and bush.Dec 6, 1986 · N26057 · Substantial damageNTSB NYC87FA045Accident · 1 fatalField investigationFinal reportCessna 152 · Carlisle, PAThe student pilot flying a Cessna 152 scheduled his flight period so it coincided with another student pilot flying a Cessna 172. The pilot of the Cessna 172 reported seeing the Cessna 152 enter a two turn spin and recover. He then said he lost sight of the…Dec 6, 1986 · N69123 · DestroyedNTSB MIA87LA044Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Apollo Beach, FLWhile in cruise flt at 600 feet a sudden loss of engine power occurred. Attempts to restart the engine were unsuccessful and the aircraft was ditched. Post accident examination of the engine revealed no evidence of mechanical failure or malfunction. The icing…Dec 6, 1986 · N6330G · Substantial damageNTSB MIA87LA042Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Miami, FLThe eng lost power while the acft was in cruise flt at 6000' over the atlantic ocean, aprx 6 hrs & 32 min after takeoff. Subsequently, the acft was ditched in the ocean when the eng could not be restarted. The acft then sank & was not recovered. Calculations…Dec 6, 1986 · N130LJ · DestroyedNTSB LAX87LA061Accident · No injuriesLimited investigationFinal reportCessna 182Q · San Rafael, CADuring an instructional flight, the student pilot was not aligned properly with the runway. The flight instructor (CFI) took control of the aircraft on final, but he stated that it did not respond when he applied rudder control. After touchdown, the aircraft…Dec 6, 1986 · N759DH · Substantial damageNTSB FTW87LA028Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-180 · Montgomery, TXA private pilot check ride was interrupted by a forced landing on a golf course after having experienced severe vibrations and a loss of power. During the forced landing the acft collided with a 10 ft tall tree and nosed down to terrain impact. Investigation…Dec 6, 1986 · N3171R · Substantial damageNTSB FTW87LA027Accident · No injuriesLimited investigationFinal reportCessna 150K · Georgetown, TXThe plt experienced a loss of pwr due to fuel exhaustion during the x-country flt. The plt elected to divert to Georgetown, TX, during the flt to refuel. The engine quit aprx 4 to 6 miles north of the aprt. The plt attempted to make the arpt with inadequate…Dec 6, 1986 · N5809G · DestroyedNTSB DEN87LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Havre, MTThe plt inadvertently stalled the acft during pull-up after making a pass 20 ft above coyotes on the ground. The acft impacted level terrain and slid through a wire fence.Dec 6, 1986 · N7087D · Substantial damageNTSB CHI87LA043Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Marquette, MIWhile on landing rollout the student pilot skidded off the left side of the runway and collided with a snowbank. The student stated he was holding excessive left rudder and brake pressure.Dec 6, 1986 · N41765 · Substantial damageNTSB CHI87DEM05Accident · Serious injuriesFinal reportCessna T210L · Lawton, MIThe plt experienced a loss of control shortly after takeoff which resulted in an uncontrolled descent. The acft struck the ground with its left wingtip causing it to flip over onto its side. The plt reported that the auto-plt had been worked on after having…Dec 6, 1986 · N999WF · Substantial damageNTSB ATL87LA036Accident · No injuriesLimited investigationFinal reportSikorsky UH-19D · Roanoke Rapids, NCThe plt said he was spreading fertilizer on trees when he heard a loud noise from the eng & the helicopter yawed left. At that time, the helicopter's alt & speed were about 100 ft & 40 KTS. Collective was raised to clear tree tops & reach a clearing. Before…Dec 6, 1986 · N37800 · Substantial damageNTSB MIA87WA043Accident · Minor injuriesForeign investigationBeech 95-B55 · Cay Sal, BahamasDec 5, 1986 · N6220V · DestroyedNTSB LAX87DUJ02Accident · No injuriesFinal reportGrumman G-164 · Chandler, AZThe acft collided with power lines during an aerial application flight. The pilot had made several passes prior to the accident and noticed the wires each time. Visibility was good, it was daylight conditions, and there were no mechanical problems.Dec 5, 1986 · N671Y · Substantial damageNTSB CHI87LA041Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Vergenns, ILAccording to the student pilot, while practicing emergency landings, he descended to about 250 feet AGL and then surrendered the controls to the instructor. The student pilot stated that the instructor immediately added full power and banked the acft to the…Dec 5, 1986 · N95614 · Substantial damageNTSB SEA87MA034Accident · 3 fatalMajor investigationFinal reportBell 206L-1 · Pendleton, ORThe helicopter departed Pendleton on an emerg med svc/med-evac (EMS) flt to transport a patient to portland. After delivering the patient, the plt took off on the rtn flt with 2 med psnl aboard. Drg arrival at 1658 PST, he requested a special VFR (svfr)…Dec 4, 1986 · N7EC · DestroyedNTSB FTW87LA026Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Durant, OKThe student plt noted a partial power loss while practicing multiple touch-and-go landings. She stated that after she had turned on a downwind, she heard 'a different sound' from the eng and it appeared to lose power. During an apch for an off arpt landing,…Dec 4, 1986 · N25532 · DestroyedNTSB ANC87LA018Accident · No injuriesLimited investigationFinal reportCessna U206G · Uganik Pass, AKThe pilot stated that he encountered a complete white-out condition; he started a turn to the left and struck the top of the ridge at the 1780 foot level.Dec 4, 1986 · N4736U · Substantial damageNTSB NYC87DNC03Accident · No injuriesFinal reportAero Commander 680 · Barre, VTWitness observed the acft touchdown about 2000 feet down 5001 foot rwy. The rwy was reported wet and icy in spots at the north end only. The acft overran the rwys end and went down into a ravine about 25 ft below rwy level. There was no indication of…Dec 3, 1986 · N6375U · Substantial damageNTSB MKC87LA028Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B-600 · Earle, ARThe pilot stated that the powerplant was performing normally during initial climb when, suddenly, the engine experienced a power loss after backfiring. Immediate remedial action resulted in a partial power output but not enough to sustain flight. Emergency…Dec 3, 1986 · N6898Q · Substantial damageNTSB FTW87FA025Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Baytown, TXThe plt took off from a decommissioned, unlighted arpt at night after telling friends in a bar that he was going to new orleans. Later, witnesses observed the acft as the plt made several low passes over an interstate highway near the departure arpt. While…Dec 3, 1986 · N43302 · DestroyedNTSB ATL87MA035Accident · 4 fatalMajor investigationFinal reportBell 206L-1 · Jamestown, TNThe helicopter was being used in an emerg med svc/med-evac (EMS) opn. At 0230, the plt obtained a partial wx briefing. He was advised of flt prctns for IFR wx thru-out the area with low ceilings, fog, precip & mtns obscd. The flt departed nashville at 0245 &…Dec 3, 1986 · N3898U · DestroyedNTSB ATL87IA034Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-101 · Atlanta, GAAt about 4,000 ft MSL, cpt on sch dom flt reported loud pop and sub shutdown of rt eng. Smell of smoke and visual confirmation of fire in rt nacelle. Ships fire ext activated during return to dept. Arpt. Landed without further incident. Investigation revld…Dec 3, 1986 · N802MX · Minor damageNTSB ANC87LA017Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Skwentna, AKThe pilot lost directional control of the aircraft on touchdown. Examination of the brake system revealed the left brake was frozen.Dec 3, 1986 · N6992N · Substantial damageNTSB MIA87FA041Accident · Serious injuriesField investigationFinal reportCessna 320 · Panama City, FLWhile executing an ILS approach with aircraft radios that were not operating properly and using a hand held transceiver, the right engine failed due to a broken fuel pressure sensor wire, and the pilot lost control of the aircraft in IMC conditions and…Dec 2, 1986 · N1FD · DestroyedNTSB FTW87LA024Accident · Serious injuriesLimited investigationFinal reportMooney M20D · Kerrville, TXThe pilot was unable to extend the landing gear in preparation for landing. Troubleshooting and several attempts to extend the gear failed. The pilot then made a 360 degree turn over the airport to lose altitude during which, he secured the engine and stopped…Dec 2, 1986 · N1970Y · Substantial damageNTSB DEN87LA027Accident · No injuriesLimited investigationFinal reportCessna 152A · Great Falls, MTThe student plt was cleared to make a touch-&-go landing on rwy 21. As he was lndg, he noticed the arresting barrier (cable) was raised. He added full pwr & pulled back on the yoke to avoid hitting the cable. The acft lifted off, but its tail hit the cable.…Dec 2, 1986 · N4784A · Substantial damageNTSB CHI87IA039Incident · No injuriesIncident investigationFinal reportDouglas DC-9-51 · Madison, WIAircraft slid off the right side the runway during the rollout from a cross wind landing and struck 6 runway edge lights causing minor damage to the inboard trailing edge of the right flap. At the time of the incident there was 1/2 inch of snow on the runway…Dec 2, 1986 · N786NC · Minor damageNTSB CHI87FA040Accident · 4 fatalField investigationFinal reportMooney M20E · Hanna City, ILThe aircraft struck power lines and crashed two miles from the end of the runway on final approach ground track after being cleared for an ILS approach. The accident occurred at the end of a three leg cross-country flight from the Bahamas which began aprx 8…Dec 2, 1986 · N9210M · DestroyedNTSB LAX87DUM01Accident · No injuriesFinal reportBell UH-1B · Calipatria, CADuring the initial climb at the beginning of an aerial application flight, the pilot made a climbing 180 degree right turn in the reverse direction when the rotor RPM began to drop. The pilot continued to raise collective, lost directional control and…Dec 1, 1986 · N2770N · Substantial damageNTSB NYC87LA043Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Pine Bush, NYThe CFI and student were practicing a simulated eng failure when the accident occurred. At 1700 ft MSL, during the simulated emergency descent, the CFI applied full throttle to terminate the simulation and eng pwr could not be regained. During the forced…Nov 30, 1986 · N8297Y · Substantial damageNTSB NYC87LA041Accident · No injuriesLimited investigationFinal reportCessna 441 · Erie, PAReason for the Cessna to veer in a semi-circle and collide with another aircraft is undetermined. Examination of the start lock assemblies could not be completed due to the extensive impact and fire damage. The acft was being prepared for a flt. During a…Nov 30, 1986 · N117EA · Substantial damage