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 LAX87LA246Accident · No injuriesLimited investigationFinal reportBeech V35 · Clearlake, CADuring a cross country flight the engine experienced a loss of power. The plt made a forced landing on a road where during the landing roll the acft collided with a fence and eventually came to rest in a ditch. Inspection of the engine revealed extensive…NTSB LAX87LA245Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Tucson, AZAt the end of a business flt, the plt extended the landing gear and noted that the left main landing gear indicated that it was not down and locked. The plt activated the emergency landing gear extension which still indicated it was not down. While on final…NTSB LAX87DVM04Accident · Minor injuriesFinal reportRand KR-2 · Watsonville, CAShortly after take-off on runway 19, the engine began 'sputtering' and losing power. The pilot tried adjusting mixture and throttle controls. The engine continued 'sputtering' and losing power and the pilot initiated an emergency descent. Having gained no…NTSB FTW87LA153Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Marietta, OKThe plt rprtd that drg takeoff fm a grass rwy, the acft stalled after climbing about 10 ft AGL. He said that torque pulled the nose of the acft to the left & he tried to recover. However, there was insufficient alt & the acft hit the tops of trees, then fell…NTSB FTW87FA152Accident · 1 fatalField investigationFinal reportChampion 7ECA · Monahans, TXWitnesses stated that upon departure the pilot pulled the aircraft up abruptly and rolled into a very steep right climbing turn. After about 20 minutes the pilot returned to the airport due to weather conditions along his porposed route of flight. Over the…NTSB FTW87DPA03Accident · 2 fatalFinal reportRollins Starlite · Arlington, TXThis was the first flight for the 156 hour private pilot in this make and model airplane, however, he had previously made several high speed taxi runs in it. According to witnesses, the pilot used only about half throttle for the attempted takeoff. The…NTSB DEN87LA160Accident · No injuriesLimited investigationFinal reportCessna 182RG · Deming, NMDuring the landing flare the plt reported he flared late and the acft bounced and porpoised. The plt commented and the plt rated passenger in the right seat misinterpreted the comment as a request for assistance. With two people conflicting on the controls a…NTSB DCA87IA037Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-30 · Miami, FLEal flight 23 experienced a rapid decompression during descent into Miami. Flight 23 departed lax with 3 flight crew, 8 f/a and 210 pax. On climbout the s/o observed that the manual outflow valve control wheel did not move toward the 1/2 closed position as it…NTSB BFO87LA043Accident · No injuriesLimited investigationFinal reportCessna 195A · Cambridge, MDAfter purchasing the acft in atl, the plt, who held an a & p certificate, inspected and flew the acft in the local area bfr departing on a ferry flt to rockland, ME. Drg lndg at his first fuel stop, the acft swerved to the rt and the plt intentionally…NTSB ATL87LA193Accident · Serious injuriesLimited investigationFinal reportBellanca 14-13-2 · Hamilton, OHThe plt rptd that he made a non-std rt-hand departure after t/o from rwy 29, to avoid traffic departing to the left. The acft began to sink as he attempted to climb over the lee side of a 200 ft-high ridge less than 1 mile northwest of the arpt. The acft…NTSB NYC87LA189Accident · No injuriesLimited investigationFinal reportPiper PA-60 · Doylestown, PAUpon landing, the flight encountered standing water on the runway and the aircraft hydroplaned veering right of the centerline. The main landing gear collapsed causing substantial damage. The acft went off the rt side of the rwy after 2839 ft of roll and…NTSB NYC87FA192Accident · 4 fatalField investigationFinal reportCessna 182P · Ellenville, NYThe acft collided with rising terrain in a mountainous area of minnewaska state park while climbing to cruise on a VFR flight. The crash site was about 1,430 feet higher in elevation than the departure airport. The weather at the departure airport was 1000…NTSB NYC87FA188Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Tannersville, NYWhile on a VFR air taxi cargo flight, the aircraft collided with trees on the east side of high peak mountain, elevation 3,655 feet. The accident site elevation was 3080 feet. A witness said it was heavy overcast, not raining and the clouds were not below the…NTSB NYC87FA187Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Boston, MAThe en route portion of the flt was uneventful, except that the plt used the call sign 'N251DE' instead of 'N33670' which was the registration number of his acft. Drg arrival at Boston, he was provided radar vectors, cleared for an ILS rwy 4R apch &…NTSB FTW87LA154Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Baytown, TXDrg the lndg roll, the acft started to drift to the left, so the plt corrected with right rudder. He said he over- controlled, then applied left rudder & brake, followed by right rudder & brake. Subsequently, the situation became aggravated until both main…NTSB FTW87DRD07Accident · No injuriesFinal reportGrumman G-164B · Chenneyville, LAThe engine experienced a total loss of power due to a failed #1 connecting rod. During the forced landing the left wing contacted cotton plants which caused the aircraft to veer left and flip inverted.NTSB CHI87DEM09Accident · 2 fatalFinal reportNorth American P-51D · Ludington, MIN3278D was #1 (leader) in a flt of 2 North American P-51 acft. The plt of the 2nd P-51 rprtd that they were on a southerly heading over water about 1/2 mi from the shore when the leader raised his nose & began rolling to the right. Witnesses on the beach…NTSB ATL87IA191Incident · No injuriesIncident investigationFinal reportSwearingen SA-226TC · Nashville, TNThere was hvy traffic at the Nashville metro arpt when air midwest flt 4530 (Swearingen SA-226TC, N256AM) arrived drg a morning flt. The flt crew made an ILS apch to rwy 31 as another acft (American flt 130) was on an apch to rwy 2L. The 2 rwys intersected nr…NTSB ATL87FA189Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Jesup, GAWitnesses rprtd the acft 'buzzed' (flew low) over a factory, where the plt used to work, then it went over the altamaha river, flew under a bridge & continued up the river at low alt. About 2 to 3 mi upstream, the acft was maneuvering when it struck trees &…NTSB SEA87LA123Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Ketchikan, AKOn landing at Ketchikan airport the pilot stated he made a last minute runway change due to departing traffic. Turning base the pilot reduced power to idle. He then advanced the throttle and received no response. The pilot could not make the runway and…NTSB BFO87LA042Accident · No injuriesLimited investigationFinal reportCessna 177A · Oakland, MDAfter flying around for about one hour to check out some radios in the aircraft, the pilot elected to return to the airport. On short final he elected to do a go-around and midway down runway 26 he pushed in carburetor heat, added full throttle and decreased…NTSB ATL87LA190Accident · No injuriesLimited investigationFinal reportCessna A188B · Dyersburg, TNDrg a spraying opn, the plt returned to land on an asphalt hiway & reload with chemicals. As he flared to lnd, the eng accelerated to aprx '2/3 throttle' with no throttle movement. He believed the throttle was in the off psn when this occurred. A nose hi…NTSB ATL87LA188Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201T · Bowling Green, OHThe instructor (CFI) rprtd he preflighted the acft & taxied to the refueling area. While there, he was apchd by another plt who wanted to go with him on this flt. They agreed & the CFI moved to the rgt seat. They commenced the start-up, run-up & takeoff…NTSB ATL87LA186Accident · No injuriesLimited investigationFinal reportCessna 152 · Dothan, ALThe comm plt held a helicopter rating and was training for his private pilot single-engine-land rating. He had flown approximately 10 hours in fixed wing aircraft with 6 hours as PIC. The pilot had completed two landings and on the thirdapproach stated he was…NTSB ATL87FA187Accident · 1 fatalField investigationFinal reportBeech V35A · Augusta, GAThe plt ctcd apch ctl for radar svc & wx info. The destn arpt had hvy rain & thunderstorm activity, but the plt rprtd he had the arpt in sight. Radar svc was terminated & the plt began a visual apch. Witnesses rprtd the visibility dropped to 1/2 mi in hvy…NTSB ATL87DEI06Accident · 2 fatalFinal reportSteen Skybolt · Wadsworth, OHThe accident occurred when the pilot was practicing aerobatics. The investigation disclosed that linkage control rods between the pilot's stick and the pitch elevator was broken. The evidence indicated that the failure was caused by a combination of…NTSB SEA87LA121Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Viola, IDDuring an aerial applications maneuver a total loss of power occurred due to the internal failure of the supercharger impeller. During the forced landing the left main gear collapsed causing the aircraft to nose over inverted.NTSB NYC87LA186Accident · No injuriesLimited investigationFinal reportCessna 172 · Olyhant, PAThe cross country personal transportation flight arrived in the scranton, Pennsylvania area for a planned refueling stop and encountered heavy fog conditions. Six attempts to land were made, but were aborted. An attempt to land at another airport was also…NTSB NYC87LA185Accident · No injuriesLimited investigationFinal reportPiper PA-34 · Southbridge, MADuring landing roll, a failure of a tire tube caused a flat tire and control of the aircraft was lost. When the tire was dismantled, the inner tube was found to be defective at the joint seam. Total time on the acft and tire WAS407 hrs. The acft had a 100 hr…NTSB NYC87LA184Accident · No injuriesLimited investigationFinal reportCessna 152 · Butler, PAThe student pilot landed at Butler farm airport. The plt overshot the normal touchdown point at excessive speed. The aircraft skidded off the end of the runway and collided with a three foot deep ditch and was substantially damaged.NTSB NYC87LA183Accident · No injuriesLimited investigationFinal reportCessna 150J · Olcott, NYA student pilot practicing touch and go landings experienced an engine power loss on takeoff. During an approach to an open field for an emergency landing, the engine restarted. The pilot decided to return to the arpt. Upon entering downwind, the engine quit.…NTSB MKC87LA127Accident · No injuriesLimited investigationFinal reportCessna 150 · Lincoln, NEAfter completing an IFR simulated NDB approach to runway 35L, PIC side-stepped to land VFR on 35R. During base leg acft had a partial power loss followed shortly by total power loss. PIC informed control tower of the emergency and made a forced ldg in a farm…NTSB MIA87FA191Accident · 2 fatalField investigationFinal reportRockwell 690A · Hilliard, FLRadar data indicated the acft climbed normally to 9,200 feet at which time some manuever was performed with the acft. The acft then entered a near vertical dive and the last radar hit was at 6,900 feet. Examination of the acft revealed it experienced an…NTSB DEN87FA159Accident · 1 fatalField investigationFinal reportMooney M20A · Reserve, NMThe plt was ferrying his acft from Reserve airport, NM, to jewitt mesa airport, apache creek, NM. There was a mature thunderstorm over the northern mountain ridge producing what one witness described as winds 'really blowing hard.' She said she saw the acft…NTSB CHI87LA158Accident · Minor injuriesLimited investigationFinal reportCessna 175C · Oshkosh, WIDuring cruise flight near Oshkosh the engine quit for undetermined reasons. The pilot contacted wittman field and was cleared by air traffic personnel to land on runway 27. Attempts to restart the engine were not successful and the pilot ditched the aircraft…NTSB CHI87LA157Accident · No injuriesLimited investigationFinal reportCessna 172P · Ft. Wayne, INThe pilot reported that the airspeed indicator failed in flight. The aircraft landed hard and porpoised. The nose wheel broke off and the aircraft skidded down the runway grinding off the bottom of the carburetor. A fire broke out destroying the aircraft.…NTSB BFO87DIG07Accident · Minor injuriesFinal reportCessna 150/Horton Stol · Maysville, WVThe plt/owner was flying a Cessna 150 which was equipped with a horton stol kit. Drg an apch to rwy 3, he used an airspeed of 40 KTS. While apchg the rwy, the acft settled & the nose gear struck a bump on the apch edge of the rwy. The plt rprtd that the…NTSB ATL87LA185Accident · No injuriesLimited investigationFinal reportBeech 200C · Madisonville, KYThe acft struck a 2-FT hi avgas pump while the plt was taxiing around another acft that was parked. The nose gear collapsed & a small fire resulted. The plt & pax evacuated the acft. Line psnl were unable to extinguish the fire with hand-held extinguishers.…NTSB SEA87LA122Accident · No injuriesLimited investigationFinal reportCessna 150B · White City, ORAfter about one hour of flight and during a takeoff the engine ceased operating. The pilot attempted to land the aircraft onto the remaining runway but an overrun occurred. The aircraft rolled through a fence and then a ditch with the nose gear breaking off.…NTSB LAX87LA243Accident · No injuriesLimited investigationFinal reportBoeing 737-277 · Los Angeles, CAFailure of the qualified mechanic to insure the operation of the aircraft brakes prior to taxiing and his failure to utilize the emergency brake system to prevent the collision. Contributing to this accident was the decision of airline maintence supervisors…NTSB CHI87DEC03Accident · Serious injuriesFinal reportNavion G · Erie, MIWith the landing gear extended, the aircraft impacted with trees in a near inverted attitude and was destroyed. The pilot, who was the sole occupant was seriously injured. There were no witnesses to the accident and the pilot could not remember the events…NTSB ATL87LA183Accident · No injuriesLimited investigationFinal reportCessna 140 · Falmouth, KYThe pilot was on a cross-country flight and had made several refueling stops during the day. He stated that during landing he experienced a crosswind of approximately 7 to 10 knots. The aircraft bounced, rocked up on the left main landing gear, departed the…NTSB ATL87LA182Accident · No injuriesLimited investigationFinal reportBeech B200 · Jasper, ALThe plt obtained a weather briefing for his proposed flt from birmingham, AL to Jasper, AL to allentown, PA. He did not file a flight plan for the 35 mile flt from birmingham to Jasper, however, he did file a flight plan for the proposed flt fm Jasper to…NTSB LAX87LA244Accident · No injuriesLimited investigationFinal reportNord 3202 · Bishop, CADuring a relocation flight of a newly purchased acft, the plt was making a cross wind landing when on touchdown the left wing raised. The plt corrected by applying left aileron, however, he also relaxed the back pressure on the control stick allowing the tail…NTSB LAX87LA242Accident · No injuriesLimited investigationFinal reportCessna 310R · Kailua, HIA Cessna 310R ditched in the pacific ocean aprx 500 NM sw Hawaii after an eng failure. The plt indicated that the #2 eng failed while in cruise flt at 8,000 ft MSL. Oil was observed leaking from the eng cowling. The acft was unable to maintain alt on #1 eng.…NTSB FTW87FA149Accident · No injuriesField investigationFinal reportPiper PA-60-601 · Hillsboro, TXAprx 3 min after leveling at 6500', the acft began losing pwr despite attempts to remedy the problem by using boost pump & x-feed. Subsequently, both engs lost power & the acft was damaged drg a wheels-up lndg in a milo field. An exam revealed the upper &…NTSB CHI87FA153Accident · 2 fatalField investigationFinal reportPiper PA-28R · Milwaukee, WIDrg arr at the Milwaukee/lawrence j timmerman arpt, the plt made 2 atmts to use the localizer 15L apch. After the 2nd missed apch, he elected to divert to Milwaukee/general mitchell fld (mke). At that time, he was adzd the mke wx was 300' ovc, 1/4 mi vis with…NTSB CHI87DEV02Accident · No injuriesFinal reportBell 47G2 · Peoria Heights, ILReturning from a powerline patrol flight, the engine surged twice and quit. The pilot executed an autorotation to the only available landing site, a high school football field. On touchdown the blades flexed and severed the tailboom. Investigation revealed…NTSB CHI87DEP07Accident · Serious injuriesFinal reportPiper PA-36 · Plover, WIAfter spraying most of a bean crop, the plt was making clean-up swaths over an area at the north side of the field. This area had bldgs to the west & trees to the east. To avoid flying toward the bldgs, the plt elected to make the passes to the east (toward…NTSB ATL87LA181Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Belton, SCThe pilot reported that while on short final he experienced a downdraft which caused him to land hard. The aircraft bounced and went off the left side of the sod strip. The pilot lost control of the aircraft after it bounced. The pilot estimated that surface…