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.

NTSB NYC88LA011Accident · No injuriesLimited investigationFinal reportCessna 402B · Nantucket, MAThe plt rprtd that drg an apch to rwy 6 at dusk, a sudden sink rate developed. He applied power & brought the acft to a climb attitude; however, he felt a 'thud beneath the aircraft' & noted that the right main gear light no longer indicated down & locked.…Oct 18, 1987 · N6344X · Substantial damageNTSB NYC88LA010Accident · Serious injuriesLimited investigationFinal reportStinson 108-3 · Henryville, PAOn takeoff from a private airport, the flight encountered downdrafts and the left wing dropped. As the pilot attempted to level the wings, he realized that the aircraft was no longer climbing but descending at a rapid rate. The aircraft crashed on rising…Oct 18, 1987 · N990C · DestroyedNTSB NYC88LA009Accident · No injuriesLimited investigationFinal reportCessna 140 · New Milford, CTThe flight en route was uneventful; however, during the landing at New Milford, CT, the aircraft's propeller struck the surface of the runway & the plane nosed over. The plt stated that he applied the brakes too harshly.Oct 18, 1987 · N2841N · Substantial damageNTSB MKC88LA009Accident · No injuriesLimited investigationFinal reportGrumman American AA5B · Branson, MODuring a lndg on a 3600 ft strip, the acft touched down long. The acft ran off the departure end of the rwy and collided with the terrain causing substantial damage to the acft. Witnesses said they could not find any skid marks along the path taken by the…Oct 18, 1987 · N499GT · Substantial damageNTSB LAX88LA035Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Tucson, AZThe pilot reported that the engine would not start by pressing the starter so he decided to hand prop the engine. After several attempts the engine finally started. The engine immediately increased power and the aircraft jumped the chocks. The non-pilot…Oct 18, 1987 · N8779D · Substantial damageNTSB DEN88LA011Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Aspen, COThe plt rprtd that the flt was headed northeast toward mt yeckel when the acft encountered wind shear & downdrafts & was forced into trees. Rprtdly, the acft was flying over rising terrain in a canyon area at an elev of about 11,000' when the acdnt occurred.…Oct 18, 1987 · N736KT · DestroyedNTSB BFO88LA004Accident · Serious injuriesLimited investigationFinal reportBeech 23 · Front Royal, VAWhile flying at abt 2000 ft AGL, the plt noticed a change in eng sound. The tach indcn dropped below 1000 RPM & the suction gauge went below the green arc. During a subsequent emerg lndg, the nose & left main gear collapsed in soft terrain. No preimpact part…Oct 18, 1987 · N2387Q · Substantial damageNTSB ATL88LA018Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-102 · Whitwell, TNThe glider plt made an off-arpt ldg after realizing that he didn't have enough altitude to return to his departure point. During ldg rollout on uneven terrain, one of the wingtips contacted the terrain and the glider ground-looped.Oct 18, 1987 · N792G · Substantial damageNTSB ATL88LA017Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Clarks Hill, SCThe aircraft was circling about 200 feet above the trees when the pilot began a climbing turn. As he leveled the wings the aircraft began to descend. The pilot applied full power and eased forward on the control stick lowering the aircraft nose slightly. When…Oct 18, 1987 · N98806 · Substantial damageNTSB ANC88FA011Accident · 3 fatalField investigationFinal reportPiper PA-18 · Homer, AKThe weather between Homer and anchorage included marginal conditions along segments of the route. The airline transport rated pilot was encouraged to take advantage of an offer to travel by automobile and still arrive in time for a commitment in anchorage. He…Oct 18, 1987 · N4193Z · Substantial damageNTSB SEA88LA009Accident · No injuriesLimited investigationFinal reportNapper Vancraft · Pocatello, IDThe experimental gyrocopter was on a test flight when the right rudder pedal pivot bolt broke. The aircraft began a spiral in a counter-clockwise direction with the rudder separating from the aircraft at the hinge points. The aircraft continued to spiral to…Oct 17, 1987 · N49694 · DestroyedNTSB SEA88LA008Accident · No injuriesLimited investigationFinal reportCessna T210N · Walla Walla, WAThe pilot landed short and the aircraft's main landing gear struck the edge of a plateau at the approach end of the private strip. The aircraft swerved off the grass runway, the nose gear collapsed, and the aircraft nosed over.Oct 17, 1987 · N7231N · Substantial damageNTSB NYC88LA084Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Hammondsport, NYShortly after takeoff, the Piper PA-12 experienced a loss of power and made an off airport landing. During the landing, the aircraft impacted in a corn field. Examination of the aircraft did not disclose any malfunctions or mechanical failures. Auto fuel was…Oct 17, 1987 · N7817H · DestroyedNTSB NYC88LA012Accident · No injuriesLimited investigationFinal reportCessna 172P · Bedford, MAA Cessna 172, N97313, and a Beech C23, N6718Z, collided in flt as the plts of both acft were arriving to land on rwy 11 at hanscom field. The Cessna plt had planned to land at beverly, MA, but diverted to hansom field due to wx. The Cessna was in a left turn…Oct 17, 1987 · N97313 · 2 aircraft · Substantial damageNTSB MKC88LA020Accident · No injuriesLimited investigationFinal reportCessna 177 · Warrensburg, MOPIC stated she had misjudged ldg, resulting in an uncontrolled porpoise, damaging nose wheel and stabilator. She aborted ldg attempt and returned to departure airport. Considerable difficulty controlling the acft was encountered, but with outside radio…Oct 17, 1987 · N2969X · Substantial damageNTSB MKC88LA008Accident · No injuriesLimited investigationFinal reportCessna 172F · Lamoni, IAThe pilot said he was too high on final and went around. He stated that, when he was on short final during the next approach, he thought he was still too high and put down full flaps. The airplane stalled and touched down short of the runway. The nosegear was…Oct 17, 1987 · N8508U · Substantial damageNTSB MIA88FA008Accident · 1 fatalField investigationFinal reportExtra Flugzeugbau 230 · Arcadia, FLThe accident occurred while the aircraft was performing exhibition aerobatics at an airshow. The acft had just completed a portion of the planned low alt aerobatic sequence which included a tail slide & 3 rolls with the nose of the acft pointed toward the…Oct 17, 1987 · N230WF · DestroyedNTSB LAX88FA016Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201 · Buena Park, CAWhile depg on an IFR flt to VFR conds, the plt failed to provide the correct transponder code per ATC clnc. The local controller (ctlr) reminded him to set the correct code & the plt subsequently replied 'I'm having a problem right now . . . I've got to get…Oct 17, 1987 · N43551 · DestroyedNTSB LAX88DXQ01Accident · Serious injuriesFinal reportPugh LONG-EZ · Newell, CABefore taking off, the plt noted that the wind sock was 'whipping & was about 3/4 full.' He said that after takeoff, he made a flyby at about 50' AGL, with an airspeed of about 150 mph. He then entered a steep climbing right turn. The plt estimated that at…Oct 17, 1987 · N38EZ · DestroyedNTSB ATL88LA016Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Brookville, OHWhile on final approach the acft began to fall below the flight path the plt desired. Remedial actions were insufficient to correct the deviation. The acft impacted short of the rwy and collapsed the landing gear. Investigation revealed the use of 40 degrees…Oct 17, 1987 · N737WU · Substantial damageNTSB ATL88LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Homer, GAThe pilot reported a gradual decrease in power after reaching 4000 feet. The plt was unable to obtain a restart. He then elected to attempt a forced landing in a field. The aircraft collided with a tree prior to landing. The aircraft collided with and came to…Oct 17, 1987 · N1547X · Substantial damageNTSB ATL88LA014Accident · No injuriesLimited investigationFinal reportCessna 152 · Murfreesboro, NCThe student plt became lost on the return leg of his 1st solo cross-country flt. He elected to make a precautionary ldg in a plowed field after observing the acft fuel gauges indicating near empty. The acft nosewheel sank into soft dirt during rollout and the…Oct 17, 1987 · N757AD · Substantial damageNTSB ATL88LA013Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Hampton, GAThe CFI rptd that the student flared the airplane about 50 ft abv the rwy and stalled it; the airplane dropped to the rwy and bounced. He assumed control of the airplane from the student and attempted to prevent a crosswind from blowing the airplane to the…Oct 17, 1987 · N91461 · Substantial damageNTSB ANC88LA008Accident · No injuriesLimited investigationFinal reportCessna 207A · Sheldon Point, AKThe air taxi pilot attempted to land on a short narrow gravel air strip in crosswind conditions. He ran off the end of the runway and the airplane was substantially damaged. The wind was in excess of recommendations for the type acft. A witness reported that…Oct 17, 1987 · N1472M · Substantial damageNTSB SEA88LA007Accident · Minor injuriesLimited investigationFinal reportCessna 180K · Petersburg, AKThe plt of the floatplane rprtd that after the acft touched down drg a water lndg & was on the 'roll-out,' she pushed the carb heat in & leaned forward to raise the flaps. At about that time, the floatplane bgn to swerve. She attempted to regain control;…Oct 16, 1987 · N63071 · DestroyedNTSB LAX88LA017Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · San Mateo, CAWhile over the ocean, the pilot noted that the engine did not sound right and that the oil pressure indication had dropped to zero. Shortly afterward, the engine began to vibrate violently and seized. The pilot planned for a forced landing to an open field…Oct 16, 1987 · N9097P · Substantial damageNTSB FTW88FA007Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Houston, TXThe acft developed a fire in the eng area during the initial climb after takeoff. When the eng lost power the plt attempted a lndg in a small park. The acft touched down just short of a drainage ditch and collided with the sloping embankment on the opposite…Oct 16, 1987 · N3903W · DestroyedNTSB FTW88FA006Accident · 3 fatalField investigationFinal reportCessna 172RG · Refugio, TXThe plt continued VFR flt into wx that was IMC. The acft impacted the terrain in an extremely nose low attitude. There was no record of the pilot receiving any pre-flt or in flight weather briefings or forecasts for this flight. A witness reported normal…Oct 16, 1987 · N9693B · DestroyedNTSB BFO88FA003Accident · 1 fatalField investigationFinal reportCessna 172H · Indian Head, MDThe non-certificated plt took the acft without proper authority. A note was found in his automobile that showed he intended to commit suicide. A revolver was found at the crash scene with a spent cartridge under the hammer. Postmortem studies showed the pilot…Oct 16, 1987 · N9WB · DestroyedNTSB BFO88DHD02Accident · No injuriesFinal reportBoeing A75N1 · Milton, DEThe pilot's improper brake application during a 'wheel' landing, which resulted in the aircraft nosing over. The slight downslope of the airstrip, a quartering tailwind, inadequate supervision on the part of the check pilot, and the pilot's lack of…Oct 16, 1987 · N53488 · Substantial damageNTSB ANC88LA009Accident · Minor injuriesLimited investigationFinal reportCessna A150K · Whittier, AKThe PIC got lost while flying above an overcast. When he finally found an opening and descended below the clouds he was low on fuel. He located some buildings on a narrow beach and attempted to land. He overshot the beach and struck stacks of building…Oct 16, 1987 · N8477M · Substantial damageNTSB MIA88IA011Incident · No injuriesIncident investigationFinal reportCASA C-212-200 · Mayaguez, PRThe commuter flt was taxiing to the gate, when the plt observed a fire warning light for the no 2 eng. The fire bottle was discharged & the fire was extinguished. An exam revealed that a fuel line, p/n 3103385-1, had broken and had started a fire. An exam of…Oct 15, 1987 · N436CA · Minor damageNTSB LAX88FA015Accident · 3 fatalField investigationFinal reportDassault-Breguet DA 10 · Rancho Murieta, CAIn flight loss of control by the pilot flying while performing an intentional low level aerobatic maneuver.Oct 15, 1987 · N121FJ · DestroyedNTSB CHI88FA005Accident · No injuriesField investigationFinal reportCessna TU-206G · Lansing, MIImmediately after takeoff the plt noted strong pressure on the right rudder. He trimmed out the rudder pressure and continued to fly in the local area. Approach flare and touchdown were normal. When the nose wheel contacted the runway the airplane veered…Oct 15, 1987 · N9359Z · Substantial damageNTSB ATL88DKG01Accident · No injuriesFinal reportCessna 188 · Samson, ALThe plt said the prop surged during a swath run. While rtning to land the engine quit. The acft landed in a plowed field, resulting in substantial damage to the rt wing and lndg gear. Inspection of the engine by the plt revealed that the oil filter adapter…Oct 15, 1987 · N731RF · Substantial damageNTSB SEA88LA006Accident · No injuriesLimited investigationFinal reportCessna 206 · Winnemucca, NVThe acft nose gear collapsed during takeoff and the acft nosed over. The plt stated to inspectors that recent maintenance had been performed on the nose gear. Shortly after the accident the acft was locked in a hangar. The plt has failed to file an accident…Oct 14, 1987 · N9040M · Substantial damageNTSB NYC88LA007Accident · 1 fatalLimited investigationFinal reportPiper J3 · Island Falls, METhe Piper J-3 cub experienced a power loss while cruising at an altitude described by witnesses as just above the trees. The aircraft was destroyed and the pilot was fatally injured. Examination of the engine disclosed that that fuel drain valve on the fuel…Oct 14, 1987 · N92440 · DestroyedNTSB NYC88DHD01Accident · No injuriesFinal reportBell 206L · Trenton, NJThe loss of engine power due to fuel starvation, and the pilot's poor aircraft handling during the autorotation.Oct 14, 1987 · N16736 · Substantial damageNTSB MKC88FA007Accident · 2 fatalField investigationFinal reportChampion Aeronca 7GC · Columbia, MOWitnesses reported the pilot had planned to practice 'taildragger' takeoffs and landings. They reported the aircraft operated routinely from engine start through the final approach segment of a VFR traffic pattern. While stabilized at about 400 ft AGL on…Oct 14, 1987 · N4889E · DestroyedNTSB ATL88LA019Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Lexington, KYDuring a dual instructional flight the student leveled the acft abv the rwy during the landing flare. The CFI told the FAA inspector that he was verbally coaching the student and did not assume the flt controls. The acft landed hard and the student applied…Oct 14, 1987 · N4639J · Substantial damageNTSB ATL88LA012Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Scyrene, ALThe engine lost pwr during a low-altitude powerline patrol. The airplane nosed over during the subsequent forced ldg. Post-crash examination of the acft by an FAA inspector revealed that the fuel tank vent system was obstructed with mud-dauber nests in…Oct 14, 1987 · N22553 · Substantial damageNTSB ATL88LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbia, SCThe student pilot was flying solo for the first time. Two landings had been completed successfully. The pilot misjudged the final approach and touched down short of the runway. The aircraft landed hard causing the nose gear to collapse.Oct 14, 1987 · N5117B · Substantial damageNTSB ATL88DMG02Accident · Minor injuriesFinal reportQuestair 20 · Greensboro, NCShortly after take-off, at about 500 ft AGL, the engine quit and the pilot attempted to return to the airport and land. The aircraft crashed and caught fire. The fuel system was found to have three fuel selectors installed. The main fuel selector, which…Oct 14, 1987 · N62V · Substantial damageNTSB ANC88LA006Accident · Minor injuriesLimited investigationFinal reportCessna 207A · Tin City, AKThe pilot stated the wind was a direct crosswind and the velocity was 30 knots gusting to 38 knots. During the take off roll, the airplane lifted off the ground and then settled and ran off the end of the runway.Oct 14, 1987 · N91021 · Substantial damageNTSB NYC88LA006Accident · No injuriesLimited investigationFinal reportCessna 150 · Croghan, NYThe pvt plt & one passenger became disoriented while they were on a x-country pleasure flt. The plt was unable to contact any communication center, so she landed in a field & obtained info to get her bearings. She took off again using short/soft field…Oct 13, 1987 · N3497J · Substantial damageNTSB MKC88FA005Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300T · Lincoln, NEDuring climbout, smoke began filling the cabin and shortly thereafter the eng stopped. Ground witnesses observed smoke coming from the eng compartment just before the acft impacted a large woodpile behind a house located 1/2 mile east of the arpt. Examination…Oct 13, 1987 · N39922 · DestroyedNTSB MIA88LA015Accident · No injuriesLimited investigationFinal reportCessna 310P · Bay St. Louis, MSAccording to the plt, the acft was being taxied to takeoff when it struck a drainage ditch at approximately 65 mph, collapsing the landing gear, damaging both wings, both engines, props & the fuselage structure. After this accident the acft was seized by U.S.…Oct 13, 1987 · N5770M · Substantial damageNTSB FTW88FA005Accident · Serious injuriesField investigationFinal reportCessna 175 · Crystal City, TXThe plt was attempting a night visual apch to his unlighted pvt strip when the acft struck trees, flew under a pwr line,struck additional trees & subsequently impacted the gnd. The acdnt occurred aprx 2.5 miles short of the threshold. Samples of the plt's…Oct 13, 1987 · N6512E · DestroyedNTSB FTW88DRA01Accident · Serious injuriesFinal reportWatkins/Monnett Moni · Silsbee, TXShortly after takeoff, the eng lost power & the plt tried to return to the arpt. However, as he was shutting off the fuel, the acft stalled & began to spin. He initiated corrective action, but the acft collided with trees before he could recover. An…Oct 13, 1987 · N19MW · Substantial damageNTSB NYC88FA005Accident · 2 fatalField investigationFinal reportCessna 150H · Gardner, MAWhile executing tough-and-go landings, the pilot neglected to partially raise the wing flaps, as recommended in the owners manual, before lifting off. Thereafter, the pilot failed to maintain a safe airspeed for the landing configuration and inadvertently…Oct 12, 1987 · N50342 · Destroyed