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 FTW85LA299Accident · No injuriesLimited investigationFinal reportBeech 35-B33 · Alpine, TXThe plt experienced a partial pwr loss when about 50 ft above the rwy, just after liftoff. The acft was about 300 ft down the rwy with some rwy still remaining. He landed the acft but was unable to stop until the acft had run through the perimeter fence. It…NTSB CHI85LA340Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Sharonville, OHAccording to the plt, the eng quit 4 hrs into the flt due to 'apparent fuel exhaustion.' He had entered the blue ash traffic pattern instead of going to his original destination because his fuel gages read 1/8 full instead of 1/4 full as he had expected. The…NTSB CHI85LA326Accident · No injuriesLimited investigationFinal reportCessna 177B · Kankakee, ILThe plt landed on the 5100 ft x 100 ft rwy, porpoised several times, lost directional control and veered off the rwy. The nose gear broke off and the acft nosed down.NTSB CHI85LA319Accident · Minor injuriesLimited investigationFinal reportPiper PA-20 · Madelia, MNDuring cruise engine power was lost. The pilot was unable to restart the engine. During landing in an oats field the acft nosed over.NTSB CHI85LA318Accident · No injuriesLimited investigationFinal reportBeech C33-A · Hobart, INThe eng lost complete pwr during cruise. The plt landed on a road and the acft collided with a pile of gravel. Fuel was found in both tanks, however, the bladder fuel tanks were found partially collapsed. The fuel cap 'o' rings were to be replaced but were…NTSB CHI85LA317Accident · No injuriesLimited investigationFinal reportStinson L-5 · Waynesville, OHThe plt took off on a test flt to check the eng after it had been inspected & the carburetor had been overhauled. He made a ground check & full eng run-up before taking off. Intending to stay in a closed traffic pattern, he took off, made a normal climb in…NTSB BFO85LA064Accident · No injuriesLimited investigationFinal reportStampe SV4C · Fredericksburg, VAThe acft lost directional control and veered to the right. Colliding with a tied down Cessna 210, N2542X, while taking off from rwy 23 at shannon airport, Fredericksburg, Virginia.NTSB ANC85FA136Accident · Minor injuriesField investigationFinal reportCessna 180H · Anchorage, AKThe pilot attempted to takeoff uphill from a short airstrip with a steep incline during a no wind condition. The airplane drifted off the centerline after liftoff and struck three parked airplanes before hitting trees and turning over. Uphill takoffs are not…NTSB SEA85LA183Accident · No injuriesLimited investigationFinal reportCessna T-188C · Pasco, WAThe pilot elected to depart an 1800 foot gravel airstrip with a 90 degrdd f temperature. The density altitude was about 3100 feet. The aircraft was heavily loaded, approaching gross weight. The pilot made the decision during the last 1/3 of the runway to…NTSB SEA85LA179Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Yamhill, ORThe eng ceased operating at aprx 40 ft AGL during initial takeoff climb. Investigation disclosed the acft had been fueled with a mixture of automotive fuel and 80/87 avgas. The acft had sat on the ground for over 4 hrs with a surface tem of 95 degs f. a…NTSB NYC85LA196Accident · No injuriesLimited investigationFinal reportCessna 425 · Manahawkin, NJAfter overflying the airfld and deciding to land on rwy 22, the plt concentrated on the airspeed and alt of the acft. A twr east of the flt was noticed and was not considered a problem. During the final apch, the plt was distracted by a passenger who said to…NTSB NYC85LA195Accident · No injuriesLimited investigationFinal reportCessna 182C · West Lebanon, METhe acft nosed over after overrunning the airstrip following a loss of pwr. The plt reported the eng began running rough and the application of carb heat did not increase the pwr. During the landing apch the eng began runnin rougher and about 1/2 of the…NTSB MKC85LA170Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Leon, IAThe plt reported that when he was on final apch to land, the acft encountered a downdraft & its rate of descent increased. He applied power to correct the situation, but the left main gear hit a fence post aprx 10 ft short of the rwy & failed. Subsequently,…NTSB MKC85FA169Accident · 2 fatalField investigationFinal reportPiper PA-18 · North Loup, NEThe acft was observed flying low over the ground in the vicinity of where it eventually crashed. A witness aprx 1/2 mi from the crash site noticed the plane flying low over a corn field as though the student plt was practicing ag-acft type swath runs. (The…NTSB MKC85FA168Accident · 1 fatalField investigationFinal reportSchubert Cassutt Sport · Admire, KSAt 0847 CDT, July 27, 1985 N1115G radioed a nearby fss. The station that was called was closed but another fss heard thecall. During the transmission the plt reported that he had an eng problem, was pumping oil overboard and could not see outside because the…NTSB CHI85LA329Accident · No injuriesLimited investigationFinal reportCessna 152 · Rockford, ILThe student plt originally planned a x-country flt from janesville, WI, to champaign, IL, to galesburg, IL & back to janesville. The total route of flt was aprx 390 mi. The plt had calculated that he needed 3-3/4 hrs of fuel. At champaign, he purchased an…NTSB CHI85LA328Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Lakewood, WIThe student plt and his pax had landed on an airstrip on a golf course. On takeoff the student plt lifted off early and stalled back on the turf. He then lost directional control, veered off the airstrip and struck a golfer in the back with the outer section…NTSB CHI85LA327Accident · No injuriesLimited investigationFinal reportHoward DGA-15P · Fond Du Lac, WIThe plt had accurued aprx 12 hrs of flying time on the day of the accident. During the final landing the acft touched down at the rwy mid-point and bounced. The acft then struck a rwy light and veered off the rwy paved surface into soft sod. The plt attempted…NTSB CHI85LA321Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Delaware, OHTotal loss of engine power occurred in the descent. The flight was vectored toweard the nearest airport but was unable to reach the runway. The aircraft was landed in a rough field. The left magneto was found seized during engine examination.NTSB BFO85LA063Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Woodbine, MDThe acft nosed over during a hard landing at Woodbine airport, Woodbine, Maryland, while on a check ride.NTSB ATL85FA224Accident · 1 fatalField investigationFinal reportAero Commander 680-FP · Chesapeake, OHAs near as can be determined, this was the plt's second flt since obtaining his multi engine rating and third flt since obtaining his com'l plt certificate from a designated p.e. the acft was observed to depart lawrence co. arpt and upon reaching a point over…NTSB ANC85LA134Accident · No injuriesLimited investigationFinal reportCessna 206 · Kustatan River, AKThe plt reported that he was taking off from a River/lake area with glassy water on a hot/sultry day. After initial lift-off, the acft settled & touched down on the water, then lifted off again. It flew beyond the edge of the lake, then settled & nosed over…NTSB MIA85LA220Accident · No injuriesLimited investigationFinal reportCessna 150F · Apalachicola, FLThe plt stated that he elected to land at Apalachicola due to wx in the area, but on final apch, the eng started to run rough, then quit. He landed short of the rwy in a swampy area & upon touchdown, the acft flipped over on its back. Exam of the acft after…NTSB MIA85LA219Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · South Bay, FLThe eng lost pwr during a sightseeing flt at 1200 ft MSL and the plt selected a divided hwy for an emergency landing to the west. Because he was overtaking a truck on the westbound lanes, the plt tried to land on the median strip. The acft was caught in the…NTSB LAX85LA330Accident · No injuriesLimited investigationFinal reportHuff Sonerai IIL · Prescott, AZThe plt reptd that during the takeoff off roll, he applied back pressure to the control stick when the acft reached 60 knots. The aircraft began an immediate climb at a steep angle, stalled and crashed on to the rwy. This was the initial flight for this…NTSB DEN85LTE05Accident · Minor injuriesFinal reportGordon Thorpe T-18 · Alamosa, COThe plt of the amateur built acft was on a flt to ashkosh, WI with an en route stop at pueblo, CO. Due to wx in the pueblo area, he diverted to Alamosa, CO. On his 1st apch to land on rwy 20, he made a go-around. On his 2nd apch, the acft landed long & at…NTSB DEN85LA201Accident · No injuriesLimited investigationFinal reportCessna U206 · Greystone, COThe plt lost control of the acft during an attempted takeoff from a 7000 ft gravel road. The takeoff was being made to the north-northeast and the plt reported winds were from 180 degs at 10 KTS gusting to 15 KTS. The acft veered left, contacted a tree and…NTSB DEN85FA200Accident · 2 fatalField investigationFinal reportBeech A36 · Santa Rosa, NMThe plt departed dalhart, TX on a night x-country to quemedo, NM. En route he stopped and picked up a friend at hereford, TX. He did not file a flt plan. He was lost off of radar just west of Santa Rosa, NM, where the wreckage was later found. The acft was…NTSB CHI85FA315Accident · Serious injuriesField investigationFinal reportChristopher D. Brown Gyroplane · Oshkosh, WIThe pilot was practicing low altitude maneuvers, adjacent to the runway. When he turned to make a downwind, at the southeast end of the runway, he impacted with the terrain. Witnesses stated that they observed the gyroplane making steep turns at a low…NTSB CHI85FA314Accident · 4 fatalField investigationFinal reportBeech J35 · Eden Prairie, MNThe plt's windscreen became covered with oil shortly after takeoff. The plt returned to the arpt attempting to set up a pattern for landing. The acft was observed in a descent and turn to final apch. The acft collided with the ground in a descending left…NTSB ATL85LKG08Accident · No injuriesFinal reportSchweizer AG CAT · Samson, ALThe acft was damaged in a forced lndg after a pwr loss during a swath run. During the ldg a pwr line was struck and the acft was pulled sideways which caused a groundloop and resulted in damages. Lyon flying services of welsh la dismantled the eng & found no…NTSB ATL85IA225Incident · No injuriesIncident investigationFinal reportBeech 95-B55 · Gilbertsville, KYThe acft made a precautionary lndg after the plt feathered the left eng because of vibration. Post accident exam showed a failed cylinder in the engNTSB SEA85LA177Accident · No injuriesLimited investigationFinal reportCessna 172 · Mitchell, ORA go-around was attempted and the pilot was unable to outclimb rising terrain. The field elevation was over 3400 feet and the temperature was above 90 degrees. The pilot made a turn to avoid terrain and stalled. The density altitude was around 7,800 feet.NTSB SEA85LA176Accident · Minor injuriesLimited investigationFinal reportBeech A-24-R · Tuscarora, NVThe plt was attempting to land on a dirt road uphill at about 6,200 ft with gear and flaps down a go-around was attempted at about 50 ft AGL when the plt decided not to land. The acft failed to climb and a barn was struck before it hit the ground. The density…NTSB MIA85LA218Accident · No injuriesLimited investigationFinal reportCessna 172 · Lawtey, FLThe acft had not been flown for two years. During the preflt inspecton, the fuel sumps were drained repeatedly & each time, a quantity of water was observed in the collected fuel sample. Aprx 30 mins after takeoff, the eng failed & a forced landing was…NTSB FTW85MA297Accident · 3 fatalMajor investigationFinal reportBeech H35 · El Reno, OKThe acft took off at 1054 CDT in VMC with no flt plan. At that time, there was a rprtd ceiling of 1800 ft. at 1112 CDT, the plt rprtd he was at 10,000 ft, 'just reaching the tops.' At 1137 CDT, he stated 'we're about 60 west of oke city, westbound to sayre…NTSB FTW85LA298Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Bonita, LAThe plt stated he was the second of two acft in a formation takeoff and he encountered severe wake turbulence from the other acft (same type). He stated that he dumped his load of chemicals but could not get above the pwr curve and the acft settled into a…NTSB DEN85LTE04Accident · No injuriesFinal reportWoolsey Quickie Q2 · Rawlins, WYAfter taking off, the plt noted that the acft's CG had shifted, & as fuel was consumed, the elevator down authority seem to decay. He suspected that baggage (stowed behind the plt's seat & inaccessible during flt) had shifted aft requiring greater than usual…NTSB DEN85LA199Accident · No injuriesLimited investigationFinal reportBeech 58P · Buena Vista, COThe left engine failed during takeoff at an altitude of about 40 ft AGL. During the forced landing, the plt used incorrect emergency procedures and failed to maintain lateral and directional control of the acft. Inspection of the acft revealed a disintegrated…NTSB CHI85LA375Accident · No injuriesLimited investigationFinal reportCessna 172P II · Detroit, MIThe pilot was on a VFR VASI approach to the ATC controlled arpt 5091 ft runway. During ld round out the pilot said it feld like the acft was 'pushed' down onthe runway. The acft bounced and then ld on the nose wheel. The pilot said a helicopter was in a hover…NTSB CHI85LA313Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Valparaiso, INThe acft nosed over during landing. The plt said that he made a wheel lndg and after the acft slowed to 20 mph the tail lifted and the acft nosed over.NTSB CHI85FEP02Accident · Serious injuriesFinal reportNeyman-Pietenpol GN-2 · Brodhead, WIThe acft was observed making steep turns at about 500 ft AGL just prior to the acdnt. One witness stated that the airspeed was decaying during these turns & the acft stalled while in a steep bank. Reportedly, the acft began spinning, then the plt stopped the…NTSB CHI85FAMS2Accident · 2 fatalMissing aircraftFinal reportCessna 170B · Chicago(L.Mich), ILAt an unknown time during the night of July 25/26 the acft crashed into lake Michigan. Exact wx conditions are unknown. The passenger was recovered from the lake the next morning, along with the two crushed front seats and two buckled interior side panels.…NTSB ANC85LA133Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKPlt stated, '... On the go-around attempt I got behind the power curve & could not clear the trees. It stalled & turned to the left, hitting the trees about 15 ft off the ground which cushioned the fall & then slid down to the ground.' The plt was attempting…NTSB NYC85LA193Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Worcester, MAThe instructor (CFI) & student were practicing touch-&-go landings. On the 4th landing, the apch & touchdown were made with full flaps extended. The CFI began to retract the flaps while the student applied full power for takeoff. The acft became airborne &…NTSB NYC85LA191Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Plymouth, MAThe aircraft was towed to an alt of 3000 ft. the plt set up for landing and entered the pattern at the initial point at about 1200 ft. the apch went normally until the base leg. After turning onto the base leg, the plt experienced a high sink rate. The plt…NTSB MKC85LA166Accident · Minor injuriesLimited investigationFinal reportJames Gress Quickie · Fenton, MOWhile taking off, the plt noted a partial loss of eng power during the initial climb. He was unable to maintain alt & tried to maneuver around trees near the departure end of the rwy. However, the acft descended into the tree tops, then crashed onto the roof…NTSB MIA85IA217Incident · No injuriesIncident investigationFinal reportCessna 402B · West Palm Beach, FLAircraft experienced unsafe right main gear indication several days prior to the incident. Mechanics found a damaged micro switch mounting plate which they repaired enough to hold until a new plate could be ordered and installed. On day of incident pilot…NTSB DEN85LTG04Accident · No injuriesFinal reportPiper PA-25 · Antler, NDThe left wing of the acft received substantial damage when it contacted trees during a pull-up at the end of a swath run. The plt then flew the acft to a fld aprx 1 mile away and a precautionary landing was made.NTSB BFO85FA062Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Oakland, MDThe acft had been observed on the day of this flt and on the 'past couple of days' to be flying low and very slow at tree top level. Ground witnesses heard the sounds of the crash but could not see the acft at the time. The acft impactedthe ground in a near…