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 LAX87FA298Accident · 1 fatalField investigationFinal reportCessna 150M · Newport Beach, CAOn a dark night beneath a scattered to broken marine layer of stratus clouds the plt made a low altitude pleasure flight 1/4 mi off shore. The acft entered a gradual descent, collided with the ocean and the plt drowned.NTSB LAX87FA296Accident · No injuriesField investigationFinal reportCessna 152 · Palo Alto, CAA midair collision occurred abt 2.8 mi west of Palo Alto arpt (pao) as Cessna 152, N152SC, was on a left x-wnd dep fm rwy 30 & Mooney 20J, N5201Y was transitting the arpt traffic area (ata) fm se to NE & dscndg fm 2400' to 1500'. N152SC was on twr freq.…NTSB FTW87LA192Accident · No injuriesLimited investigationFinal reportCessna 170A · San Marcos, TXThe student pilot lost directional control when the tail wheel came off the runway. The instructor pilot stated that he was late with corrective action and the aircraft ground looped off the runway.NTSB FTW87DRG06Accident · Minor injuriesFinal reportWilliam M. Burge Tern · Refugio, TXOn August 8, 1987, a burge tern, N38826 impacted a transmission wire and subsequently, the terrain while attempting a forced landing to a field approximately 7 miles west of Refugio, Texas. The homebuilt glider had flown approximately 18 miles northwest of…NTSB FTW87DRA08Accident · No injuriesFinal reportArnold VP-2 · Baytown, TXThe newly constructed homebuilt acft experienced an eng failure during it's first takeoff. During the ensuing forced landing the acft collided with trees, substantially damaging both wings. The cause of the engine failure was not determined during the…NTSB DEN87LA214Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Greeley, CON8433D was being flown by the plt/owner with an instructor aboard for the purpose of up-dating the owner's flying proficiency. Several successful landings were made, then a wheel landing was initiated. After touchdown, the acft swerved to the left, departed…NTSB DEN87FA213Accident · 1 fatalField investigationFinal reportPiper PA28-140 · Last Chance, COWhile on a cross country flt the plt encountered IFR conditions and was neither trained nor qualified to fly IFR. Attempts by ATC to assist the plt and route the flt to an arpt were unsuccessful. The plt lost control of the acft and crashed in a field, the…NTSB CHI87IA188Incident · No injuriesIncident investigationFinal reportBoeing 727-233 · Chicago, ILAir Canada flt 839 (Boeing 727, c-gyne) was depg Chicago o'hare intl arpt as Cessna 650 (citation), N20AT, was depg palwaukee (pwk) arpt, about 8 mi north of o'hare. Both flts tkof with IFR flt plans. Bfr the citation tkof, the pwk twr ctlr ctcd the TRACON…NTSB ATL87DEK02Accident · 1 fatalFinal reportAllen Pitts Special S-1 · Lancaster, OHN52LA was being flown in a 2-acft acrobatic demonstration (demo). After takeoff, the plts bgn the demo by passing each other in a low alt knife edge maneuver over the rwy. After passing, they rolled inverted, until near the ends of the rwy, then rolled…NTSB ATL87DEI11Accident · No injuriesFinal reportCessna 172P · Stow, OHThe pilot flared too high on landing and the aircraft bounced on touchdown. The pilot did not use the proper technique to recover from the bounced landing and lost control of the aircraft. The aircraft departed from the runway and struck two taxi lights and a…NTSB ANC87LA116Accident · No injuriesLimited investigationFinal reportCessna 172 · Pt. Mackenzie, AKAfter a complete engine failure and an emergency landing on the beach, the pilot lost directional control of the aircraft causing the plane to nose over on its back. Examination of the engine revealed a blocked oil screen which caused oil starvation.NTSB ANC87FA117Accident · 1 fatalField investigationFinal reportCessna 207 · Crooked Creek, AKThe acft overflew the destination due to fog. The station manager stated that after transmitting to the plt that the wx was 'zero zero', the plt stated that he would continue on to red devil and she heard it fly overhead. The first pieces of acft debris were…NTSB SEA87LA159Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Hamer, IDThe plt rprtd that he bgn taking off on a downhill strip (aprx 1/2 mi long) with a left quartering tail wind. As the takeoff roll progressed, he realized an overrun was developing, so he bgn dumping his load & attempted to lift- off. He said the acft settled…NTSB NYC87LA219Accident · No injuriesLimited investigationFinal reportMooney M20C · Mclean, NYThe aircraft had flown for about 1-1/2 hours when the pilot began a descent from 12000 feet for an approach. However at 3500 feet, the engine suddenly went from normal cruise to idle. An emergency landing was made in a corn field and the aircraft was…NTSB MKC87LA158Accident · No injuriesLimited investigationFinal reportBeech 58 · Arkansas City, KSDuring ldg roll, following a personal flight, the acft had a failure of the left main gear tire. The PIC said the acft began violently shaking and wobbling followed by collapse of the left main lndg gear. The acft swerved off the runway and incurred…NTSB MKC87LA157Accident · No injuriesLimited investigationFinal reportBeech B19 · Little Rock, ARThe instructor said they were on an instructional flight practicing accuracy landings when they lost airspeed, added power, and ran out of stabilator. The student said the instructor was demonstrating a short field landing when they lost airspeed and hit…NTSB MIA87LA224Accident · No injuriesLimited investigationFinal reportBell 47J-2A · Orlando, FLDuring the apch to land the tail rotor drive assy failed resulting in a momentary loss of control. The plt then autorotated & landed on the company helipad, during which the helicopter sustained substantial damage. Examination of the tail rotor drive assy…NTSB LAX87LA297Accident · No injuriesLimited investigationFinal reportPiper PA28-161 · Redding, CADuring an air race, the plt was attempting a landing when on final approach the acft flew through updrafts. The plt landed the acft aprx 600 ft from the threshold and applied heavy braking. Just prior to running off the runway the pilot added full power and…NTSB LAX87IA303Incident · No injuriesIncident investigationFinal reportBoeing 747-300 · Los Angeles, CADrg arr, japan airline flt 62 (Boeing 747, JA-8163) was initially vectored (by lax ARTCC) for an ILS rwy 24R apch in reduced visibility (haze). Bfr turning final, flt 62 was adzd of an acft that was 4 mi ahead. Flt 62 rprtd that they had the acft in sight.…NTSB FTW87FA190Accident · No injuriesField investigationFinal reportCessna 206G · Georgetown, TXTeardown of the aircraft engine revealed that the engine counterweight vibration damper assembly was out of tolerance. This allowed excessive engine vibration which resulted in failure of the camshaft drive gear and total engine failure. The pilot executed a…NTSB DEN87LA211Accident · No injuriesLimited investigationFinal reportNorth American AT-6A · Englewood, COThe plt does not possess a single engine airplane rating. The plt had a total of 18 hours in the AT-6A. Pilot was departing on a pleasure flt. Witnesses stated that the aircraft appeared to rotate prematurely, climbing at a slow airspeed and a high angle of…NTSB DEN87LA210Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Albuquerque, NMThe private plt was returning from a business flight. The plt reported that the engine quit during the approach to landing. An emergency landing was made in an open field. The right wing hit a sign and skidded to rest across a paved road and into another open…NTSB ATL87LA228Accident · No injuriesLimited investigationFinal reportCessna 152 · New Albany, OHThe airplane nosed over during a forced ldg in a soft field. The CFI reported that he had initiated a simulated engine power loss at about 2200 ft AGL by either pulling the mixture control or by turning off the fuel selector; he could not recall specifically…NTSB SEA87FA158Accident · 1 fatalField investigationFinal reportCessna 150J · Las Vegas, NVThe student plt planned a x-country flt for 3.6 hrs. After 3.9 hrs of flt, fuel exhaustion occurred as the acft was apchg the destn arpt. The plt declared an emergency, but was unable to glide to the arpt. Witnesses observed the acft on an apch to a vacant…NTSB LAX87LA295Accident · Serious injuriesLimited investigationFinal reportNorth American T-6G · Butte City, CADuring a local flight, a witness observed the acft making shallow right turns at aprx 100 ft AGL. The acft suddenly nosed down and collided with the terrain. Neither the plt nor the passenger remember what happened. Inspection of the engine revealed…NTSB CHI87LA189Accident · No injuriesLimited investigationFinal reportAeronca 15AC · St Bonifacius, MNThe plt had just purchased the acft & had obtained a ferry permit to fly it to another arpt. He reached the vicinity of the destn & called the tower, but did not see the arpt. Aprx 15 min later, when he was sure he had passed the arpt, he made a 180 deg turn…NTSB CHI87FA187Accident · No injuriesField investigationFinal reportPiper PA-28 · Fairwater, WIWhen the plt attempted to add pwr to level off from a dscnt, the eng did not respond. He then applied carb heat & tried to restart the eng, but to no avail. During an emerg landing, the acft touched down with a tailwind, struck a fence & skidded to a stop in…NTSB CHI87DEE09Accident · Serious injuriesFinal reportRobertson B1-RD · Kankakee/Elks, ILDuring a takeoff from a golf course fairway the acft collided with a tree and crashed. A sketched description of the scene revealed only 60 yards between the starting point of the takeoff and the tree. In spite of this, the plt stated that he climbed to about…NTSB ATL87LA227Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Hopeful, GAThe plt was lndg on a unidirectional ag strip with a tail wind & a thunderstorm (tstm) nearby. He rprtd that drg the roll-out, a gust of wind from the tstm picked up the tail of the acft & flipped the plane over on its top. He estimated the wind was from the…NTSB ANC87FA115Accident · 1 fatalField investigationFinal reportPiper PA-18A · Coldfoot, AKThe pilot had unsuccessfully attempted to fly through atigun pass earlier in the day. Even though the pass was closed due to fog and cloud cover, the pilot attempted to fly through the pass a second time. The aircraft wreckage was locatedin atigun pass. The…NTSB SEA87LA157Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · North Plains, ORThe plt rprtd that drg a x-wind lndg, the acft touched down on the rgt main gear, then after rolling aprx 50 to 100 ft, the left main gear touched down. As the left wheel touched down, the left axle failed, pitching the acft on its nose. The acft then skidded…NTSB NYC87LA222Accident · No injuriesLimited investigationFinal reportRobinson R22 · Burrville, RIAircraft lost engine power shortly after takeoff at an altitude of about 200 feet. Pilot attempted to autorotate back to the lake but during a turn to avoid collision with a boat, the helicopter crashed into the water. The reason for the engine power loss was…NTSB LAX87LA294Accident · No injuriesLimited investigationFinal reportBell 47D-1 · Taft, CAThe plt rprtd the eng lost power at about 300' AGL after the helicopter had flown aprx 2.7 hrs without refueling. He initiated an autorotative landing; however, before touchdown, the main rotor blades contacted & severed the tail boom. An exam revealed the…NTSB LAX87LA293Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Chinle, AZAt the end of a cross country flt, the plt reported that on the first attempt to land on a dirt road the airspeed and alt were high so he elected to go-around. On the second attempt the approach was too slow and the acft stalled aprx 8 ft AGL. The acft…NTSB LAX87DVD04Accident · No injuriesFinal reportHiller UH-23-D · Brentwood, CADuring an aerial application flight, the tail boom weight separated and contacted the tail rotor. The pilot lost control of the aircraft and collided with a tree and subsequently the terrain. Post acc invest revealed that the 'pip pins' which secure the tail…NTSB LAX87DUG06Accident · Minor injuriesFinal reportCurtiss JN-4 · Riverside, CADuring a business flight, the engine experienced a loss of engine power. The pilot made a forced landing in an open area where during the touchdown, the aircraft was substantially damaged. The plt stalled the acft while still several ft off the ground. The…NTSB FTW87LA189Accident · Minor injuriesLimited investigationFinal reportBeech V35B · El Reno, OKAcft bounced on touchdown and began porpoising down the runway. According to the plt, following the second bounce, the rt front seat passenger applied full throttle and the acft veered left into a fence. After striking the fence the nose gear collapsed when…NTSB FTW87DQG02Accident · No injuriesFinal reportPiper PA-25 · Lubbock, TXThe toe of the pilots left boot was rubbing on the dispensing hopper which restricted application of rudder and brake. This resulted in a loss of control when exiting the runway and the resultant collision with a sign. The fiberglass hopper had deep abrasions…NTSB CHI87LA186Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Nobelsville, INThe 160 hr tt pilot, recently checked out in this make/model acft, was returning to home base on a x-country flt. He ld long and was unable to stop before hitting a fence off the departure end of the rnwy.NTSB CHI87FA185Accident · Serious injuriesField investigationFinal reportCessna 120 · Oshkosh, WIThe plt was taxiing out of the antique/classic camping area at Oshkosh with the assistance of wing walkers when he stopped to permit the pax (his wife) to perform an errand. The pax deplaned & went under the outer 1/3 of the wing strut, then walked back into…NTSB ATL87LA226Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Ardmore, ALThe engine lost pwr during initial climb at about 150 ft AGL shortly after the plt turned the fuel boost pump off. A forced ldg was subsequently made on a nearby interstate hwy. the plt delayed the ldg to avoid hitting autos on the hwy and a hard ldg…NTSB ANC87LA114Accident · 1 fatalLimited investigationFinal reportChampion 7ECA · Central, AKDuring an interview in the hospital with the passenger who was the pilot's son, he stated to the FAA inspector that his dad was low level flying when the aircraft struck a tree. The pilot lost control of the aircraft and crashed. At the time of the accident…NTSB SEA87LA160Accident · No injuriesLimited investigationFinal reportCessna TR182 · Eatonville, WAThe plt rprtd that drg a lndg, the apch was a little high & the acft touched down long on the turf/gravel rwy. He thought there was sufficient rwy remaining to stop & did not initiate a go-around. However, he said 'braking on dry grass & moss was not…NTSB SEA87LA155Accident · No injuriesLimited investigationFinal reportBellanca 14-19-3A · Mahoney Creek, IDDrg arrival, the plt inadvertently lndd at the mohoney Creek arpt with a 2050' strip, instead of the intended arpt (indian Creek) which had a 5000' rwy. The arpt elev was 4618'; the density alt was about 7800'. While landing, an overrun occurred & the landing…NTSB SEA87LA154Accident · No injuriesLimited investigationFinal reportCessna 150M · Austin, NVThe plt was flying up a canyon when he realized the canyon was closing & he had no way of turning around. He was unable to outclimb rising terrain. Subsequently, the acft crashed into several small pine trees & was extensively damaged. The density alt at the…NTSB NYC87LA223Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Prospectville, PAThe student plt was practicing takeoffs & landings. He rprtd that on the 2nd apch, he appeared to be landing too long, so he initiated a go-around. However, he said the acft then entered a departure stall & settled into shrubs & trees adjacent to the rwy.NTSB NYC87LA221Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · N. Andover, MAThe aircraft lost power shortly after takeoff. The instructor pilot took control and due to the lack of altitude decided to land the acft straight ahead. The aircraft was landed on the grass beside the runway. Teardown of the engine revealed a stuck valve.…NTSB NYC87LA214Accident · No injuriesLimited investigationFinal reportBeech B19 · Augusta, METhe student plt rprtd that during a practice landing, he rounded out too high. Subsequently, the acft bounced hard & the nose gear collapsed. After coming to rest, the plt exited the acft, but a fire erupted & the acft was destroyed.NTSB NYC87LA213Accident · No injuriesLimited investigationFinal reportCessna 172P · Plainfield, CTWhile landing in crosswind conditions, the pilot failed to compensate for the conditions and lost directional control of the aircraft. The aircraft went down an embankment, collided with a fence and then flipped inverted.NTSB MKC87LA156Accident · No injuriesLimited investigationFinal reportCessna 150M · Atchison, KSThe solo student pilot was practicing touch and go landings. The pilot stated he had successfully performed 2 landings. On the third landing the aircraft touched down to the left of the runway's centerline, veered right and off the runway. Investigation…