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 MKC84LA267Accident · No injuriesLimited investigationFinal reportCessna 150L · Marshall, MOThe acft engine lost power while descending after 1 hr of flt. During the ensueing forced lndg the plt said he changed his selection of landing site because of an auto on the selected site (a highway). The acft was landed beside the road &a collision with a…NTSB MIA84LA245Accident · Serious injuriesLimited investigationFinal reportChampion 7FC · Fort Drum, FLThe acft collided with a power line and the ground after a loss of power during takeoff. The plt was not certificated. The passenger said that the plt attributed the power loss to water in the fuel. The acft was being operated on automobile fuel. Attempts to…NTSB MIA84LA244Accident · No injuriesLimited investigationFinal reportMooney M20J · Key Largo, FLAcft was landed downwind and touched down aprx half way down the rwy. The plt in an attempt to avoid an overrun intentionally ground looped the acft resulting in a left main gear collapse.NTSB LAX84LA477Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Byron, CADuring takeoff, the eng lost power as the acft was climbing between 400 & 600 ft. subsequently, the right gear collapsed when the acft was landed on rolling terrain. The plt estimated there was about 2 gal of fuel on board.NTSB LAX84FUJ03Accident · Serious injuriesFinal reportCessna T337E · Chandler, AZThe plt reported that on the first attempt to rotate, the stall warning horn activated. The plt noticed the rear eng in an overboost cond so he retarded the throttle completely, then advanced it to below red line. He continued the takeoff and attempted to…NTSB FTW84LA377Accident · No injuriesLimited investigationFinal reportCessna 177B · Texas City, TXAccording to the plt, during the pre-flt inspection the fuel tanks were checked by dipping his fingers into the tanks to determine how much fuel remained. Neither tank was full but the plt estimated that sufficient fuel remained for the flt. Above the fuel…NTSB FTW84FA374Accident · 1 fatalField investigationFinal reportMiller Air Sports GEM 260 · Martindale, TXNotes left by plt indicate he had been testing the flight envelope of this experimental racing acft, including operation of the engine beyond prop limit of 4000 RPM. Witnesses heard engine sound suddenly speed up to high RPM then cease altogether. Some…NTSB ATL84LA278Accident · Minor injuriesLimited investigationFinal reportHead Balloons AX7-77 · Austell, GAWhile flying at a low alt looking for a suitable landing area the plt noticed power lines at a higher alt. Plt initiallyapplied heat to the envelope to try and climb above the wires, but did not immediately realize the height of the wires. Plt then advised…NTSB ATL84LA276Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Leland, MSThe plt said he was attempting a roll at low alt shortly after takeoff and was unable to complete the maneuver before the acft collided with the ground.NTSB ATL84FA277Accident · Serious injuriesField investigationFinal reportBell 222 · Knoxville, TNThe helicopter was in a hover when a rt pedal turn was initiated and a climb attempted. Plt stated, 'I was unable to climb, and the aircraft began to lose rotor RPM. I increased power to 100% mrtq. The acft was settling.' Unable to sustain flt, a landing was…NTSB ANC84LA164Accident · No injuriesLimited investigationFinal reportCessna 180 · Cordova, AKAccording to the plt, he circled the landing area & then began a low pass (upwind leg) at 30 to 40 ft AGL when the acft started to settle. He applied full power, but the acft struck the ground in a level attitude & rolled to a stop in a boulder patch. During…NTSB ANC84LA162Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Rohn River, AKThe acft would not lift off in the distance the plt thought. The density alt was near 1500 ft and the plt had 130 lbs in the rear seat and baggage area. The plt said that the acft bounced during the roll and then ground looped.NTSB ANC84LA161Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Slana, AKThe acft ran off of a narrow public road during landing. The plt said a gust of crosswind caught his right wing and turned the acft off the road into the bushes.NTSB ANC84LA159Accident · No injuriesLimited investigationFinal reportCessna 172E · Palmer, AKThe acft was taking off from an airport which was an unimproved field site. According to the plt the acft would not accelerate and climb out so he stalled into the brush along a creek bed. The plt said the acft had departed this field before but both times…NTSB ANC84LA158Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Kenai, AKThe acft was damaged in an off arpt precautionary landing atter the engine began vibrating with the oil temperature in the red. The plt said he turned off the ELT to conserve the battery.NTSB MKC84LA266Accident · No injuriesLimited investigationFinal reportBeech BE 58 · Bridgeport, NEPlt initiated take-off from rough, 2800 ft sod strip in light wind conditions and known high density alt situation. Slight back yoke pressure was being used during takeoff roll to moderate effect of rough surface on nose gear. Additional back pressure was…NTSB MIA84LA243Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Miami, FLWhile taxiing for takeoff the acft veered to the left and collided with a parked acft. The plt stated a gust of wind caused the acft to veer. The acft operator reported the plt was helping the pax with a seatbelt when the accident occurred.NTSB LAX84FA466Accident · Minor injuriesField investigationFinal reportBeech C-23 · Huntington Bch, CAThe 2330 ft rwy had a 674 ft displaced threshold & power lines near the apch end. The plt reported that during arrival, he made a steep apch with full flaps & min power. After touching down at about midfield, he realized there was insufficient rwy remaining &…NTSB DEN84FA275Accident · 2 fatalField investigationFinal reportCessna 182F · Rock Springs, WYThe acft was being operated on the return leg of flt from California to Wisconsin. A landing apch was made to rwy 27 at Rock Springs (elev 6747), temp was 76 degrees, wind 220 at 23 KTS. Acft was observed to bounce back into the air after touchdown and then…NTSB BFO84IA004Incident · No injuriesIncident investigationFinal reportBeech 58 · Washington, DCThe plt made an emergency landing on rwy 18 following a loss of power in the rt eng & a subsequent in-flight fire. Investigation revealed a crack in the #1 cyl that originated at the exhaust port, downstream of the valve. The crack propagated through fatique…NTSB ATL84FLT13Accident · Serious injuriesFinal reportPiper PA-22 · Nashville, TNThe engine quit on final apch to the arpt as a result of fuel starvation. Sixteen gallons of fuel remained in the right fuel tank, but the left tank was selected. No fuel was found in the left tank. The acft collided with powerlines during the forced landing…NTSB ATL84FA275Accident · Serious injuriesField investigationFinal reportCessna TR182 · Wilmington, NCThe power loss occurred in cruise at 10,000 ft. at 0903 EDT the pilot notified Wilmington approach control that he had a 'rough engine' and requested vectors to Wilmington. Approach control responded with heading information for the back course approach and a…NTSB ATL84FA274Accident · 2 fatalField investigationFinal reportCessna 402C · Albertville, ALPlt was executing an non-directional beacon approach to rwy 23. Instrument meteorological conditions prevailed at the time of the accident. Radar information obtained during the investigation revealed the plt did not stabilize the airspeed while executing the…NTSB ANC84LA168Accident · No injuriesLimited investigationFinal reportCessna Ector 305A · Anchorage, AKLanding area selected by plt was slick due to mud from recent tidal waters. Acft slid on touchdown and plt was unable to stop. Applied full pwr in attempt to clear a gully at end of landing area. Main gear contacted FAR edge of gully and acft nosed over.NTSB ANC84LA163Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Montague Island, AKThe acft was landed hard and the main landing gear collapsed. According to the plt the landing gear bunger cords broke and there was no safety cable to keep the gear from collapsing. The landing area was a narrow gravel strip running northand south, 1600 ft…NTSB ANC84LA152Accident · No injuriesLimited investigationFinal reportCessna 206 · Nondalton, AKThe acft landed short of the rwy. The wind was from 280 degrees at 12 KTS gusting to 25 KTS. The plt reported that he was caught in a downdraft and full power did not slow the rate of descent.NTSB ANC84LA151Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · Bettles, AKThe acft collided with an overhanging tree branch during a river takeoff. The plt was trying to negotiate a bend in the river while on the 'step' for takeoff. The plt said he had very limited experience in the model acft and it got light on the floats and…NTSB ANC84LA150Accident · No injuriesLimited investigationFinal reportMaule M-6 · Kiana, AKThe acft made a forced landing in the kobuk sand dunes after the engine quit during cruise flt. The plt reported that the engine quit, sputtered once, picked up RPM and then quit completely. The prop windmilled until ground contact. In attempting to restart,…NTSB LAX84LA465Accident · No injuriesLimited investigationFinal reportMooney M-20G · San Jose, CAThe rwy was closed during working hours due to a construction company working in the area. When the construction effort ended the rwy was opened for use. After tower clearance was issued the acft landed and contacted a barricade with the left wing. The pilot…NTSB LAX84FJA02Accident · Serious injuriesFinal reportPiper PA-28-140 · Wailuku Maui, HIThe acft collided with rising terrain during a pleasure flt around Hawaii. The plt turned from the shorline inland to look at a waterfall. He started a climb from 500 ft to clear the 2000 ft level. The plt does not remember any of the accident sequence.NTSB LAX84FA504Accident · 4 fatalField investigationFinal reportPiper PA-32R-301T · Tucson, AZcontrolled flight into terrain that resulted from the pilot's failure to ensure a safe VFR altitude. The dark night, which restricted the pilot's view of terrain, was a factor in this accident.NTSB FTW84LA376Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Apple Springs, TXAfter dispensing a load of gelled gasoline, to burn windrows of brush, the plt landed & refilled the chemical tank. Before taking off, he checked his fuel with a dip stick & decided there was enough remaining to dispense a 2nd load. While flying downwind &…NTSB FTW84LA373Accident · No injuriesLimited investigationFinal reportCessna 172M · Bethany, OKAccording to the plt of N9646H, while he was taxiing under the direction of ground control the acft was struck from behind by N1PN. The plt of N1PN stated that he was cleared to taxi and did not see any other acft as he entered the taxiway. Seated in the rear…NTSB FTW84LA364Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Schriever, LAThe plt stated that he had full fuel & a full load of spray when the eng exploded. The nature & cause of the pwr failurewas not determined & external examination of the eng revealed no evidence of a mechanical failure.NTSB DEN84LA289Accident · Serious injuriesLimited investigationFinal reportRaven AX-8 · Clark, CODuring a normal high wind landing a pax received two fractures of the fibula bone. Another pax reported that the injured pax was standing on one leg with the other knee bent resting on a propane tank during the landing. Pax were reportedly briefed on the…NTSB DEN84FA274Accident · 1 fatalField investigationFinal reportBoeing Stearman E75 · Kalispell, MTThe pilot was completing a turn to final on a normal aerial application maneuver. He was aprx 15 ft AGL at 65 mph when the a/c struck a bird (presumed to be a red tailed hawk). The force of the impact broke the plexiglass canopy and temporarily distracted the…NTSB CHI84LA372Accident · No injuriesLimited investigationFinal reportCessna 120 · Hopedale, ILThe acft nosed over during a forced landing in a corn field after the engine quit. The plt said he was operating on the left tank and when the engine sputtered he realized what was wrong and even though he immediately switched tanks the engine quit and did…NTSB ATL84LA273Accident · No injuriesLimited investigationFinal reportRockwell S2R · Shellman, GAPlt was en route to airstrip after spray run when he smelled smoke. Shortly thereafter the engine surged and lost power. Plt executed a forced landing in a corn field as flames from engine area became visible. Acft damaged by post-landing fire. Investigation…NTSB MKC84LA265Accident · No injuriesLimited investigationFinal reportHughes 269C · Witts Springs, ARWhile manuevering at an alt of 35 to 40 ft above tree the plt felt a shutter and low frequency shaking of the rotor disk. Rotor RPM and engine RPM decreased and the acft entered a shallow descent. The plt applied forward cyclic, reduced collective and…NTSB MKC84FA264Accident · 2 fatalField investigationFinal reportCessna 177B · Bloomfield, MON30755, collided with a radio tower guy wire and crashed three miles east of Bloomfield, MO, while on a business flight. Instrument meteorological conditons prevailed at the time of the accident. Witness stated that the low clouds obscured the top of the 80…NTSB LAX84LA464Accident · No injuriesLimited investigationFinal reportBell 47G-5 · Watsonville, CAThe plt maneuvered during an aerial application flt to avoid high tension wires and collided with lower telephone lines. The plt said the winds were gusty at the time of the accident.NTSB LAX84LA462Accident · No injuriesLimited investigationFinal reportBell 47G-2 · El Cajon, CAThe helicopter made a hard landing during a test flt. The plt reported that the collective was very stiff and he was notable to stop the descent during landing. FAA inspected the helicopter after the accident and found no discrepancies in the control system…NTSB LAX84LA461Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Livermore, CAThe plt visually checked the fuel tanks during his pre-flt & estimated 10-20 gals of fuel remaining in both the left & right tanks. He said that the start, taxi & run-up were performed while using the right rank. He reported that the right fuel gage reading…NTSB LAX84FA463Accident · No injuriesField investigationFinal reportPiper PA-28-180 · Bakersfield, CAThe student plt landed long on an intended touch and go landing and therefore, rolled out to a full stop on rwy 31. A 180 deg turn was made at the end in order to takeoff on rwy 13. Prior to initiating the takeoff, according to the student plt, he placed the…NTSB DEN84LA273Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Littleton, COPlt stated that the entire flt was uneventful. The female passenger had her knees bent in preparation for landing but her body was twisted in a direction that was opposite to her feet when the balloon made ground contact.NTSB DEN84LA272Accident · No injuriesLimited investigationFinal reportCessna 152 · Kirtland Afb, NMUpon touchdown a hard landing was made after which the acft bounced and became airborne. The acft contacted the rwy hard at which time the nose gear collapsed.NTSB DEN84LA271Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Bluffdale, UTPlt was practicing hovering over a 40 x 60 foot helicopter pad. Plt stated, a gust of wind caught the helicopter moving it off the pad and into nearby power lines. The terrain around the pad slopes down. The power lines were located aprx 125 ft from the pad…NTSB CHI84LA371Accident · No injuriesLimited investigationFinal reportCessna 210M · Howell, MIThe plt stated that about 10 min after takeoff, the fuel flow fluctuated & slowly went to zero. He turned the aux fuel pump on, increased the mixture to rich & repositioned the fuel selector to another tank, but to no avail. The plt made a forced landing in a…NTSB CHI84LA370Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Lake City, MIAccording to the plt, at about 30 ft AGL after takeoff the eng RPM began to decrease. The acft flew into a tree adjacent to a road near the end of the rwy. A visual inspection of the engine revealed no mechanical malfunctions. The property owner reported that…NTSB CHI84IA373Incident · No injuriesIncident investigationFinal reportBoeing 737-291 · Madison, WIShortly after lift-off & while climbing thru about 150 ft AGL, there was a loud noise from the left eng when it failed. The aircrew secured the left eng, returned to the arpt & made a single eng landing without further incident. An investigation revealed that…