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 ATL87LA084Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Leslie, GAThe plt reported losing power shortly after takeoff; a forced ldg was subsequently made in a freshly-plowed field where the acft flipped over. Examination of the engine revealed a cracked #7 cyl head. FAA service difficulty reports (sdr's) indicated that…NTSB ATL87IA083Incident · No injuriesIncident investigationFinal reportSaab-Fairchild SF340A · Covington, KYAfter a hydraulic sys malfunction, the capt returned to arpt to exchange acft. Company plt had completed day of flying and was asked to taxi acft to maint hangar. Departing capt was in process of manually pumping hyd sys to sufficient pressure to ensure…NTSB SEA87LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Coburg, ORThe student pilot was in the process of flying his long cross country flight in order to qualify for his private pilots certificate. Prior to reaching the home airport, the students instructor talked to him from the ground and advised the student not to land,…NTSB MIA87LA101Accident · No injuriesLimited investigationFinal reportBeech C24R · Milton, FLThe acft crashed in a river aprx 1 mile west of his alternate landing location after the eng quit while descending for an apch, due to fuel exhaustion.NTSB LAX87LA138Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Santa Ynez, CAJust after takeoff, the plt reported an engine failure. Unable to return to the airport the plt landed in an open field and collided with the terrain. During the engine examination the fuel diverter valve was removed. Low air pressure was applied to all three…NTSB FTW87LA075Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · George West, TXAircraft collided with power lines during forced landing due to fuel exhaustion. Owner has not responded to letters. Warrant was issued for arrest of person thought to be pilot. Aircraft had traces of marijuana on board.NTSB CHI87LA094Accident · No injuriesLimited investigationFinal reportAmerican AA5 · Flint, MIDuring a forced landing on an interstate highway about two miles from bishop airport, the aircraft collided with a signpost and a concrete bridge. The pilot had reported that he was out of fuel when he was about nine miles away from the airport. The pilot…NTSB ATL87FA087Accident · 1 fatalField investigationFinal reportCessna 150H · Oneida, TNThe pilot contacted the fss several times during the morning for weather along his proposed route of flight. Shortly after lunch he departed without a flight plan. He reported to one fss that he was VFR only but continued although VFR was not recommended for…NTSB ATL87FA082Accident · 1 fatalField investigationFinal reportBeech K35 · Arden, NCPlt departed charleston, SC for raleigh earlier in the day. While at raleigh he discussed pending legislation with assoc. He departed raleigh about 2228 EST in wx of indef 100 and 1/2 mile visibility. His destination was forecast to have occasional ceilings…NTSB NYC87LA103Accident · No injuriesLimited investigationFinal reportCessna 150M · Poestenkill, NYThe aircraft came in high and fast, bounced on the centerline and veered left of the centerline on the second bounce. Pilot attempted to correct with right rudder and aileron but the aircraft continued to roll off of the runway and into snow where it nosed…NTSB NYC87IA105Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-80 · Baltimore, MDMain landing gear upper torque link attach bolt separated during takeoff as a result of preexisting stress corrosion cracking. McDonnell-douglas issued alert MD-80 service bulletin A32-220 following the incident.NTSB MIA87LA100Accident · No injuriesLimited investigationFinal reportCessna 337E · New Smyrna Bch, FLThe plt stated that on short final the auto-plt activated resulting in an uncontrolled 50-60 degree nose low left bank. The acft then veered from the apch path off the arpt property where it then collided with a vehicle & tree before coming to rest.…NTSB LAX87LA137Accident · No injuriesLimited investigationFinal reportCessna 172C · Kahului, HIThe acft collided with trees while manuevering in mountainous terrain. The plt had planned a local flight from honolulu to maui and return. Once over the island of maui, the plt notified the fss that he was changing his route and would be passing through the…NTSB LAX87DVA04Accident · No injuriesFinal reportHiller OH-23G · Delano, CADuring an aerial application flight, the pilot returned to the loading truck for approximately 5 additional gallons of chemical to finish the application. The loader; however, loaded 70 gallons and when the pilot took off the rotor RPM began to bleed off. The…NTSB LAX87DUG02Accident · 1 fatalFinal reportPrue Standard Unknown · Hemet, CADuring a local soaring flight, the acft was seen by a witness to be in a vertical dive and appeared to be intact when it impacted the terrain. Inspection of the aircraft revealed no control system malfunctions. The plts flt time was 38 hrs as of 2/5/85 the…NTSB FTW87DPJ03Accident · Minor injuriesFinal reportBoeing B75N1 · Fairmont, OKDuring the pull up at end of swath run pilot misjudged power line clearance. Top line caught on aircraft and caused uncontrolled descent to ground.NTSB CHI87LA093Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Genoa, ILThe aircraft experienced a loss of power on takeoff, for undetermined reasons, and was forced to make an emergency landing. On impact the nose gear and main landing gear sheared off.NTSB CHI87LA092Accident · No injuriesLimited investigationFinal reportMooney M-20G · Kenosha, WIWhile on downwind leg the pilot heard another aircraft call downwind. When he turned to final the other aircraft turned base. As he descended on final approach the other aircraft turned sharply inside the acft on final and landed. The following aircraft…NTSB CHI87DEP02Accident · 1 fatalFinal reportCessna 182N · Wissota, WIWhile attempting a night landing, by use of car headlights, the aircraft struck wires and descended out of control into the terrain. Witnesses stated that the pilot seemed low during the final approach. The private airport was not lighted.NTSB CHI87DEE05Accident · Serious injuriesFinal reportResney Commander 447 · Lansing, ILThe acft made a forced landing in a field due to fuel starvation. The acc plt offered to fly the acft out. He had 30 min of dual flt in this type acft. He sat on the left side of the acft for the flt which resulted in an unbalanced condition. The acft entered…NTSB ANC87LA046Accident · No injuriesLimited investigationFinal reportCessna 170B · Fairbanks, AKThe plt lost control of the acft after the tail was raised during takeoff. The acft groundlooped and collided with a snow bank which damaged the rt wing, landing gear and elevator.NTSB ANC87LA045Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Kotzebue, AKThe pilot stated that he encountered a complete whiteout condition and during the emergency landing on the frozen lake he lost directional control of the aircraft causing the left wing to strike the ground.NTSB MKC87LA058Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Tipton, MOThe pilot stated that, fifteen minutes into the flight, while at cruise the engine oil pressure began dropping as the oil temperature rose. While attempting to reach sedalia, Missouri to perform a precautionary landing, oil began covering the aircraft's…NTSB FTW87LA074Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Refugio, TXEngine failure occurred on climb. The aircraft was destroyed during the forced landing. Teardown revealed that the no. 1 cylinder rocker arm shaft retainer ear had broken. The two lock bolts had backed out because they had not been safety wired. The no. 2…NTSB DEN87LA065Accident · No injuriesLimited investigationFinal reportRaven S60A · Grand Lake, COThe balloon encountered turbulence during normal cruise at 100 to 150 feet AGL, while crossing a ridgeline. Gusts extinguished both burner plt lights and partially collapsed the envelope. The balloon began an uncontrolled descent. The plt re-ignited both…NTSB CHI87LA091Accident · Minor injuriesLimited investigationFinal reportBeech BE 36 · Alma, MIAccording to the plt, during the preflight inspection, he determined that both gas tanks were full and 'everything was in order.' After aprx one hour of local flight, the plt entered a left downwind for rwy 27 at gratiot community airport, Alma, Michigan. The…NTSB CHI87LA090Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Hopkins, MIThe plt stated that 'everything was normal' on downwind and base, but that he experienced rough air and 'side to side motion' of the acft on final approach to rwy 27. According to the plt, he held an airspeed of 70 mph with 'some power' until he had the rwy…NTSB CHI87DEE06Accident · No injuriesFinal reportSchleicher ASK-21 · Plainfield, ILThe glider plt rprtd that drg takeoff, the tow plt released the tow rope at aprx 15' AGL. Rprtdly, he released the tow rope due to a perceived lack of takeoff & climb performance. After being released, the glider plt made a right turn to avoid unacceptable…NTSB BFO87FA027Accident · 2 fatalField investigationFinal reportRockwell 112 · Edgewood, MDOn the day of the accident and before the accident flight, the inlet fuel hose to the fuel flow divider was replaced. The hose assembly was fabricated by maint personnel. An inspection flight afterwards revealed engine roughness during fuel mixture leaning.…NTSB ATL87LA081Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Toronto, OHThe plt reported that the engine quit completely after takeoff at about 50-75 ft AGL without any warning. The plt attempted to land back on the rwy and the acft overran the rwy end. Examination of the acft after the accident revealed no malfunctions, defects,…NTSB ATL87LA080Accident · No injuriesLimited investigationFinal reportCessna 172M · Lexington, NCThe plt reported that he had transitioned to a visual approach, following a simulated radar approach to the rwy using vectors and descent info supplied by an instrument-rated safety plt in the rt seat. The safety plt was the plt's former instructor. The plt…NTSB ANC87FA043Accident · No injuriesField investigationFinal reportBell 47G-2 · Anchorage, AKA flight instructor and his commercial rotorcraft student were practicing quick stops to a hover at low altitude over a snow covered non-maintained airstrip. The student, a commercially rated fixed wing pilot, had successfully completed three quick stops, but…NTSB NYC87LA107Accident · No injuriesLimited investigationFinal reportCessna 152 · Robbinsville, NJWhen the student plt was lndg after a LCL flt, the acft touched down nose wheel 1st, then ballooned & lndd hard. Drg the occurrence, the nose gear collapsed & the acft slid along the rwy for about 100 yds bfr coming to rest. After the acdnt, the student said…NTSB MKC87LA057Accident · No injuriesLimited investigationFinal reportEmbraer EMB-110 · Norfolk, NEThe crew stated they were descending for landing when they flew through a flock of geese that were traveling in the same direction. They received three or four bird stikes. The aircraft landed without further incident.NTSB MKC87LA056Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Kimball, NEThe PIC rptd landing rwy 10 with a wnd fm 080 at 7 KTS. The acft began veering left and ran through a snow bank which bordered the rwy. The left main landing gear collapsed and the acft spun around 180 deg stopping tail first. Insp of the landing gear noted…NTSB MKC87LA055Accident · No injuriesLimited investigationFinal reportCessna 150 · Newton, KSThe stu was practicing simulated engine failures at his cfi's direction. As the stu simulated corrective action in the cockpit to restore pwr, he inadvertently turned the fuel selector off, and did not tell the CFI. Normally the CFI terminated the simulated…NTSB MIA87LA099Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Tallahassee, FLControl of the acft was lost due to a strong wind gust created by the tree line next to the rwy & the acft crashed next to the rwy. A plt who had landed just prior to that time stated that he had sustained a momentary lost of acft control during the flare due…NTSB LAX87FA136Accident · 1 fatalField investigationFinal reportBellanca 7KCAB · Lebec, CAPrior to the flt, the plt rcvd 2 wx briefings & was adzd of low ceilings, restricted visibilities & mtn obscurement along the route. Also, he was adzd that VFR flt was not recommended. The surviving pax said that after entering the mtn area, they contd 'in…NTSB LAX87FA135Accident · 3 fatalField investigationFinal reportGrumman American AA-5A · Tucson, AZA witness observed the airplane entering downwind with smoke trailing behind it. The pilot communicated to UNICOM that: 'the engine has quit; I have to get down'. The witness then observed the airplane making a tighter-than- normal 'base to final' turn. The…NTSB DEN87LA062Accident · No injuriesLimited investigationFinal reportBeech 58 · Bismarck, NDThe plt, while at cruise, detected an odor he suspected to be overheated electrical wiring. He diverted to a nearby arpt for a precautionary landing. The plt shutdown all electrical pwr after communication with the twr. Prior to landing, the plt turned on…NTSB DEN87FA064Accident · 1 fatalField investigationFinal reportCessna P210N · Roswell, NMThe plt, who never flew at night and who told relatives that he was exhausted after all-day business meetings, nevertheless departed albuquerque, NM, at 1756, en route to Roswell, NM. He contacted Roswell twr at 1844 but never arrived. The wreckage was…NTSB ATL87LA079Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Waycross, GADuring a normal approach to a sod strip, the pilot reported that the gusty wind condition ceased and the acft stalled to the ground short of the intended landing area. The pilot was not able to recover from the sinking condition. The impact caused substantial…NTSB NYC87LA102Accident · No injuriesLimited investigationFinal reportCessna 172N · Danbury, CTStudent pilot lost directonal control on landing and the aircraft veered to the left of the runway and collided with a snowbank.NTSB NYC87FA101Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Locke, NYThe student pilot of the PA-140 was performing a solo x-country flight. He had made a fuel stop approx 20 mins prior to the crash. Witness observed an aircraft flying low and remarked that the engine sounded very loud just before crashing into an occupied…NTSB FTW87LA073Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7-B · Broken Arrow, OKThe Balloon drifted into power lines just after liftoff. The pilot stated he was hooking up a new temperature gauge and did not notice that the Balloon was descending.NTSB FTW87LA072Accident · No injuriesLimited investigationFinal reportCessna P206B · Hooker, OKThe pilot closed the throttle after crossing the approach end of the runway and while at 10 feet or less above ground level. He bled off airspeed to the point that the aircraft stalled and dropped to the surface, resulting in a hard landing with substantial…NTSB DEN87LA063Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Erie, COAcft lifted off at slow airspeed and stalled/mushed back to rwy.NTSB BFO87FA026Accident · 4 fatalField investigationFinal reportCessna 210M · Charleston, WVThe aircraft bounced after landing touchdown. Witnesses observed the aircraft assume a nose high attitude and heard some power applied to the engine as the aircraft veered to the right. It was not determined whether the pilot was attempting to abort the…NTSB ANC87LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Nenana, AKThe pilot lost control on takeoff, stalled and crashed on a frozen lake. During the interview with the pilot, he stated that the engine quit on initial climbout; he believed he did not pre-heat the engine long enough before takeoff. At the time of the…NTSB MIA87FA098Accident · No injuriesField investigationFinal reportPiper PA-34-200 · Miami, FLThe plt stated that he was on final approach & cleared to land long, when a 737 was cleared for an immediate takeoff and he was told to make s turns or whatever necessary. He slowed to land and when he was approximately 10 to 20 ft. in the air he encountered…