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 MKC87FA172Accident · 1 fatalField investigationFinal reportSchweizer G-164B · Weiner, ARThe plt rprtd he was on a flt to chase birds from a rice field. Drg a low pass over the field, the main wheels dscndd into the rice crop, & after about 1000', the acft contacted the terrain & nosed over. The single place acft was equippedwith only one seat…NTSB MIA87LA251Accident · No injuriesLimited investigationFinal reportCessna 152 · Plant City, FLThe student plt stated the acft was cruising at 3000 ft, when the eng lost pwr. She selected a fld & made an emerg lndg. Drg the lndg roll, the acft went thru a barbed wire fence, hit a ditch, nosed over & came to rest inverted. The acft had flown a total of…NTSB DEN87DTM01Accident · Serious injuriesFinal reportEvans VP-2 · Cedar Valley, UTThe acft was flown by two different plts who complained of stiff ailerons. The aileron system was examined but no deficiencies were noted. A third plt then took off and began a lt turn at about 75 to 100 ft AGL. When he attempted to return to wings level he…NTSB NYC87FA257Accident · Serious injuriesField investigationFinal reportBoeing 727-200 · Pittsburgh, PAWhile descending out of flt lvl 270 for lndg, usair flight 10 encountered light to moderate turbulence. Prior to this this encounter, the capt advised all passengers and cabin crew to remain seated and to engage their seatbelts. A similar announcement was…NTSB LAX87LA339Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Freemont, CAThe purpose of the flt was to provide instruction to a foreign national, who held a U.S. Private helicopter rating. The instructor (CFI) rprtd that during a practice autorotation, he announced twice for the student to flare as the helicopter was passing thru…NTSB LAX87LA338Accident · No injuriesLimited investigationFinal reportCessna 152 · Napa, CAThe student plt was on her 2nd solo flt. She rprtd that on her 1st landing, the acft bounced on the main gear, then drifted to the left & went off the rwy. She applied full power & raised the flaps in an attempt to go around. Witnesses rprtd the acft attained…NTSB FTW87LA221Accident · 1 fatalLimited investigationFinal reportCessna 340A · Lubbock, TXThe pilot did not declare an emergency or mention to the tower controller that his fuel was low. He was first told to enter right traffic for runway 17R but was subsequently told to enter right traffic for runway 26. (This was to allow a dea aircraft, at its…NTSB FTW87DPJ07Accident · No injuriesFinal reportMooney M20F · Jenks, OKEngine failed during initial climb. Aircraft collided with airport perimeter fence and slid across road during landing attempt. Water was found in the fuel distributor system following the accident.NTSB ANC87LA161Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Sparrevohn, AKThe pilot of the airplane was an Alaska state trooper performing his official duties and was flying an airplane owned and operated by the state of Alaska. He had landed on a remote ridge top to recover essential items of evidence for a pending case. Upon…NTSB ANC87LA158Accident · No injuriesLimited investigationFinal reportCessna 207 · Two Lakes, AKThe pilot stated the gravel airstrip was muddy and he lifted off at the end of the strip. The aircraft clipped a tree with the horizontal stabilizer and the airplane settled into the trees.NTSB ANC87LA157Accident · No injuriesLimited investigationFinal reportCessna 185 · Little Delta Rv, AKThe pilot stated that approximately 1000 feet after commencing the take off the airplane climbed to just above tree top level and then began to settle into the trees. The pilot also stated he believes the airplane stalled.NTSB MIA87LA249Accident · No injuriesLimited investigationFinal reportMooney M20J · Macclenny, FLWhile en route at 8000', the eng lost power & the plt obtained vectors for an emerg landing at an arpt with a grass strip. Drg the roll-out, the left wing tip hit a hay wagon near the end of the rwy, then the acft veered & struck a hangar. An exam of the…NTSB MIA87IA246Incident · No injuriesIncident investigationFinal reportPiper PA-60 · W.Palm Beach, FLThe plt stated that on landing after rolling about 1000 ft. the scissors on the right main landing gear strut disconnected causing the wheel assembly to rotate & skid. He then applied heavy left brake to keep the acft straight on the runway, but the main gear…NTSB MIA87FA248Accident · No injuriesField investigationFinal reportBoeing 727 · Tulsa, OKThe crew of the Boeing 727 aircraft on a domestic passenger flight initiated an approach to a runway with a known crosswind and tailwind component. On final approach the tower controllers re-stated the wind and issued a windshear warning. On short final at…NTSB LAX87LA342Accident · No injuriesLimited investigationFinal reportCessna 152 · Monterey, CAWhile landing at the destination, the airplane bounced, then after it touched down the second time, the nose gear failed. During the landing roll-out, the airplane settled on its nose cowling. No previous airframe problem was evident.NTSB FTW87LA220Accident · Minor injuriesLimited investigationFinal reportBell 206B · Gulf Of MexicoWhile departing from an off-shore oil platform in the Gulf Of Mexico, the helicopter eng lost power. The plt initiated an autorotation & made a mayday call, but did not get the emerg floats inflated before touching down in the water. Subsequently, the…NTSB FTW87FA219Accident · 4 fatalField investigationFinal reportGrumman American AA-5A · Corpus Christi, TXThe aircraft exceeded maximum allowable takeoff weight and aft center of gravity limits. The aircraft had two passengers in the rear seats. The operator's manual states that no passengers are permitted in the rear seats during aerobatic maneuvers. The pilot…NTSB DEN87LA241Accident · No injuriesLimited investigationFinal reportCessna TU206G · Spanish Fork, UTWhile cruising at 10,500 ft with the power set at 28 inches map & 2350 RPM, the eng suddenly lost pwr & began knocking. The plt noted a rapid drop in oil pressure & saw a 3-inch hole in the top of the eng cowling. He attempted to land on a highway, but was…NTSB BFO87FA065Accident · No injuriesField investigationFinal reportBeech 58 · Baltimore, MDDuel alternator failure occurred abt 13 min aft dept. The acft returned and lndd uneventfully. However, while taxiing back to the maint hgr the plt failed to follow the marked taxiway and collided with a ditch. Construction was taking place on the arpt and…NTSB ATL87LA260Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Louisville, KYThe plt made two attempts to land and during his 2nd go around the eng cut out. The plt stated that he switched from left tank to rt tank but was unable to start the eng prior to making a forced landing which resulted in a collision with a house and tree. The…NTSB ANC87LA169Accident · No injuriesLimited investigationFinal reportCessna 185 · Wind River, AKThe pilot and his passenger had camped over night on a gravel bar on the Wind River. On departure the following day, the airplane failed to become airborne prior to reaching the end of the gravel bar. The airplane entered the shallow water surrounding the…NTSB ANC87LA156Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Valdez, AKThe pilot stated that he was landing at an unimproved, off airport site when the main gear hit a hole during the landing roll and the aircraft nosed over.NTSB ANC87LA154Accident · Serious injuriesLimited investigationFinal reportPiper PA-18A · Windy Ridge, AKThe pilot stated that he had just lifted off from the gravel bar hen he stalled the aircraft and crashed.NTSB ANC87FA153Accident · 3 fatalField investigationFinal reportPiper PA-12 · Shaw Creek, AKThe private pilot was transporting passengers incidental to the operation of his lodge. According to witnesses, it was common for pilots to use that portion of the highway for takeoffs and landings. According to the husband of one of the fatally injured…NTSB SEA87LA188Accident · 1 fatalLimited investigationFinal reportMercer OWL Racer 65-2 · Reno, NVDrg a practice flt in a formula one racer bfr the Reno air races, the eng lost pwr after 4 laps when the acft was at an alt of about 40' AGL. The plt maneuvered to lnd on a rwy in winds that were variable & gusty. A witness rprtd the plt made an abrupt left…NTSB NYC87LA255Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Emmaus, PADrg flt, the eng lost power over a residential area & the plt selected a small fenced-in opening for an emergency lndg. He said he crashed nosewheel 1st, then skidded into a cyclone fence. After the acdnt, the fuel selector was fnd positioned to the rgt tank…NTSB MIA87LA247Accident · No injuriesLimited investigationFinal reportBeech 200 · Tampa, FLThe plt stated that as he was taxiing to the ramp, his attention was momentarily diverted away from the clearance between the left side of the wing tip & the building's steel support when the trailing edge of the aileron contacted the support.NTSB LAX87LA336Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Byron, CAWith the wind out of the southwest at 8 to 10 knots, the plt was taxiing the acft in a northerly direction at a high enough speed to keep 'on the step'. When he attempted to turn the acft to a southwesterly heading for tkof, the acft failed to respond. Rather…NTSB LAX87DUG09Accident · No injuriesFinal reportGeiger Dragonfly · Chino, CAAt the end of a performance test flight, the plt stated that the acft was rotated to a landing attitude at a higher then normal altitude above the ground. The acft contacted the rwy and bounced three times, resulting in substantial damage.NTSB FTW87LA218Accident · No injuriesLimited investigationFinal reportBeech 58 · Guthrie, OKThe pilot failed to ensure that the landing gear was down and locked. The aircraft landed gear up and received substantial damage. The gear was lowered normally after the aircraft was lifted from the runway.NTSB CHI87DEE10Accident · Minor injuriesFinal reportHughes 269A · Plainfield, ILWhile maneuvering at about 4 feet above ground level the pilot experienced a loss of engine power and entered an uncontrolled right turn and descent, colliding with the ground. The engine power loss was due to the failure of a stud and bolt holding the…NTSB ATL87LA259Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Concord, NCWhile on climbout, the stu plt switched radios to the dest UNICOM freq. Unable to contact anyone on that freq, the departure arpt freq was reselected. No contact was established on this freq so the stu plt attempted to rtrn to the arpt. The haze was very…NTSB ATL87DKG07Accident · Serious injuriesFinal reportGrumman G-164A · Alamo, GAThe acft was rprtd to be on an agricultural spraying assignment. The plt took off in the single seat acft with a passenger aboard. About 5 min after depg the arpt, the acft collided with trees & crashed after making an unscheduled low pass over an open field.…NTSB ANC87LA160Accident · No injuriesLimited investigationFinal reportCessna 185 · Mt. Watana, AKAfter liftoff from a lake the airplane's engine stopped producing power and the airplane began settling toward the remaining lake. The engine surged and the airplane crashed on the tundra, 200 yards from the lake's edge. The pilot stated that he drained the…NTSB ANC87LA159Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Skwentna, AKThe engine stopped producing power but continued to windmill. The pilot was able to glide to a gravel bar and intentionally groundlooped to avoid hitting obstructions. The pilot stated he believed the aircraft ran out of fuel.NTSB ANC87LA147Accident · No injuriesLimited investigationFinal reportCessna 170B · Skwentna, AKThe pilot stated that during the take off roll he lost directional control of the aircraft causing the aircraft to nose over. He also indicated that the private strip was new and that the dirt rwy was wet and soft.NTSB SEA87LA187Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · John Day, ORPlt departed hay field in hi density alt conds. The pilot was unable to clear trees and stalled/mushed into terrain, collapsing gear and colliding with trees.NTSB NYC87LA253Accident · No injuriesLimited investigationFinal reportCessna 172D · Scottdale, PADuring a local pleasure flight, the pilot noticed the airspeed indicator was inoperative. On lndg the acft was obsvd to touchdown abt half-way down the rwy and faster than normal. The aircraft continued off the runway and crossed the airport road coming to…NTSB NYC87LA248Accident · No injuriesLimited investigationFinal reportCessna 150J · Brookline, NHDuring an approach to land at night, the pilot saw deer on the runway that were facing his direction and moving to the right. He didn't see the deer until he had reached a point were a go-around would be unsafe for this runway. In an effort to avoid the deer,…NTSB LAX87FA337Accident · Serious injuriesField investigationFinal reportPiper Aerostar 601P · Corona, CAThe airplane was refueled before it dept on the accd flight; the pilot did not supervise the fueling. Shortly after takeoff, the plt advised the ontario dept controller that both engines were experiencing a power loss and that he suspected jet fuel…NTSB LAX87FA335Accident · 1 fatalField investigationFinal reportMooney M20J · Dublin, CAThe pilot had flown 5.6 hours during the day, starting the first flight about 0600. ATC controllers stated that the pilot did not follow the clearance issued to him. The controllers then issued radar vectors. The instructor the pilot flew with earlier in the…NTSB FTW87LA217Accident · No injuriesLimited investigationFinal reportCessna 401A · Wichita Falls, TXThe pilot stated that the right engine quit after landing at the Wichita Falls, Texas airport. A witness stated that he attempted to start the engine several times when the right wing exploded during the last attempted engine restart. Damage was concentrated…NTSB DEN87LA240Accident · No injuriesLimited investigationFinal reportCessna 177B · Fort Collins, CODuring the approach to Fort Collins downtown airport, the pilot reported encountering moderate turbulence. At touchdown on runway 11, a crosswind gust pushed the aircraft off the left side of the runway into the grass. The aircraft bounced and came to a stop…NTSB ANC87LA152Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Stoney River, AKThe pilot stated that during the initial climbout he lost directional control of the aircraft; stalled and crashed on the gravel bar. Plt did not submit an acc report.NTSB ANC87LA150Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Island Lake, AKThe pilot stated that during the initial climbout the aircraft lost power, stalled, and crashed into a row of trees near the lake. The pilot also stated it was fuel contamination which caused a partial power loss.NTSB ANC87LA149Accident · Serious injuriesLimited investigationFinal reportTaylorcraft F-19 · Kuskatan River, AKThe pilot stated that he was maneuvering the aircraft at approximately 400 feet MSL when he stalled the aircraft and spun down until striking the trees. At the time of the accident the pilot did not hold a valid FAA pilot or medical certificate. He also did…NTSB FTW87LA216Accident · No injuriesLimited investigationFinal reportCessna 172 · Edmond, OKThe pilot executed a short field approach to a private airstrip. During the landing roll the nose gear collapsed resulting in the aircraft's nose contacting the terrain. No reason for the nose gear collapse could be determined.NTSB FTW87LA215Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Batesvile, TXA witness to the accident reported the pilot was 'buzzing' personnel in a cotton field and on the third pass did not pull up in time. The belly struck the ground while the aircraft was in a 'fairly steep angle of descent.' The witness stated the engine…NTSB FTW87DPJ08Accident · 1 fatalFinal reportAir Tractor 301A · Hollis, OKDuring an aerial application cleanup run, the aircraft's wing collided with a pole and sheared off the outboard five feet. The aircraft then collided with the ground out of control. Exam of the engine and airframe did not disclose any pre-existing failures or…NTSB DEN87LA238Accident · No injuriesLimited investigationFinal reportMaule M-5-210TC · Moab, UTThe pilot aborted his approach to runway 21 at canyon lands airport when he had 'indications of a crosswind.' The pilot radioed Moab UNICOM and reported he could not find the windsock and requested wind information. Moab UNICOM reported thewind was 'straight…