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 FTW84LA353Accident · No injuriesLimited investigationFinal reportCessna A188B · Driscoll, TXAcft experienced a propeller blade failure in flight followed by an engine failure due to the unbalanced forces. While making a forced landing the acft was landed hard. The acft was being flown to a field where aerial application was to be performed and had a…NTSB CHI84FEI01Accident · 1 fatalFinal reportBell-Olympic Helicopters 47G2 · Toledo, OHThe helicopter was being used to photograph an office building. The photographer stated that after each flt of about 10 min, the plt flew the helicopter to the left & center of the landing pad, a few feet above the ground, then moved the acft sideways to the…NTSB BFO84FU002Accident · 1 fatalFinal reportAmerican Aerolights Eagle XL · Smithfield, VAThe plt of the ultralight vehicle, a student, was in radio contact with his instructor thru use of a portable hand-held UHF transceiver. About 10 min after takeoff, the instructor asked him to return to the airstrip for a practice power off landing. During…NTSB MKC84FA235Accident · Serious injuriesField investigationFinal reportPiper PA32R300 · Des Moines, IAThe acft eng began to 'shudder badly' upon reaching a cruise alt of 3500 ft MSL shortly after takeoff. The plt made a 180 deg course reversal to return to the arpt but reported to ATC he was unable to see outside the acft because oil was smeared on the acft.…NTSB FTW84FA331Accident · 1 fatalField investigationFinal reportCessna A185F · Del Rio, TXThe non-instrument rated plt took of at night approximately 30 min prior to the accident. Ground scars indicated that the acft impacted the crest of a rocky hill while in a steep nose down, right wing low attitude. The elevation of the crash site was about…NTSB FTW84FA329Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Lake Charles, LAAt aprx 250 ft ag., according to witnesses, eng sounds indicated that power was reduced to idle. The acft rolled into a steep left descending turn followed by the application of power just prior to impact. The CFI was known to have given other students…NTSB DEN84FA242Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Park Valley, UTNewly certificated pvt plt departed on a moonless night for a VFR flt. Route of flt was over a desert like environment where there are no visual cues for attitude reference. Acft wreckage was found the following day. Acft impacted tundra inverted at a high…NTSB ATL84LA238Accident · Minor injuriesLimited investigationFinal reportCessna A188 · Hartsfield, SCThe plt said he smelled an electrical fire while spraying. He elected to land but before he could the engine quit. A forced landing was made in a cornfield. The acft burned. The fire origin was not located in the totally burned wreckage.NTSB ANC84LA125Accident · No injuriesLimited investigationFinal reportHiller FH-1100 · North Pole, AKDuring an approach for landing the acft collided with the ground and rolled over. The plt stated that he flared too low to the ground and struck 1 skid first, lost directional control and rolled over.NTSB SEA84LA189Accident · No injuriesLimited investigationFinal reportMooney M20E · Scappoose, ORPlt lowered gear in traffic pattern and gear down and locked green light was received. Plt failed to check the gear bar indicator. Acft touched down with gear extended 1/4 of the way. Inspection revealed landing gear motor bearingswere worn out.NTSB NYC84LA258Accident · Serious injuriesLimited investigationFinal reportPiper J58 · Gilead, METhe acft was forced to land according to the plt, after a downdraft at low alt & airspeed created a trap. The plt said that he & a friend were looking for a fishing spot, when he realized that he could not make it over the top of rising terrain ahead & could…NTSB NYC84FHD06Accident · No injuriesFinal reportBell 206L-1 · Tuckerton, NJAccording to the plt at 8 to 10 ft in a hover the cyclic snapped rearward 3 to 4 in with a noise from the rear. The tailboom was found bent aprx 45 degrees down and 15 degrees right with no evidence of ground contact on the tail skid shoe. Metallurgical…NTSB LAX84FA421Accident · 3 fatalField investigationFinal reportFairchild Hiller FH-1100 · Meadview, AZPurpose of the flt was s sightseeing tour of lake mead, hoover dam and the western rim of the grand canyon. Before reaching the canyon the flt was to travel over a 5500 ft MSL ridge. The helicopter contacted a juniper tree at the bottom of a 3-sided canyon at…NTSB LAX84FA420Accident · 2 fatalField investigationFinal reportPiper PA-11 · Willows, CAThe acft was observed to pitch up from a level flight attitude from about 300 ft AGL. The acft then pitched down & impacted the ground in a near vertical attitude.NTSB FTW84LA355Accident · No injuriesLimited investigationFinal reportCessna 150E · Cleburne, TXPlt stated that while making a crosswind landing on a 2600 foot strip she misjudged her touchdown point and ran off the end of the strip, colliding with a fence. The plt landed on heading 350 degrees and the wind was reported to be from 090 degrees at 10…NTSB FTW84LA330Accident · Serious injuriesLimited investigationFinal reportBellanca 7ECA · San Marcos, TXWhile the plt was on a x-country flt, the acft crashed & came to rest on the shoreline of a large pond. Initial impact was believed to have occurred with the water. No preimpact part failure or malfunction was found during the investigation. There was…NTSB DEN84IA241Incident · No injuriesIncident investigationFinal reportde Havilland DHC-7-100 · Denver, COThe left main landing gear was disassembled & reassembled by company maintenance personnel & the acft was being ferried to another base for permanent landing gear repairs. During takeoff, the left main landing gear and shock strut seperated from the acft. The…NTSB DEN84FQA01Accident · No injuriesFinal reportDemick James A Rand KR2 · Grants, NMThe acft was landed dead stick on a black-top road after the eng lost oil press due to a large leak in an oil seal during cruise flt. During the lndg the left wg hit a sign post alongside a bridge and the wing tip plus the alieron were sheared off. The…NTSB CHI84LA318Accident · No injuriesLimited investigationFinal reportCessna 172 · Urbana, OHThe pilot stated after the accident that he arrived at his flight planned destination 15 minutes early so he continued the flight an additional hour. The plt experienced an eng failure while on final apch to the rwy at the revised destination arpt. The plt…NTSB CHI84LA317Accident · No injuriesLimited investigationFinal reportBell 47-G2 · Jeffersonville, OHThe acft started to settle with power during takeoff after the acft was loaded with chemicals. The plt said he had a choice of, going through a fence or over it and decided to go over it. Pulling collective bled off m/r and the acft stopped flying. The tail…NTSB CHI84FA321Accident · No injuriesField investigationFinal reportS.I. Briggs Varieze · Pickett, WIThe acft contacted a 25 ft AGL 2 strand 14000 v power line. After contacting the lines, the acft touched down in a corn field and traveled for aprx 210 ft. the acft then crossed a 2 lane road, struck a ditch separating the canard/gear and traveled an…NTSB ANC84FA124Accident · No injuriesField investigationFinal reportCessna 140 · Talkeetna, AKPlt was conducting a search and rescue mission when his attention was diverted to an object on the ground. When plt redirected his attention to the flt path, rapidly rising terrain was viewed directly in front of the acft with insufficient room to turn. The…NTSB NYC84LA257Accident · Serious injuriesLimited investigationFinal reportGates Learjet 25B · Waterville, MEDuring preflight preparation for departure from a short field the plt failed to remove the pitot tube covers. On takeoff roll, the stall warning light began to flicker. Plt noted airspeed was not registering but did not consider this unusual in the early part…NTSB MKC84LA236Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Arapahoe, NEWhile on a swath run to apply insecticide, the acft collided with electrical transmission lines that were crossing the field. After the initial impact, the acft angled to the left & hit another transmission line, then impacted the ground.NTSB MIA84LA215Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Nahunta, GAAfter the student made a full stop landing on a 3000 ft rwy, he started to turn around & back taxi to the apch end to takeoff; however, the instructor (CFI) told him to make a short field takeoff from where he had stopped. A takeoff was initiated with about…NTSB LAX84LA419Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Laveen, AZDuring flt on the downwind leg of the traffic pattern the plt inadvertantly knocked the ignition switch to the 'off' position. Since the prop stopped and the acft was not equipped with a starter, the acft engine could not be restarted. The acft landed 20 ft…NTSB LAX84LA417Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Delhi, CAThe plt took off so early it was described by a witness as still being dark. The elevation of the accident was higher than the takeoff point. The operator said the plt tended to be easy on the equipment and throttled back shortly after takeoff. He stated that…NTSB LAX84FA447Accident · 1 fatalField investigationFinal reportPiper PA-23-160 · Garberville, CAThe acft collided with trees & ground during climb after takeoff on a dark night in mountainous terrain. The wx is not considered to be a factor since the wx was VMC at the time & place of the accident. It was a moonless night and the areaof the crash…NTSB LAX84FA418Accident · No injuriesField investigationFinal reportBell 206B · Point Loma, CAThe helicopter was ditched near pt Loma, CA, after the eng quit. The plt said there was no low fuel warning light or chip light. After salvage the fuel lines were found empty of fuel and the tank contained mostly sea water. The wires to the annuniciator panel…NTSB FTW84LA328Accident · No injuriesLimited investigationFinal reportCessna 152 · Floydada, TXThe student plt became most while he was on the 2nd leg of a x-country flt. He finally determined his position, but exhausted his fuel before reaching an arpt. During a forced landing, the nose gear sank in soft terrain & the acft nosed over.NTSB FTW84LA327Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Denton, TXThe pilot stated that after takeoff he did 3 touch and go landing then started a series of stalls. After entry into a cross-control spin to the left, he found that he could not apply enough right pedal to recover. Examination of the aircraft revealed that the…NTSB DEN84LA245Accident · No injuriesLimited investigationFinal reportConsolidated-Vultee BT-13B · Hobbs, NMAs part of a group of a confederate air force acft the flight conducted public relations flyovers at several area arpts. Due to a low ldg gear strut N63697 did not land with the other acft after the flyovers. The plt planned to have the strut repaired upon…NTSB DEN84LA244Accident · No injuriesLimited investigationFinal reportCessna 182 · Pagosa Springs, COWhile turning the base leg, the plt viewed a hot air balloon near the final apch corridor. The plt elected to make a short final to avoid the balloon. The acft bounced during touchdown. The plt added power to recover and the acft veered off the left side of…NTSB DEN84LA243Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Santa Fe, NMThe acft bounced several times on landing following an excessively high fast approach. The plt added power to recover by aborting the landing. The plt stated the failure to use right rudder resulted in the acft veering to the left and the failure to retract…NTSB CHI84LA316Accident · No injuriesLimited investigationFinal reportCessna 150H · Menomonie, WIThe plt was disoriented during a x-country and circled the wrong area looking for an arpt until low fuel demanded a landing. During the approach the engine quit and the acft nosed over in a bean field during landing.NTSB CHI84FU007Accident · 1 fatalFinal reportCollins Fisher FP-202 · Ludington, MIThe ultra-light was constructed by the pilot and two other persons. This group had no previous experience in aircraft construction. This was the third known flight for this aircraft. It had been flown two days prior to the accident and an adjustment to the…NTSB CHI84FA315Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Sandwich, ILPilot attempted to takeoff with 7 passengers in a six place acft. The acft was 187 lbs over gross wt and 1.54 inches out of aft c.g. the pilot tookoff downwind and collided with trees at the end of the rwy. There was a post crash fire.NTSB ATL84LA237Accident · No injuriesLimited investigationFinal reportCessna 152 · Enterprise, ALThe student plt flared at about 40 ft AGL with pwr off. The CFI who was watching said he did not hear any sounds of pwr being applied until the acft was bouncing and then only heard partial power. This was the students 1st solo landing. Theinstructor said he…NTSB ANC84LA127Accident · No injuriesLimited investigationFinal reportNorth American Navion · Atigun Pass, AKThe acft encountered a downdraft while flying through a mountain Pass. The terrain would not allow the plt to make a 180DEG turn so he elected to land on a road with the landing gear retracted.NTSB ANC84LA126Accident · No injuriesLimited investigationFinal reportGrumman G-44A · Shanin Lake, AKThe plt reported that shortly after takeoff the acft encountered severe wind shear. The plt lost directional control of the acft & it collided with a mud bank.NTSB ANC84LA123Accident · Minor injuriesLimited investigationFinal reportCessna 180H · Chicken, AKWhile en route to dawson city, Canada, the plt encountered deteriorating wx. The clouds were near the tops of the ridges & the acft was beneath the cloud layer in a slow flt configuration. The plt said that he tried to make a 180 deg turn, but the acft…NTSB SEA84LA186Accident · No injuriesLimited investigationFinal reportCessna A188B · Pasco, WAThe acft was loaded with 1500 lbs of dry chemical (fertilizer). The air temp at the time of the accident was 95 deg f, resulting in a high density alt. Rising terrain existed at the point where the plt attempted a turnaround. In an attempt to turn away from…NTSB SEA84LA184Accident · Serious injuriesLimited investigationFinal reportHeveron Sandpiper 83B · Mcminnville, ORA student pilot lost control of an ultralight vehicle when he encountered a local gusty wind condition at 200' AGL and collided with the ground in an uncontrolled descent. The ultralight was built for registration as an experimental aircraft, but…NTSB NYC84LA256Accident · Minor injuriesLimited investigationFinal reportPiper PA-28RT-201 · Smyrna, DEAcft contacted a ditch and nosed over during a precautionary landing after plt noticed engine was running rough. Cause of engine roughness could not be determined through inspection of the engine.NTSB MKC84FA234Accident · 2 fatalField investigationFinal reportSims - Basset Varieze · Clarinda, IAWitnesses observed a ground run of aprx 2000 ft before lift-off was achieved after which the acft appeared to climb laboriously to about 100 ft AGL. Acft then executed steep, descending rt turn of about 240 degrees back toward the arpt. Acft collided with pwr…NTSB MIA84LA214Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Espanola, FLThe acft without flt plan and no flt history was found abandoned in a field with 14 bales of marijuana located in and around the wreckage. No owner or plt has been located. Customs agents tracking the acft lost contact in a thunderstorm between daytona and…NTSB LAX84LA425Accident · Serious injuriesLimited investigationFinal reportBalloon Works Fire FLY 8-24 · Yountville, CAThe initial landing was in an area of limited access and the pilot elected to continue the flight over a tree line to a nearby more suitable field. In order to avoid being carried into a second downwind tree line, the plt descended the Balloon into the field…NTSB LAX84FVM01Accident · 1 fatalFinal reportE.L. Griggs Q2 · Hollister, CAThe acft passed over the arpt twice after departure with the engine popping and backfiring. A witness who heard this radioed the plt to warn him. The plt replied that he was trying to correct it with the mixture control. The plt was also advised that his…NTSB FTW84LA325Accident · Minor injuriesLimited investigationFinal reportBell 47J · Grove, OKThe plt stated that yaw control was lost during climb out for a local flt with two passengers onboard. The acft began torotate to the right and the antitorque pedals were ineffective. They were over buildings at the time so the plt held a minimum descent…NTSB FTW84FA326Accident · 1 fatalField investigationFinal reportBeech S35 · Bedias, TXThe non instrument rated plt penetrated a severe thunderstorm in which turbulence was labeled as severe or greater. There was no pre or in-flt wx briefing. The aircraft broke up in-flt and was consumed by post crash fire. Investigation revealed evidence of…