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 MKC84LA280Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Davenport, IAAcft was on VFR final approach following a practice instrument flight. Commercial pilot with instrument rating in left seat flew instrument portion of flight and declined offer to land from instructor in right seat due to her lack of proficiency. On final…NTSB LAX84FA487Accident · No injuriesField investigationFinal reportCessna 550 · Santa Ana, CAAfter completing a dual instructional flt in 91 to 103 deg wx, the acft landed uneventfully. The PIC failed to follow the required procedure in the flight manual of turning off the anti-skid switch after clearing the rwy. Rather, he used the outdated…NTSB CHI84LA394Accident · No injuriesLimited investigationFinal reportBeech A-24R · Evansville, INShortly after take off, plt experienced complete electrical failure, later traced to a broken field wire on the acft alternator terminal. Plt returned for landing & placed gear handle in down position. Gear failed to extend (electrically operated). Plt made…NTSB ATL84FA292Accident · 2 fatalField investigationFinal reportMooney M20J · Lanett, ALCommunications with columbus apch revealed plt was unfamiliar with area and had difficulities finding the arpt witnesses viewed acft on final for rwy 08 with landing gear extended. Acft described as being low and slow. Witnesses stated engine sounds…NTSB ANC84LA186Accident · Minor injuriesLimited investigationFinal reportChampion 7KCAB · Anchorage, AKThe float equipped acft crashed while maneuvering near a small lake. The plt stated that while at 1000 ft AGL the eng 'coughed a few times and died'. The plt told the rescue crew that his eng iced-up while was at low alt. The passenger stated that the acft…NTSB NYC84LA316Accident · No injuriesLimited investigationFinal reportCessna 182H · Stonington, MEPlt was delayed in return flt to home arpt and arrived at the unlighted strip in darkness. The plt misjudged his runway alignment on approach, colliding with trees 15 ft from the runway during the landing flare.NTSB MIA84FA256Accident · No injuriesField investigationFinal reportDouglas DC3 · Boca Raton, FLFour hours and forty mins after takeoff aprx 6 miles from the dest aprt, both engs stopped running. Attempts to restart the engs were unsuccessful. Thinking they were out of fuel, the crew accomplished a forced landing in a wildlife refuge in 10 ft tall…NTSB LAX84FA484Accident · 2 fatalField investigationFinal reportMooney M20C · Mariposa, CAThe acft collided with a tree & telephone pole during a go-around maneuver on rwy 26. Investigation revealed that the acft exited the left side of rwy 26 about 1625 ft beyond the threshold. Although there were no eyewitnesses to the accident a ground witness…NTSB FTW84LA401Accident · No injuriesLimited investigationFinal reportPitts S-T1 · Rockwall, TXThe pilot reported that the rwy was clear when he turned on final. Once on final forward visibility is limited and the pilot did not see the cow until the acft collided with it. The airport manager was aware of the problem of cattle wondering onto the rwy but…NTSB DEN84FTE04Accident · No injuriesFinal reportHomebuilt KR 2 · Boulder, COPlt installed a different propeller on acft to increase RPM and thrust. After takeoff plt was unable to gain sufficient alt to clr trees on base leg. Precautionary landing was made on a highway. Plt applied right brake during landing roll and acft traveled to…NTSB DEN84FA298Accident · 1 fatalField investigationFinal reportCessna 182P · Glen Canyon, UTThe acft crashed into the 10388 ft high navaho mountain at about the 9800 ft level. Reportedly there was no moon that evening. The plt had departed hayward, CA at 1351 MDT & was enroute to farmington, NM. The acft crashed at 2027 MDT. Investigation revealed…NTSB CHI84LA393Accident · No injuriesLimited investigationFinal reportPickel Smith Miniplane · Covington, INThe pilot stated after the accident that during the landing roll the left wheel separated from the aircraft. The aircraft slid aprx 40 feet and nosed over. The plt stated that he had removed the main landing gear aprx 10 hrs prior to the accident to repack…NTSB ATL84LA291Accident · No injuriesLimited investigationFinal reportCessna 150L · Vine Grove, KYDuring landing roll on an 1800 ft sod airstrip, nose wheel began to shimmy and the plt initiated an aborted landing. Plt added full power and raised flaps to 10 deg. As acft approached power lines near departure end of the rwy plt made a slight left turn and…NTSB ANC84LA185Accident · 1 fatalLimited investigationFinal reportPiper PA-12 · Dadina Lake, AKPrior to the accident the plt had been involved in moose hunting activities. On the morning of the occurrence he had made two successful flts hauling meat from a small unnamed lake to Dadina Lake, about 3 miles north. Shortly after the third takeoff from the…NTSB NYC84FNE06Accident · Minor injuriesFinal reportBell 206L-1 · Somers, CTPlt stated acft began to settle and roll to right from stable 3 foot hover. Application of left cyclic did not arrest roll and main rotor made ground contact. Plt had 11 hrs in this make & model.NTSB NYC84FA314Accident · 6 fatalField investigationFinal reportPiper PA-32R-300 · Linden, NJAcft collided with utility pole during a night visual lndg. The pole is located about 583' from the rwy threshold and is 58' high. The pole was unmarked. The plt made 1 previous night lndg. At the arpt and 5 total lndgs at the arpt. The investigation did not…NTSB LAX84LA485Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Bishop, CAThe plt of the Bellanca said he saw a sailplane in front of him in the traffic pattern and pulled up to avoid a collision. The Bellanca stalled and even though it was partially recovered 500 ft before ground contact, the plt said he cut the engine and landed…NTSB LAX84FA483Accident · Minor injuriesField investigationFinal reportBell 206B · Long Beach, CAThe acft experienced a power loss during flare for landing. The plt pulled collective to soften the touchdown from 30 ftagl but the landing was hard. Post accident examination of the engine showed a failure of the #1 turbine disc. Lab exam of the disc showed…NTSB DEN84LA292Accident · No injuriesLimited investigationFinal reportAerospatiale SA315B Lama · Mountain View, WYThe helicopter experienced a loss of power during an external load operation. The plt released the load and performed an autorotation. A hard landing resulted during which the tail boom was severed by the main rotor blades. Metallurgical examination of the…NTSB DEN84FA293Accident · Serious injuriesField investigationFinal reportCessna 172K · Aspen, COAfter takeoff from a valley airstrip in mountainous terrain, plt elected to climb out straight ahead toward rising terrain instead of circling to gain altitude first (normal procedure). Approaching mountain pass, acft was observed climbing below level of the…NTSB ANC84LA184Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Montague Island, AKPlt was attempting takeoff from a sand bar which was not only soft but sloped to the right toward the water. On takeoff roll, the tailwheel was raised prematurely and directional control could not be maintained with rudder. The aircraft drifted downslope…NTSB ANC84LA181Accident · No injuriesLimited investigationFinal reportCessna 152 II · Skwentna, AKFBO had been experiencing difficulties with spark plugs and magnetos in this acft. The plt had flown this acft before with recurrent rough running and diminished power symptoms. Eng began to run rough on this flt and plt landed on a sand bar (marked for acft…NTSB ANC84LA179Accident · No injuriesLimited investigationFinal reportCessna 140 · Middle River, AKPlt stated right brake pressure was lost during landing roll. Acft veered off left side of rwy and contacted trees. Post accident testing revealed no evidence of a right brake failure or malfunction.NTSB ANC84FA190Accident · Serious injuriesField investigationFinal reportBellanca 8KCAB · Ouzinkie, AKPlt completed 5 turn spin, cockpit began filling with smoke. Electrical equipment was turned off and plt was descending for precautionary landing when elevator control was lost. Acft settled into 75 ft tall trees. Source of fire which resulted in battery…NTSB ANC84FA182Accident · No injuriesField investigationFinal reportCessna 152 II · Anchorage, AKThe student plt was performing touch-and-go lndg practice. On the second lndg touchdown, the left wing dipped. The plt applied right aileron and the acft continued toward taxi lights. Plt applied left rudder to avoid taxi lights and acft headed toward another…NTSB ANC84FA175Accident · Serious injuriesField investigationFinal reportCessna 180 · Anchorage, AKThe plt reported a ttl loss of power after being cleared to land on rwy 33 at merrill field. The acft contacted trees, a moving vehicle on 15th ave and an 8 ft high arpt fence during the forced landing. Examination of the acft eng failed to disclose any…NTSB SEA85FA016Accident · 1 fatalField investigationFinal reportCessna 172M · Aberdeen, WAAcft wreckage indicates impact was nose down inverted. No evidence was found of acft failure/malfunction. Plt departed on night cross-country after an evening out with friends. Wreckage found two months later, no toxicological tests possible.NTSB NYC84FGM07Accident · Serious injuriesFinal reportPiper PA-28-140 · South Fork, PAUpon departure the plt estimated 25 gal of fuel. The total power loss occurred 1 hr and 55 min later. After the forced ldg on unimproved terrain no evidence of fuel remained in the fuel system. There was no indication of any full spill from the ruptured left…NTSB MKC84FCD03Accident · Serious injuriesFinal reportSchweizer SGU2-22E · Ames, IAThe glider plt who had only about 1 hour flt time in this make of glider and less than a hour total glider time misjudged the wind and after drifting downwind was unable to make it back to the arpt. A forced landing was made off arpt in a farm field.NTSB MIA84LA255Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Rockledge, FLThe acft collided with a mound of dirt while executing a go-around at a private airstrip. The plt stated he selected rwy 27 based on winds reported at another airport and when the acft touched down about mid-point of the strip, 'I retracted flaps and applied…NTSB LAX84LA482Accident · Minor injuriesLimited investigationFinal reportGlobe GC-1B · Calistoga, CAThe starboard entrance hatch opened during takeoff roll. The pilot aborted the takeoff. The acft could not be stopped on the remaining rwy & collided with a ditch. The takeoff was attempted with a light tailwind on a unidirectional rwy.NTSB LAX84FUJ04Accident · 1 fatalFinal reportWeatherly 620 · Waddell, AZThe acft collided with a power line during a spray operation. Witnesses said the acft flew under a power line and as it pulled up collided with a line which angled off of the main line. The vertical stabilizer and part of the rudder separated. The acft nosed…NTSB FTW84LA399Accident · No injuriesLimited investigationFinal reportCessna 172N · Katy, TXPrior to the accident the CFI and student were in the acft when it rolled into a bean field while landing on a road which divided the field. After pushing the acft back onto the road a takeoff was attempted. Directional control was lostand the acft nosed over…NTSB DEN84LA291Accident · No injuriesLimited investigationFinal reportCessna 172P · Longmont, COThe plt was making a low pass over a strip he wanted certified. During an attempted go-around the eng would not respond so the plt landed. The acft ran off the end of the wet sod airstrip and nosed over. The plt said after the accident that the carburetor…NTSB DEN84FA278Accident · 2 fatalField investigationFinal reportPiper PA-18 · Meadow Lake, NMAccording to witnesses, the plt make a x-wind apch for a landing from west to east in winds that were from the south at 10 to 12 mph. Reportedly the acft touched down with the right wing high, then the plt applied power & initiated a go-around at about…NTSB CHI84LU011Accident · Serious injuriesFinal reportReicher FP-101 · Mankato, MNThe pilot of the ultra-light stated that he made a take-off and climbed to about 30 ft then attempted a right turn. He said the aircraft stalled and crashed into the soybean field field. The pilot reported 12 previous flights but no pilots certificate.NTSB CHI84LA392Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Grand Rapids, MIIn an effort to land at the threshold the acft collided with a fence and landed short of the prepared surface. Runway edge lights were operating but runway end identifier lights were not installed.NTSB ATL84LA288Accident · No injuriesLimited investigationFinal reportCessna 182 · Waynesboro, VAThe pilot stated that while on final approach the aircraft encountered a downdraft and was forced down short of the runway. Pilot suggested that he may have also encountered possible wind shear.NTSB ATL84LA287Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbus, GAThe plt departed deland, FL, for Columbus, GA, with an intended fuel stop at americus, GA. While en route from deland to americus the ceiling became lower than forecast and the plt made the decision to fly at 8500 ft MSL staying above the cloud layer. With…NTSB ATL84LA281Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Cheraw, SCAccording to the plt, after 100 to 150 ft of landing roll the right main landing gear collapsed.NTSB ANC84LA177Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Point Hope, AKThe acft crashed during an attempted night takeoff with the plt controlled rwy lights turned off. The plt stated he had consumed a couple of alchoholic beverages earlier in the evening; and although approached by several people to fly, he stated he refused…NTSB SEA84LA229Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Kelso, WAClimbing through 4,000 ft the engine failed. Emergency procedures resulted in a momentary restoration of power prior to the forced landing. During final approach the left wing struck a tree. The right main landing gear collapsed during the landing roll.…NTSB SEA84LA221Accident · No injuriesLimited investigationFinal reportCessna T206 · Austin, NVPersonnel employed by the operator stated that the pilot flew the acft for 1.8 hours the night before the accident. Without refueling, the plt flew for 3.6 hours when the engine failed due to fuel exhaustion. During the forced landing roll the acft traveled…NTSB NYC84LA315Accident · No injuriesLimited investigationFinal reportCessna 182Q · Laurel, MDWith the northerly wind gusting to 22 KTS the acft landed aprx 4/10 the way down the rwy and bounced 3 times. An abort was initiated with power but the acft rolled off the end of the strip across a grass field and into a growth of small trees, nosing over…NTSB NYC84FA313Accident · Serious injuriesField investigationFinal reportPiper PA-34-200T · Buffalo, NYThe acft crashed on main street, Buffalo, NY, while executing a forced landing during an air taxi cargo operation. Investigation revealed that based on fuel consumption calculations the plt had not allowed for all contingencies during his orginal flt planning…NTSB MKC84LA279Accident · No injuriesLimited investigationFinal reportCessna 182D · Rolla, MOThe plt tried to 'balloon' over a pack of dogs on the rwy and stalled the acft. The resulting hard landing failed the nose gear and damaged the firewall.NTSB MIA84LA254Accident · No injuriesLimited investigationFinal reportCessna 152 · Key West, FLThe pilot stated to the chief of the FAA control tower at Key West int'l arpt after the accident that she 'porpoised' on landing, striking the nose gear and causing it to collapse.NTSB MIA84FA253Accident · Serious injuriesField investigationFinal reportPiper PA-28-161 · Culebra, PRThe plt was advised by other plts that a missed approach was not possible at this arpt on rwy 31. All other plts in the group landed on rwy 13. The accident plt elected 31 until he was on final with a tailwind and then started a go-around. The rising terrain…NTSB LAX84FA481Accident · Serious injuriesField investigationFinal reportPiper PA-28-236 · Santa Paula, CAAfter departing rwy 22 at Santa Paula arpt, the acft flew sw along the Santa clara river + struck a telephone wire 2.6 sm from the rwy end. Witnesses saw acft fly level at about 8O ft AGL with normal power sounds prior to wire contact. Thewire strike caused…NTSB FTW84LA398Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Seguin, TXThe acft crashed during the takeoff phase of a touch-&-go landing. The student plt stated that the wind direction and speed had changed at lift-off causing the acft to become airborne then to descend and hit the ground before coming to a stop inverted.