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 MKC85LA041Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Stuttgart, ARPlt stated he had attempted an NDB approach to rwy 18 but executed a missed approach when he could not see the rwy when the acft was at 800 ft. the plt pitched the acft to a climb attitude and added full throttle. He continued to state that the acft felt…NTSB MKC85LA038Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Caruthersville, MOAccording to the plt, the eng lost power after takeoff as the acft was climbing thru about 400 to 500 ft AGL. He attempted to land straight ahead on the remaining rwy. However, he was unable to stop on the rwy. The acft continued off the end of the rwy, went…NTSB MKC85FA040Accident · 3 fatalField investigationFinal reportBeech S35 · Hot Springs, ARThe acft collided with trees & crashed on the east side of west mountain after the plt had made an ILS rwy 5 apch & overflew the arpt. The last wx observation before the accident was: partial obscuration, ceiling 300 ft, visibility 1 mi. The decision height…NTSB MIA85MA064Accident · 6 fatalMajor investigationFinal reportPiper PA-32R-301 · Bradley, FLThe plt completed a 30 min insurance check flt, then loaded the acft with baggage/pax & departed decauter, IL on a flt to naples, FL. A refueling stop was made at columbus, GA. At 1750 the acft departed columbus & cruised uneventfully until sometime after…NTSB MIA85FA067Accident · Serious injuriesField investigationFinal reportLounsbery Taylor/COOT-A · Punta Gorda, FLThe acft was landed hard, according to witnesses, after completion of the first takeoff and flt around the traffic pattern. The plt shut off the eng, exited the acft & inspected for damage. He then restarted the eng and took off again. The plt stated after…NTSB MIA85FA066Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Homestead, FLWhile cruising northerly at a low altitude during a dark night, the acft struck a row of trees appx 50 ft tall about 8 ft from the tops, it then hit a large tree at about 6 ft AGL, 670 ft from the initial impact point, & came to rest in a dirt road. An exam…NTSB MIA85FA065Accident · 1 fatalField investigationFinal reportFairchild Hiller FH-1100 · La Belle, FLThe helicopter was observed flying at a low alt & lost all eng power, banked sharpley to the left, lost complete control & dove into the ground. The acft was destroyed by impact forces along with the post crash fire. No evidence to suggest a malfunction of…NTSB CHI85LA080Accident · No injuriesLimited investigationFinal reportPiper Aerostar 600 · Kalamazoo, MIThe plt reported upon touchdown, the acft contacted a patch of ice causing it to slide sideways resulting in a left main gear collapse. ATC twr witnesses stated the acft appeared fast on final and a hard landing was made.NTSB CHI85LA079Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · New Philadelphi, OHPlt felt vibration and reduced power on both engines to idle. Plt heard a 'thud' and discovered the left propeller had separated cutting through the nose of the acft as it departed. The propeller was not located. Two of the six propeller bolts remained with…NTSB CHI85LA077Accident · No injuriesLimited investigationFinal reportCessna 402C · Troy, MIThe acft collided with trees during the initial takeoff climb from rwy 27 at oakland-Troy airport, Troy,MI, while on a corporate flt. Investigation revealed that approx 3 to 5 inches of snow had fallen at the arpt during the day & the snow had not been…NTSB ATL85LA069Accident · No injuriesLimited investigationFinal reportCessna 172H · Fairburn, GAThe aircraft reportedly suffered a loss of power while on the x-wing leg for a touch-&-go landing. The plt attempted to land the aircraft on the reciprical rwy from which he departed. The aircraft touched down long and ran off of the end of the runway into…NTSB ATL85FA068Accident · 1 fatalField investigationFinal reportGyrocopter B-8M · Madisonville, TNStudent pilot attempting flight in Gyrocopter loss control cusing main rotor system to contact the rudder system. Pilot was not qualified to conduct this flight. A/c was not assigned an identification number.NTSB NYC85LA049Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Marlboro, NJThe acft landed hard on runway 27 at Marlboro airport while on a solo flight. The aircraft was substantially damaged andthe student pilot received minor injuries. The pilot had a total of 47 flight hours all of which were in the same make and model aircraft.…NTSB LAX85FA086Accident · 1 fatalField investigationFinal reportCessna 172N · Livermore, CAThe non-instrument rated pilot departed the arpt on a special VFR clearance. Wx at the time was 1,000 overcast, 2.5 miles in light rain and fog. Acft turned eastbound following a highway toward a pass in the hills to the east and collided with the rising…NTSB FTW85FA088Accident · 4 fatalField investigationFinal reportMooney M20J · San Antonio, TXThe non-instrument rated plt obtained a wx briefing & filed an IFR flt plan although poor wx conditions existed (200 ft ceiling & one-half mi visibility) at San Antonio. The tower instructions to N5681K were to fly rwy heading (120 deg) after departure,…NTSB FTW85FA087Accident · 3 fatalField investigationFinal reportCessna T210N · Brackettville, TXThe plt had filed an instrument flt plan from how to dht and had received a wx briefing for the route. The flt proceededto dht where radar contact was lost and the acft was cleared for an apch. The plt canceled IFR. The plt then proceeded to Brackettville,…NTSB FTW85FA086Accident · 1 fatalField investigationFinal reportCessna 441 · Marble Falls, TXThe acft crashed aprx 1.5 miles south of the departure end of rwy 17 during an attempted rwy 17 NDB apch. The acft was cleared for the apch at 2012 CST and the plt canceled IFR reporting the arpt in sight at 2014. A witness located aprx 1 mile south of the…NTSB CHI85LA078Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Ypsilanti, MIThe acft collided with a fence & two parked cars during a forced landing while on a personal flt. The plt reported that after a 40 to 50 min ground delay he made a normal climb to 5000 ft MSL where he trimmed the acft & leaned the mixture to 75 percent power.…NTSB SEA85FA036Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Imlay, NVPlt was reportedly engaged in aerial coyote hunting, witnesses observed acft of this description flying low and slow in vicinity but there were no eyewitnesses to the crash. Investigation revealed acft impacted ground upright with high vertical descent rate.…NTSB LAX85LA085Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Cottonwood, AZWitnesses reported that the acft was in level flight at treetop altitude along a river and that the engine was operatingnormally until the acft struck & severed three power lines before impacting the riverbank about 200 ft west of the wiresNTSB LAX85FA084Accident · Serious injuriesField investigationFinal reportCessna 310 · Temecula, CAThe acft experienced a total power loss of the rt eng during takeoff from rancho calif airport & crashed about one half mi northwest. The plt reported that the acft would not climb, nor would it maintain altitude at about 40 ft AGL. He stated that when he…NTSB DEN85LA050Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Poplar, MTAccording to the plt he was flying the acft 'low and slow' to look for deer when the accident occurred. He stated that he pulled the power back to glide down and observe wildlife and when he reapplied power there was severe hesitation and the eng did not pick…NTSB DEN85LA049Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Cody, WYThe student plt had the acft owner's (employer) permission to use the acft for solo practice toward obtaining his private plt certificate. Plt was ranch employee and knew one ranch manager would be looking for sheep, plt diverted from instructor's…NTSB ATL85LA066Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Ft Knox, KYN6666P, contacted the ground 100 yds short of rwy 36 during landing at Ft Knox, KY, while on a personal flight. The acft sustained substantial damage to the nose, left main landing gear, both wings and the propeller. Investigation revealed the acft exceeded…NTSB ATL85LA065Accident · No injuriesLimited investigationFinal reportMooney M20E · Monroeville, ALPlt unable to electrically or manually fully extend landing gear in traffic pattern so he decided to make a gear up landing. Unknowingly plt had lowered gear to a transit position and gear collapsed on landing. Plt had previous problems with gear and had to…NTSB ATL85FA067Accident · 2 fatalField investigationFinal reportRobinson R-22 Alpha · Huntsville, ALA popping sound then a loud noise and a puff of smoke preceded the helicopter's fall to the ground, stated a 12 year old boy who said he saw the accident. Examination of the helicopter failed to disclose any trace of fire. However one main rotor blade…NTSB MKC85FPG02Accident · Minor injuriesFinal reportCessna 210L · Newport, ARThe acft collided with trees during an emergency landing following a loss of pwr en route. The eng and prop separated during the accident and were submerged in water which prevented an examination to determine cause of the pwr loss.NTSB LAX85LA082Accident · Minor injuriesLimited investigationFinal reportRawdon Bros. T1 · Phoenix, AZThe plt planned to fly from santa ana, CA. To scottsdale, AZ. The plt reported that the acft had enough fuel for 4 hrs of flying time. The acft's fuel gages are located on the wings & a flashlight is required to see them at night. The plt stated that he was…NTSB FTW85LA085Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · San Antonio, TXThe plt attempted to extend the landing gear but failed to complete the landing checklist by insuring that the gear were down and locked. The acft landed gear up causing a small post crash fire. The plt had been requested to keep his speed up during the apch.…NTSB FTW85LA083Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Grapeland, TXThe pilot stated after the accident that he was in level flight at 1400 feet MSL when he applied carburator heat as a precautionary measure due to favorable carb icing conditions. The engine began running rough and quit within 2 to 3 seconds. Attempts to…NTSB FTW85FA084Accident · 4 fatalField investigationFinal reportBeech A36 · Lake Charles, LAThe acft crashed 3 miles short of the Lake Charles airport while on an ILS approach. Instrument meteorological conditions prevailed at the time of the accident, and an IFR flight plan was filed by the non-instrument rated pilot. A review of the radio…NTSB CHI85LA082Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Flint, MIDuring a flt in IFR conditions the acft encountered icing. The ice was still on the wings and tail when the acft prepared to land. Extra airspeed was carried on final approach. The acft ballooned as it flared for touchdown. It then stalled and made a hard…NTSB CHI85LA076Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Byron Township, WIThe low time 55 hr pilot was wx briefed on unfavorable flt conditions en route to destination. He departed no flt plan. As he approached destination, 8 mi south, the ceiling had lowered to 200 ft, visibility one mi; icing on windshield. While following…NTSB ANC85FA031Accident · Minor injuriesField investigationFinal reportPiper PA-18 · Girdwood, AKThe plt reported a loss of elevator control during the takeoff climb portion of a touch-&-go landing. Examination of the wreckage disclosed a broken turnbuckle that was still attached to the upper end of the elevator horn.NTSB MIA85LAMS1Accident · 1 fatalFinal reportAeronca 7ACAcft was reported overdue 3 days after it departed cross city, FL, on a VFR x-country. Search and rescue operations began on 12/26/84 and were suspended on 01/07/84. Plt and acft were not found.NTSB MIA85LA063Accident · No injuriesLimited investigationFinal reportBeech 58P · Deland, FLN41Q was taxiing to the ramp after landing. As N41Q taxied behind N3707N, who was starting the rt engine, propwash caused plt of N41Q to lose directional control of the acft. Prop of N41Q contacted the left elevator of N3707N.NTSB MIA85LA062Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Naples, FLAfter making a three point landing on the paved runway the pilot lost control of the acft, it veered left and ran off the rwy. The acft then struck a mound of sandy soil and nosed over.NTSB LAX85LA095Accident · No injuriesLimited investigationFinal reportPitts Special SST · Palo Alto, CADuring 3 previous touch & go landings the plt noticed a slight tendency for the acft to turn rt during the landing roll roll. He decided to make a full stop landing. During the landing the plt allowed the acft roll onto the runway shoulder. He said he was…NTSB LAX85LA083Accident · Minor injuriesLimited investigationFinal reportBeech 77 · San Martin, CAOn a night pleasure flt the afct's alternator went off line. The plt elected to make an immediate landing at the arpt he was overflying rather than flying to a fld which had operating rwy lights. The fld he was over had a plt-controlled lighting system, but…NTSB DEN85FA048Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Billings, MTOn dec 23, 1984, a non instrument rated pvt plt crashed into the ground near the arpt at Billings, MT killing all three occupants onboard. Wx conditions at the time were indefinite ceiling 100 ft sky obscured, 1/2 vis with snow and fog. Theplt received prior…NTSB CHI85LA075Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Troy, MIThe plt reported a loss of power while in the traffic pattern. During his manuvering to position the acft for landing, the acft stalled & impacted in a field. Investigation did not reveal any fuel/eng malfunction that would have contributed to the accident.NTSB BFO85LA010Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Newburg, MDDuring ldg roll the PIC felt a vibration as the tailwheel contacted the rwy. In an effort to minimize the vibration the plt lifted the tailwheel off the rwy. The acft began to ground loop to the right toward a pole. Heavy application of the wheel brakes…NTSB ATL85LKG02Accident · No injuriesFinal reportCessna 172N · Tuscaloosa, ALThe acft veered to the left during the takeoff ground run. The acft departed the rwy into a soft, plowed field where it momentarily nosed down before coming to rest on the main landing gear.NTSB ATL85LA064Accident · No injuriesLimited investigationFinal reportCessna 150 · Moundsville, WVThe solo student pilot departed with both fuel tanks indicating slightly over 1/4 full. 2.3 hrs later the power loss occurred in a descent to the dest arpt. The operator drained about 15 ounces of fuel from the acft and observed no fuel spillage at the site.…NTSB ATL85FKG01Accident · Serious injuriesFinal reportPiper PA-28-140 · Huntsville, ALAccording to the pax very shortly after takeoff the acft 'stall light' illuminated as the acft flew over trees aft the end of the rwy. One pax reported that the acft climbed slightly before it dropped to the ground left wing and nose first. Exam of the eng…NTSB NYC85FA048Accident · 2 fatalField investigationFinal reportRobinson R-22-A · Ellington, CTThe non-inst rated plt continued flt into IMC conditions in a helicopter which was not equipped for flt on instruments. There is no record or witnesses of the plt having received a formal wx briefing but it is reported that the plt was informed of fog moving…NTSB NYC85FA047Accident · 1 fatalField investigationFinal reportCessna 402B · Rochester, NYPrior to tkf the plt was informed of wind shear as centerfield winds as 270 deg at 25 KTS gust to 46 KTS & nw boundary winds as 280 deg at 13 KTS. During tkf the plt reported an opened door & requested to return to land. The acft turned left and descended to…NTSB LAX85LA081Accident · No injuriesLimited investigationFinal reportWeedhopper Super Nova II · Lakeside, CAThe ultralight acft lost power on takeoff & stalled into the ground. According to the builder/plt the capillary type fuel pump had failed to function properly on the takeoff climb causing fuel starvation. He failed to recover from a nose high attitude in time…NTSB LAX85LA080Accident · No injuriesLimited investigationFinal reportHardy Quickie · Hollister, CAThe plt was conducting a high speed taxi run on a newly built acft when it became airborne. He continued the takeoff & flew the acft for a short period of time, then prepared for a landing with partial power. While on final & about 15 ft AGL, he believed he…NTSB LAX85LA079Accident · No injuriesLimited investigationFinal reportBell 47G · Chatsworth, CAThe plt was practicing off airport touch & go's. on the second lndg the left skid contacted a hidden dirt embankment andthe acft rolled over. A post impact fire consumed the aircraft. Both certificated commercial plts aboard the helicopter escaped unharmed.…