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 DEN87LA123Accident · No injuriesLimited investigationFinal reportCessna 150 · Akron, COThe student plt had just purchased N8649G and had decided to fly it. He had not been endorsed for solo flt. After a successful takeoff and a short cross-country flt, he returned to the Akron aprt for landing. During the attempted landing, control of the acft…NTSB DCA87MA031Accident · 2 fatalMajor investigationFinal reportLearjet 35A · West Mifflin, PAThe coplt (dual student) was to get a prof check on the 1st leg of the flt with a simulated single eng pwr loss on tkof. According to witnesses, the tkof was normal until lift-off aprx 3200' down the rwy; but after lift-off, the acft clbd only about 50' &…NTSB BFO87LA036Accident · No injuriesLimited investigationFinal reportBeech C-24R · Chestertown, MDThe pilot, unfamiliar with the airport, intended to perform a trial takeoff run to determine how the aircraft accelerated on the grass runway. During the trial run when the aircraft was about half way down the runway, the pilot felt the aircraft was ready to…NTSB MKC87LA111Accident · No injuriesLimited investigationFinal reportCessna 150H · Miami, MOThe pilot had completed the landing at a private airport and was taxiing at the edge of the gravel runway. He hit a clump of grass and dirt and partially collapsed the nose gear.NTSB FTW87LA124Accident · No injuriesLimited investigationFinal reportCessna T210N · Tahlequah, OKThe right brake disk separated from the hub when brakes were applied during landing rollout. The aircraft veered left off the runway and into a drainage ditch where the horizontal stabilizer contacted the ground, damaging both of its spars.NTSB ANC87LA068Accident · No injuriesLimited investigationFinal reportCessna 305 · Port Heiden, AKThe pilot attempted a landing on the beach. After the landing roll the aircraft struck a sand bar causing the aircraft to nose over on its back.NTSB SEA87LA095Accident · No injuriesLimited investigationFinal reportPiper PA-20-115 · Seattle, WADuring landing roll with a crosswind from the right a ground loop occurred. The pilot had just completed a solo cross country flight. The wind was from 210 degrees at 9 knots. The pilot was landing on runway 13L.NTSB LAX87LA204Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Chandler, AZDuring an instructional flt, the student plt had control of the acft during a soft field take-off. The student did not keep the acft aligned with the centerline even after the instructor told the student to add right rudder to stop the drift. Just prior to…NTSB LAX87DUM03Accident · 2 fatalFinal reportChance Vought F4U-7 · Chula Vista, CAThe pilot of the F4U was giving the passenger a ride in appreciation of her volunteer work she contributed to an airshow conducted at brown field in san diego, California. Ground witnesses observed the F4U enter an inverted dive from an altitude of about 1500…NTSB FTW87LA117Accident · No injuriesLimited investigationFinal reportCessna 152 · Okmulgee, OKDuring a normal uneventful approach, and upon touchdown, the aircraft's nose gear collapsed for undetermined reasons. The aircraft slid to a stop causing substantial damage.NTSB DEN87FA121Accident · 2 fatalField investigationFinal reportNorth American T-28D · Tatum, NMAccording to friends of the plt, the acft left roswell, new Mexico, with 2 people aboard after an airshow with a destination of lovington, NM. Witnesses observed the acft flying in the distance and then observed a big cloud of dust rising from the ground. The…NTSB ATL87FA136Accident · 2 fatalField investigationFinal reportPiper J4A · Collierville, TNIt was reptd that the plt was taking his pax up for a LCL photographic flt at the req of the pax. Witnesses reptd that the acft remained over the apt for two or three circuits and then deptd the area in the dir of Collierville. Witnesses near the crash site…NTSB ATL87FA135Accident · 3 fatalField investigationFinal reportBeech 35 · Avon, OHAcft was seen heading east on a downwind for the private airstrip where it was based. It was turned onto the base leg and as a turn was begun for the final approach course for rwy 27 it stalled, spun, and collided with the ground. The acft wreckage was found…NTSB SEA87LA161Accident · No injuriesLimited investigationFinal reportGrumman AA1B · Ocean Shores, WAThe plt landed his acft onto a golf course which had been the previous site for the airport. The airport had been closed since December 1985 and relocated close by. The pavement at the old airport had been replaced by sod. During landing roll, the aircraft…NTSB SEA87LA091Accident · No injuriesLimited investigationFinal reportBell 206-B · Sloan, NVWhile climbing at a slow airspeed at a low altitude above the ground during strong gusting wind conditions, the pilot initiated a right turn and encountered an uncommanded right yaw. The aircraft completed several right spinning turns, impacted the ground,…NTSB SEA87IA093Incident · No injuriesIncident investigationFinal reportStinson 108-1 · Idaho Falls, IDDuring a go around the pilot decided to attempt to reland the aircraft. Gusty crosswind conditions existed at the time and directional control was lost during which the aircraft entered into a ground loop maneuver and the left main landing gear strut…NTSB NYC87LA144Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Caldwell, NJDrg a ngt takeoff, the eng lost pwr shortly after lift-off & the plt chose an area away from bldgs & obstructions for an emerg landing. However, drg the landing, the acft was extensively damaged. An exam revealed the rgt fuel tank was empty & the left tank…NTSB MKC87FA103Accident · 2 fatalField investigationFinal reportChampion 7EC · Delia, KSWitnesses stated that the aircraft was performing high speed, low level passes over the homes of some friends and relatives when, suddenly, it started a steep climb over a tree line. The aircraft appeared to slow down at the top of the climb; then it leveled…NTSB DEN87LA122Accident · No injuriesLimited investigationFinal reportBeausoleil Acro Sport · Englewood, COThe commercial plt was flying his experimental acro sport 1 in the local area. After about an hour of acrobatic practice, he returned for landing to his home arpt. The plt accepted rwy 28 due to heavy traffic. The winds were reported as 050 degrees at 8…NTSB CHI87LA126Accident · No injuriesLimited investigationFinal reportCessna 150E · St. Johns, MIThe plt reported that a gust of wind caught the acft during landing and he immediately added full power in a go-around attempt. The plt stated that the acft then stalled in trees and a fence row.NTSB CHI87LA125Accident · No injuriesLimited investigationFinal reportCessna 120 · Lebanon, INWhile landing on runway 18, pilot lost directional control and veered off left side of runway into a gully. The pilot stated prior to landing he received winds reported from 220 degrees at 11 knots through ATIS.NTSB BFO87LA035Accident · Serious injuriesLimited investigationFinal reportBeech A23 · Ravenswood, WVThe pilot was providing free promotional rides for a flight school. He was on the fourth flight of the day, on final approach, in a nose high attitude when the aircraft's left wing struck small trees. The aircraft impacted the ground 250FEET short of the…NTSB SEA87LA090Accident · Minor injuriesLimited investigationFinal reportRutan VARI-EZE · Renton, WAWhile being hand propped the aircraft began to move. The pilot then attempted to climb inside the aircraft but the canopy had closed. The pilot held onto the aircraft and was dragged across the end of the runway. The aircraft struck a parked, unoccupied…NTSB SEA87LA089Accident · 2 fatalLimited investigationFinal reportWoehrle FLUT-R-BUG SA6B · Gleneden Beach, ORImmediately after takeoff and while engaged in a tight climbing turn at low alt the pilot allowed the aircraft to enter a stall condition. Plt failed to recover before impacting the ground.NTSB NYC87LA142Accident · Serious injuriesLimited investigationFinal reportPik 20 · Julian, PAThe glider was assembled and all controls checked for freedom of movement prior to takeoff. During initial takeoff and climb, while in tow, the acft pitched nose up abruptly breaking the tow rope. The acft was then observed to turn right and nose down into…NTSB MIA87LA158Accident · Serious injuriesLimited investigationFinal reportCessna 337E · San Juan, PRThe plt stated that during the base leg with 2/3 flaps lowered the acft entered an uncontrolled left bank. Control was partially regained, however, the acft then entered a spin to the left. Control was not established before the acft crashed into the ocean…NTSB LAX87LA203Accident · Minor injuriesLimited investigationFinal reportBeech A65 · Coalinca, CAThe pilot attempted to takeoff from the 2,820 foot runway with a makeshift flight control gust lock in place. He was unable to liftoff with the controls locked and the nose gear collapsed when the aircraft overran the runway onto the rough/uneven terrain.NTSB LAX87DVG07Accident · No injuriesFinal reportGrumman G-164A · Lambertsville, CAThe pilot stated that shortly after takeoff the engine 'cut out' several times then quit completely. The pilot made an emergency landing on a plowed field and during the landing roll the aircraft nosed over. The accident was not reported for 4 days and during…NTSB FTW87FA116Accident · No injuriesField investigationFinal reportBeech V35-B · Terrell, TXWhile attempting to start the aircraft the starter solenoid wiring caught fire. The heat from the fire caused an overstressed brake line to fall, allowing brake fluid to drain onto the lip of the nose gear door. The fire then burned through the floor of the…NTSB DEN87LA120Accident · No injuriesLimited investigationFinal reportBell 47G3B2A · Brigham City, UTAn ag plt was ferrying a helicopter to another job in his local area. The plt, an ATP, had estimated that the helicopter had enough fuel for the flt. The helicopter's engine quit and an autorotation was performed, resulting in a hard landing. Less than one…NTSB DCA87MA030Accident · 2 fatalMajor investigationFinal reportCASA C-212-CC · Mayaguez, PRAfter several maintenance adjustments of the right propeller and flight idle fuel flow, the aircraft was test flown and released for flight. Several pilots continued to note descrepancies concerning the right propeller system. Adjustments were made and the…NTSB BFO87LA034Accident · Minor injuriesLimited investigationFinal reportAyres Turbo Thrush 52R34 · Lavale, MDWhile spraying for gypsy moths during the early morning, the turbo-thrush collided with static wires located on top of high tension lines. The pilot stated that he did not see the wires because they were located on the shady side of an adjacent mountain.NTSB ATL87LA137Accident · Serious injuriesLimited investigationFinal reportMoss Timothy C Quicksilver MX · Monroe, NCThe student plt reported that the engine lost power while the ultralight-type acft was on final approach to a mowed field owned by him. The acft subsequently impacted a tree at the end of the field and fell to the terrain nose-down. The student pilot noted…NTSB ATL87LA134Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Butler, ALThe student plt reported that a gust of wind 'caught' the airplane's left wing shortly after takeoff at about 100 ft AGL; he subsequently 'lost control' and the airplane 'went down'.NTSB MKC87LA102Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Fayetteville, ARThe PIC was demonstrating the helo to a prospective customer. The PIC was hovering in a remote area with rough and uneven terrain. The PIC rptd outside air temps of abt 90 degrees during the demo flt. The PIC stated that he was moving around over the grnd in…NTSB MKC87DCQ02Accident · Serious injuriesFinal reportCessna 188 · Harper, KSThe pilot was preparing to spray a wheatfield. During the second 1/3 of procedural turnaround, the aircraft struck powerlines, then the ground. The aircraft was destroyed by post-impact fire.NTSB FTW87LA114Accident · No injuriesLimited investigationFinal reportAyres S2R-1820 · Ville Platte, LAAfter landing on a wet grass strip the pilot realized that the aircraft was not going to stop. Obstructions off the end of the runway prevented a go-around. The aircraft collided with two trees causing substantial damage.NTSB ANC87FA067Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Nightmute, AKThe aircraft was destroyed when the aircraft struck a 350 foot high hill along its route. This flight was a part 135 on-demand air taxi cargo flight. Several other air taxi operators and company aircraft elected to cancel their flights. Both ground reports…NTSB MIA87FA157Accident · Serious injuriesField investigationFinal reportCessna 150M · San Juan, PRThe plt stated that he performed his run up check with 'normal results.' Ten degrees of flaps were set for a soft field takeoff, & during the takeoff roll, 'the aircraft ran normal.' At aprx 55 mph 'the aircraft left the ground and immediately it settled down…NTSB LAX87DVG06Accident · Minor injuriesFinal reportAyres S-2R · Williams, CAThe plt reported he heard something break. The sound was followed by a vibration. The plt then turned to land on a road. He was unable to maintain alt and airspeed. The rockwell S2R landed in a cultivated field and nosed over after a collision with a dirt…NTSB DEN87LA119Accident · No injuriesLimited investigationFinal reportCessna A188B · St. Ignatius, MTAn ag plt was spraying a field near the local arpt, at 100 feet AGL. During an aerial application maneuver, the engine made a loud bang and stopped. The plt leveled the acft, selected a landing site and landed. During the roll out, the acft crossed an…NTSB CHI87LA123Accident · Minor injuriesLimited investigationFinal reportCessna A152 · Gobles, MIDuring the third leg of a cross-country flight, the pilot reported that the sun was directly in his eyes while on final approach to rwy 27. He stated he first saw the set of power lines when they were about 25 feet ahead of the aircraft. While attempting to…NTSB CHI87FA124Accident · 1 fatalField investigationFinal reportCessna 152 · Ina, ILBefore the flt, the plt stated his intentions were to practice ngt lndgs. He took off at 2010 CDT with an estd 1.5 hrs of fuel on board. When the acft did not return, a search was initiated. Subsequently, it was fnd by fishermen, submergedin a lake…NTSB BFO87DIG03Accident · Minor injuriesFinal reportPiper PA-28-161 · Frederick, MDShortly after liftoff the pilot stated that the left wing dropped and the aircraft began to turn to the left. He appliedright aileron and raised the nose to clear parked aircraft but the aircraft struck an automobile that was parked in front of a hangar and…NTSB ATL87LA133Accident · No injuriesLimited investigationFinal reportBeech E-55 · Spartanburg, SCThe plt reported that he lowered the ldg gear and observed a down-and-locked indication on the ldg gear position light on final appch. During rollout, he felt a severe vibration in the nose gear and pulled back on the yoke in an attempt to reduce it. He then…NTSB ANC87LA066Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Kenai, AKThe pilot stated during a low level flight above the trees, the aircraft started to vibrate. A few seconds later the propeller completely separated from the aircraft. The propeller was not located in the wooded area. The propeller separated from the aircraft…NTSB NYC87LA141Accident · No injuriesLimited investigationFinal reportCessna 172K · Palmyra, PAStudent pilot experienced up and downdrafts while on approach for landing at reigle airport. The pilot was unable to maintain directional control during roll out, ran off the left side of the runway, and across a grass field. The acft then nosed over when the…NTSB CHI87LA122Accident · No injuriesLimited investigationFinal reportCessna 152 · Footville, WIPilot landed in a field to practice an emergency landing. After two unsuccessful attempts to takeoff from the soft, plowed field, the pilot taxiied onto a two-lane road. On lift off the left wing struck a road sign.NTSB FTW87FA111Accident · No injuriesField investigationFinal reportBell 206B · Ft. Worth, TXWhile demonstrating a low level 180 degree autorotation to a rated pilot, the CFI undershot his intended touchdown point. In an attempt to reach his selected touchdown point, the pilot allowed the rotor RPM to decay and the aircraft developed a high sink…NTSB ANC87LA065Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · North Pole, AKThe pilot stated that shortly after lifting off the water the engine quit; the aircraft crashed on the gravel bar. The pilot also stated that he ran out of fuel. The plts flt time was not reported or available.