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 MKC87LA005Accident · No injuriesLimited investigationFinal reportStahl-Ameter Monnett Sonerai II · Arab, MOThe pilot stated that the aircraft had capacity for ten gallons of usable fuel, and that he flew for less that an hour before landing at columbia, Illinois. According to the pilot, the sight gauges were not accurate on the ground and he did not visually check…NTSB MKC87LA001Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Tribune, KSThe PIC rptd eng failure while in cruise flt. The student PIC suspected carb icing as the cause of the eng failure. No mechanical pblm was discovered during the eng inspection. The icing probability charts indicated that carburetor icing was likely in the…NTSB LAX87LA011Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Yuma, AZA Bellanca 7KCAB lost control and veered off rwy 16. The CFI indicated that the aircraft veered right during landing roll. The student pilot applied left pedal and the aircraft swung left and ground looped. The aircraft dropped off the rwy shoulder, breaking…NTSB FTW87DRD01Accident · No injuriesFinal reportCessna A188B · Gilbert, LAThe acft was conducting aerial application operations when a decrease in fuel pressure and engine surging occurred. Examination failed to reveal a reason for the loss of fuel pressure and the subsequent surging of the engine. The emergency landing had to be…NTSB DEN87LA001Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Glenwood Spring, COWhile on takeoff the acft became airborne, settled back onto the rwy, ran off the end of the rwy into a 150 foot deep river gorge, and impacted in the river.NTSB SEA87IA003Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Seattle, WADuring attempt to apply ground power to acft, internal feeder cables shorted and melted down. Investigation revealed poor workmanship by contracted maintenance personnel in modification installation.NTSB NYC87LA009Accident · No injuriesLimited investigationFinal reportEiriavion PIK-20E · Erwinna, PAFlight encountered turbulence on descent below tree top level and when about 150 feet from the threshold a downdraft was encountered causing the aircraft to collide with the ground. The aircraft groundlooped when the left wing caught in the tall grass.NTSB NYC87DHJ01Accident · Serious injuriesFinal reportCessna 150M · Farmingdale, NYThe plt was returning home after flying for aprx 2 1/2 hours. The plt reported that he had started the flt with full fuel tanks. The acft experienced a loss of power and the plt attempted a forced landing at an arpt. He was unable to reach the rwy and the…NTSB MKC87LA004Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Seward, NEThe plt reports that he was landing on his private grass strip which is 1600 x 60 ft. he said the grass on the edges was thicker then that in the middle. During landing roll the acft drifted to the lt and the lt wing collided with milo growing along the lt…NTSB MKC87LA003Accident · No injuriesLimited investigationFinal reportCessna 150J · Peculiar, MOThe plt reported that the acft encountered a downdraft as he made his apch to land at his pvt strip. The wind was from 250 degs at 7 KTS, a headwind for the landing acft. The plt reported no mechanical control difficulty during final apch. The plt reported…NTSB MKC87FA002Accident · 2 fatalField investigationFinal reportCessna 150 · Fort Scott, KSThe purpose of the flt was to observe and photograph the effects of a flood which had inundated a part of the city of Fort Scott. The acft was observed flying low and slow over the city. Witnesses said the acft was flying from west to east and made a turn…NTSB MIA87FA003Accident · 1 fatalField investigationFinal reportGriffin STAR-LITE · Raymond, MSThe plt had just completed building the acft and was on the initial flt. Family members watched as the acft tookoff and climbed over the arpt. They then observed pieces falling from the acft. The acft rolled inverted and crashed. An exam of the elevator bell…NTSB FTW87LA003Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Kerrville, TXDrg the initial climb after takeoff, the eng lost power & the plt made a gear up lndg. A post acdnt exam revealed the eng intake air supply was blocked off by a ball of paper that had gotten into the open ram air intake valve. This resulted in the loss of…NTSB FTW87LA002Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Minden, LAThe non-instrument rated plt entered IMC conditions while in cruise flt on a dark night at an altitude of 500 ft. he then entered a descent to reach VMC. During the descent, the helicopter collided with a tree at aprx 75 to 100 feet AGL,then crashed to the…NTSB CHI87LA001Accident · No injuriesLimited investigationFinal reportCessna 152 · West Chicago, ILThe student pilot assumed he had full fuel tanks prior to takeoff. He then proceeded to fly the aircraft for approximately 4.4 hours. Just prior to his final landing he was forced to go around due to an aircraft on the runway. Following this go around he…NTSB CHI87DEE01Accident · Minor injuriesFinal reportCessna 182E · Plainfield, ILAccording to the pilot he performed a 'thorough' fuel system preflight by draining three clear fuel specimens from each wing and the belly drains. Shortly after takeoff the engine quit due to water contamination of the fuel system. Following the accident a…NTSB ATL87FA001Accident · 3 fatalField investigationFinal reportPiper J3-65C · Goldsboro, NCThe J-3 cub had been practicing touch and go landings at the uncontrolled airport when the Cessna 182 was returning from a cross-country flight. The pilot of the Cessna had received UNICOM airport advisories that indicated rwy 22 was the active runway. The…NTSB ANC87LA001Accident · No injuriesLimited investigationFinal reportPiper PA-22 · North Pole, AKAfter touchdown on the grass next to the runway, the pilot lost directional control of the aircraft and struck a snowbank.NTSB SEA87LA002Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Roseburg, ORThe plt initiated the takeoff from a taxiway with a 100 ft obscured sky and 1/4 visibility in fog. The non-instrument rated plt was unable to maintain the rwy heading during initial climb. The acft drifted to the right of the taxiway and struck trees located…NTSB SEA87IA004Incident · No injuriesIncident investigationFinal reportCessna 402C · Everett, WAWhile enroute from seattle to bellingham on a regularly scheduled passenger commuter flight the left engine number 3 exhaust riser burned through. The pilot visually detected a discoloration on the left engine nacelle inflight but was unable to execute a…NTSB LAX87LA007Accident · No injuriesLimited investigationFinal reportCessna 180 · Lucerne Valley, CAThe pilot stated that the wind had been light and variable with intermittent gusts and on the take-off roll as the nose of the aircraft suddenly swung 30 degrees to the left and he was unable to compensate with right rudder. The right wing tip then dug into…NTSB LAX87LA006Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G103 Twin II · Calistoga, CAAt the end of a local pleasure flight near clistoga, claifornia, the pilot stated the nose of his glider was pushed down while on base leg at calistaga airpark. Due to a loss in altitude to increase airspeed, the pilot was unable to reach the runway. A forced…NTSB LAX87LA005Accident · No injuriesLimited investigationFinal reportWaco YKS-7 · San Diego, CAThe acft departed montgomery airport at abt 0954 hours. Shortly after departing the airport the engine began to cut-in and out. The plt contacted gillespie airport tower and requested to execute a precautionary landing and almost simultaneously the engine…NTSB LAX87LA004Accident · No injuriesLimited investigationFinal reportGillon Quickie Q2 · Goleta, CAPrior to the accident flight of the experimental homebuilt, the spark plug inserts in the engine cylinders were changed to steel ones. The pilot said that during the flight he heard a loud noise emanate from the engine followed by a partial loss of power. The…NTSB LAX87DVG01Accident · No injuriesFinal reportSmith & R. Mathews RV-4 · Lincoln, CADuring a local test flight of an experimental home built acft, the engine experienced a total loss of power at aprx 3000 ft AGL. Unable to return to the airport, the plt landed in an open field. Aprx one ft above the two foot high grass, the plt raised the…NTSB DEN87DTE01Accident · No injuriesFinal reportCassutt Sport Racer · Brighton, COThe plt rprtd that he did not properly lock the canopy & it came open drg flt at 7000 ft MSL. He reduced the speed & attempted to close the canopy, but was not successful. He diverted & attempted to land at the van aire arpt while holding the canopy with his…NTSB DCA87AA002Accident · 3 fatalFinal reportLockheed 382G · Kelly Afb, TXAfter the acft landed at Kelly Afb, TX, on 10/2/86, there was a crew chg bfr it depd on the next flt. Drg the next take-off, the acft lifted off near the midpoint of rwy 15 (aprx 5775' fm the apch end). When it was at aprx 100' to 200' AGL,witnesses saw it go…NTSB BFO87DID01Accident · No injuriesFinal reportPiper PA-28RT-201 · Lynchburg, VAWhile on the takeoff roll, the acft collided with a deer. The plt rprtd that he had accelerated to 50 KTS & was about 1000 ft down the rwy when the deer ran in front of theNTSB NYC87LA005Accident · No injuriesLimited investigationFinal reportCessna C-150 · Plymouth, MAThe student pilot flared long during landing and the instructor initiated a go around. During a right turn away from buildings, the aircraft stalled and collided with the ground on its nose and flipped over.NTSB NYC87FA006Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Holyoke, MAThe aircraft was attempting to make a special visual flight rules arrival when it crashed into a rock face slope 2 miles east of the airport while on a easterly heading. The accident occurred over 1 hour after sunset. The pilot did not have an instrument…NTSB LAX87LA008Accident · No injuriesLimited investigationFinal reportCessna 172N · Hayward, CAA Cessna 172N landed adjacent to rwy 28L. According to the FAA the solo student plt was unable to correct for a strong wind and landed in a grass area south of the runway. The winds were reported from 360 deg at 17 KTS at the time of the accident. The pilot's…NTSB LAX87LA003Accident · No injuriesLimited investigationFinal reportCessna 152 · Torrance, CAA Cessna 152 went out of control during takeoff ground run and then collided with a dirt bank and nosed over. The student plt indicated that he was practicing touch and go landings when the accident occurred. He had just applied takeoff power after landing…NTSB LAX87LA002Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Holbrook, AZJust after takeoff, the right engine lost power at an altitude of approximately 450 feet. The right propeller was feathered, but the pilot was unable to maintain altitude. Subsequently, the aircraft collided with terrain about 3 miles south of the airport.…NTSB BFO87LA002Accident · No injuriesLimited investigationFinal reportBeech D-45 (T-34B) · Patuxent River, MDThe purpose of the flt. Was to check out the 11800 hour former naval aviator who stated he had previous experience in T-34B'S. The CFI, who had over 3000 hours, 173 in make and model but less as an instructor, stated he briefed the student on procedures and…NTSB SEA87LA008Accident · No injuriesLimited investigationFinal reportCessna 172N · Madras, OROn landing touchdown, aircraft nose tire blew out. The student pilot over-corrected with controls and power, causing the aircraft to balloon into the air and touch down a second time in a flat attitude, resulting in a hard landing.NTSB NYC87LA004Accident · No injuriesLimited investigationFinal reportBeech BE-58P · Derry, PAThe flight suffered an engine power loss while in cruise flight due to fuel starvation. The pilot stated that a pretakeoff check of fuel gauges was made and they all indicated fuel on board.NTSB NYC87LA003Accident · No injuriesLimited investigationFinal reportCessna 150 · Buxton, METhe pilot was making a short field landing at a private airstrip which was grass covered and wet. The pilot came in too high and long and once on the ground, skidded to a stop between two trees.NTSB MIA87FA002Accident · 1 fatalField investigationFinal reportPiper PA-60-600 · Tallahassee, FLWitnesses stated seeing the acft enter a left downwind apch to rwy 16, turn base to final normally then veer to the left of the runway in a nose high attitude & disappear behind a line of trees & crash aprx 500 feet east of rwy 16. Post crash examination of…NTSB LAX87LA001Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Palo Alto, CAThe acft went out of control and ran off the rwy. The student plt indicated that on his first apch his altitude was too high and he was aligned to the left of the rwy. He initiated a go-around and made a second attempt. During the flare on his second apch the…NTSB FTW87LA001Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Sulpher, LAThe pilot landed long at a private grass airstrip and deliberately ground looped the aircraft to avoid overrunning the airstrip into a three foot ditch. The nose gear collapsed during the ground loop and the wings and main gears were damaged when the aircraft…NTSB BFO87LA001Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Hillsville, VAAfter touchdown on the rwy, the plt held the nose wheel off for about 200 feet of travel by holding the control wheel back. According to him, the acft then veered to the left and he was unable to steer it with the rudder pedals. The acft went off the side of…NTSB SEA87LA001Accident · No injuriesLimited investigationFinal reportCessna 185-F II · Juneau, AKPilot attempted overwater approach to VFR airport through fog bank in conditions decreasing to 200 ft clg and one mi viz. On encountering total IMC, climbing turn took acft over land. Acft collided with trees at 800 ft level.NTSB NYC87LA001Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Caldwell, NJThe pilot in command allowed the aircraft to become too low during a night simulated emergency (engine out) during an instructional flight. The aircraft contacted the tops of trees, became uncontrollable and crashed to the ground.NTSB NYC87FA002Accident · 2 fatalField investigationFinal reportCessna 152 · Lumberton, NJDuring a take off, the acft was observed in a nose high attitude. After reaching an altitude of about 300 ft AGL, it went into a steep dscnt & crashed in about a 70 deg nose low attitude. No preimpact part failure or malfunction was evident. Reportedly, the…NTSB MIA87LA001Accident · Serious injuriesLimited investigationFinal reportCessna T310R · Titusville, FLThe plt stated that while at 9,000 ft, aprx 8 miles north of tico arpt, he lost fuel pressure in his left eng and while attempting to restart the eng and find the arpt he was unable to make it to the runway. The acft landed about 150 ft short and collided…NTSB LAX86LA358Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Chino, CAThe acft ground looped in a freshly plowed field during a forced landing after completing a banner tow operation. The plt indicated that he had just entered a downwind traffic pattern for the banner release area when the eng began to run rough and lose power.…NTSB ANC86LA167Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Fognak Island, AKOn takeoff, the right door popped open. The pilot reached across to pull the door closed and lost directional control of the aircraft. The aircraft then struck a tree near the bank of the lake.NTSB LAX86LA359Accident · No injuriesLimited investigationFinal reportCameron 0-77 · Tiburon, CAAfter completing an aerial advertising flight across the san francisco bay, the plt attempted a landing on up-sloping terrain. The terrain was steeper than anticipated & the plt became distracted. The plt forgot to turn off the pilot light to the left burner.…NTSB LAX86FUG06Accident · No injuriesFinal reportCessna 188 · Thermal, CAThe plt lost directional control of the acft during his 4th takeoff from the rutted rwy surface. The tail wheel slipped into a rut on the rwy and the acft veered to the right where it contacted 8-10 ft tall brush. The acft traveled through the brush,…NTSB FTW86LA174Accident · No injuriesLimited investigationFinal reportBeech TC-45J · Laredo, TXJust after the plt began the takeoff roll, the right main landing gear collapsed. An exam revealed that overload failure of the right main landing gear trunion tube had occurred. There was evidence that the overload resulted from either a previous hard…