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 LAX87LA181Accident · Minor injuriesLimited investigationFinal reportGrumman AA1C · Redlands, CADuring an instructional flight, the plt stated that the estimated fuel capacity in the acft was aprx 12 gals prior to departure. The plt took-off on the right fuel tank and flew in the local area for aprx 15 minutes then returned to the arpt for touch-and-go…Apr 18, 1987 · N9545U · DestroyedNTSB LAX87LA180Accident · No injuriesLimited investigationFinal reportCessna 182M · Mammoth Lakes, CAAt the end of a pleasure cross country flt, while on long final to the rwy, the plt had to add pwr to compensate for a crosswind. Prior to reaching short final the plt had reduced pwr again. Upon reaching the threshold, the acft was aprx 300 ft AGL. The plt…Apr 18, 1987 · N71736 · Substantial damageNTSB LAX87DVG03Accident · No injuriesFinal reportGrumman G-164B · Marysville, CAAt the end of an aerial application flt, the plt was aware of a cross wind from the right. The plt touched the acft down on the right main landing gear and held that attitude for aprx 300 ft down the rwy. When the left main gear contacted the rwy it folded…Apr 18, 1987 · N8412K · Substantial damageNTSB FTW87LA098Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Waring, TXThe newly certificated private pilot landed on runway 17 at a small privately owned airport at Waring, TX. There was a wire fence located 18 feet from the left edge of the landing runway. The pilot allowed the aircraft to drift left off the runway and collide…Apr 18, 1987 · N2140D · Substantial damageNTSB FTW87DRA02Accident · No injuriesFinal reportHunter Executive · Arcola, TXThe acft was being test flown following the replacement of a tail rotor drive belt. Following a ground run up and ground taxi, several hovering flts were made successfully. As the non-helicopter rated plt was hovering back to the parking area, he heard the…Apr 18, 1987 · N9728N · DestroyedNTSB DEN87LA107Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Denver, COAn ATP plt was conducting a sight seeing flt over Denver. The plt had 9 hours total time in this model helicopter, 6 hours as PIC. A hovering takeoff was initiated to the north with left turn to the west after takeoff. Current winds were reported from 220…Apr 18, 1987 · N38886 · Substantial damageNTSB DEN87LA104Accident · No injuriesLimited investigationFinal reportDevore Sunbird 100 · Albuquerque, NMAn experimental designed prototype acft was being flown on its first flt. The acft took off and flew in ground effect beyond the arpt boundary. At full pwr, the acft could not maintain altitude and descended uncontrolled to an impact with the terrain. The…Apr 18, 1987 · N100VL · Substantial damageNTSB DEN87FA103Accident · 1 fatalField investigationFinal reportCessna 172 M · Ellicott, COThe acft was equipped with hand operated rudder controls. The plt had an artificial rt leg. On a previous flt that day the plt had attempted to spin the acft but was unsuccessful due to lack of rudder travel with the hand-operated controls. The plt was not…Apr 18, 1987 · N64415 · DestroyedNTSB CHI87DEE08Accident · 1 fatalFinal reportBede BD5 A-B · Kankakee, ILThe pilot took off on the first test flight in his homebuilt aircraft and after climbing to approximately 1000 ft. AGL, stalled the aircraft. The aircraft then subsequently entered a spin and collided with the ground. There were reports of the aircraft's…Apr 18, 1987 · N501RM · DestroyedNTSB ATL87LA116Accident · No injuriesLimited investigationFinal reportCessna 177 · Brookville, OHThe plt reported a partial pwr loss at about 30 ft AGL during the initial takeoff climb. He elected to land straight ahead in a soft, plowed field. The acft nosed over during the landing. Post accident inspection revealed evidence of water in the fuel lines.Apr 18, 1987 · N2356Y · Substantial damageNTSB ANC87LA061Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Goose Bay, AKThe pilot stated that during the takeoff roll at a gravel air strip he lost directional control of the aircraft causing the aircraft to nose over on its back.Apr 18, 1987 · N7081D · Substantial damageNTSB ANC87LA060Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Yentna River, AKThe pilot stated that during the takeoff roll on the gravel bar he lost directional control of the aircraft causing the aircraft to nose over on its back.Apr 18, 1987 · N92524 · Substantial damageNTSB ANC87LA059Accident · No injuriesLimited investigationFinal reportCessna 170 · Talkeetna, AKOn acceleration for takeoff the front seat adjusting catch became disengaged sliding aft to the rear. The pilot lost directional control of the aircraft causing the aircraft to nose over on its back. Examination of the left seat track shows the track was worn…Apr 18, 1987 · N1604D · Substantial damageNTSB SEA87IA084Incident · No injuriesIncident investigationFinal reportSmith, Ted Aerostar Aerostar 601P · Las Vegas, NVAprx 422 flt hrs bfr the flt, the smith Aerostar 601P was modified iaw machen STC SA980NW. Drg level off at 16,500' MSL,blistering & discoloration were noted on the #1 eng nacelle. The plt shut down & feathered the #1 eng, then returned to the departure arpt…Apr 17, 1987 · N90518 · Minor damageNTSB NYC87LA123Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Nantucket, MAThe Piper PA-23-250 attempted a go-around after crossing the threshold and observing the runway lights were not on during a night instrument approach. The pilot reported that he added full power and retracted the wing flaps. The procedure in the Piper manual…Apr 17, 1987 · N40395 · Substantial damageNTSB NYC87FA126Accident · 1 fatalField investigationFinal reportBeech 58P · Pleasantville, NYThe plt rept his auto-pilot was malfunctioning on the apch and he was having aileron problems. He rept a loss of pwr, got the eng started, and then rept a double pwr loss. Prior to disappearing from radar he rept that he was starting one engine. The acft…Apr 17, 1987 · N721WW · DestroyedNTSB MKC87LA082Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Kipp, KSThe engine crankshaft broke into two pieces during an ag flight and during the forced landing in a wet, soft field, the airplane nosed forward to the inverted position.Apr 17, 1987 · N8599L · Substantial damageNTSB MIA87LA143Accident · No injuriesLimited investigationFinal reportCessna 177 · Pickens, MSThe plt reported that during cruise flt the eng RPM began to drop. He then applied carb heat, however, the eng then quit. A forced landing was made in a pasture. During the landing roll, the acft collided with barbed wire and a fence post. Post crash…Apr 17, 1987 · N29652 · Substantial damageNTSB MIA87FA135Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Florida City, FLThe student plt had been authorized by his CFI to conduct a solo x-country training flt under daytime VFR conditions. He departed key west at 0330 EDT on the return portion of the flt. Neither his CFI nor his employer could offer an explanation for the 15 hr…Apr 17, 1987 · N6505C · DestroyedNTSB FTW87LA099Accident · Minor injuriesLimited investigationFinal reportAircoupe 415D · Lakeway, TXThe commercial pilot of an Aircoupe with one passenger on board attempted to execute an overhead 360 degree turn to land on runway 16 at Lakeway airport near austin, TX. The pilot did not have adequate altitude to complete the maneuver. The aircraft impacted…Apr 17, 1987 · N93884 · Substantial damageNTSB DEN87LA102Accident · Minor injuriesLimited investigationFinal reportAero Commander S-2D · Columbus, NMThe plt departed deming, NM and flew to a ranch 15 mi n of Columbus, NM, to position the acft for aerial spraying that day. It was still dark when the plt made his apch to a road paralleled by power lines on the left and telephone cable marker posts on the…Apr 17, 1987 · N1714S · Substantial damageNTSB ATL87LA117Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Columbus, OHWhile taxiing for takeoff on a local flight, the aircraft collided with a parked fuel truck. The pilot said he saw the parked truck and attempted to taxi between it and some parked aircraft. The pilot said he misjudged the clearance and the left wing struck…Apr 17, 1987 · N2183D · Substantial damageNTSB ATL87LA115Accident · No injuriesLimited investigationFinal reportCessna 182Q · Meridianville, ALThe plt completed the vor/dme-b appch to the arpt and cancelled his IFR flt plan. The plt reported observing that the acft was to the right of the rwy while on final appch to rwy 36. He then initiated a go-around, and began a right turn after 'passing' a tree…Apr 17, 1987 · N4798N · Substantial damageNTSB ATL87IA114Incident · No injuriesIncident investigationFinal reportCessna 340 · Myrtle Beach, SCPlt initiated autoplt climb from 12000 to 16000 ft. plt heard a loud snapping noise. Acft pitched up and efforts of both front seat occupants were reqd to keep nose down. Plt stated trim stuck in full nose up position. Plt stated that when the acft approached…Apr 17, 1987 · N25RF · Minor damageNTSB ATL87DLT01Accident · No injuriesFinal reportSchleicher ASK-21 · Eagleville, TNDuring a landing attempt, N174KS collided with a treeline on final approach to the airport. The instructor reported that the flight was normal until the student encountered a downdraft on final approach. The instructor took control of the controls, but was…Apr 17, 1987 · N174KS · Substantial damageNTSB MIA87IA134Incident · No injuriesIncident investigationFinal reportPiper PA-28RT-201 · Grant, FLThe CFI closed the throttle & announced a simulated forced ldg. Moments later, he advanced the throttle to clear the engine & found it would not respond. A forced ldg was then performed in a field without further incident. A subsequent exam of the engine,…Apr 16, 1987 · N539FT · Minor damageNTSB LAX87LA179Accident · Minor injuriesLimited investigationFinal reportBell 206B-II · Yucaipa, CAA Bell 206B went out of control and crashed while lndg at a 5,720 ft high helipad. The plt indicated that he terminated the aprch at a 8-10 ft hover and began to spin to the right with full left pedal applied. After 1 1/2 to 2 turns the plt atmptd to fly out…Apr 16, 1987 · N76EF · DestroyedNTSB FTW87LA095Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Midland, TXOn April 15, 1987, at approximatly 1910 CDT, the private pilot of a Cessna 182Q attempted to land on a 2650 ft dirt runway near Midland, TX. Witness stated she landed long and fast. The brakes failed due to a pre-existing crack in the left brake line. The…Apr 16, 1987 · N95610 · Substantial damageNTSB FTW87DRD04Accident · No injuriesFinal reportGrumman G-164 · Rayne, LAThe aircraft's engine lost power and stopped while maneuvering. The aircraft impacted a dirt bank and nosed over in soft dirt/mud during the forced landing. Water was found in the fuel system and water was also found in the fuel tank of another aircraft…Apr 16, 1987 · N10259 · Substantial damageNTSB DEN87LA101Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Argusville, NDThe plt took off with a load of 46-0-0 fertilizer and proceeded to the field to be treated. The plt said when he arrived his flagger was not in position so he initiated a goaround. When the plt had turned 90 deg onto the x-wind leg the acft stalled. The plt…Apr 16, 1987 · N63915 · Substantial damageNTSB CHI87FA114Accident · 1 fatalField investigationFinal reportCessna 182G · West Point, INDrg an IFR arrival, the plt was clrd for an ILS rwy 10 apch. No radar facilities were available, but at 1026 EST, he rprtd he was established on the localizer. Aprx 4 min later, he declared a missed apch & was cleared back to the outer marker (om), then was…Apr 16, 1987 · N2382R · DestroyedNTSB SEA87LA081Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Alderwood, WAThe student pilot took off and landed with a 15 knot tailwind. During his second attempt to land an overun occurred. The aircraft departed the runway to the left onto soft ground where it nosed over inverted. This was the student pilots second solo flight.…Apr 15, 1987 · N5437Q · Substantial damageNTSB NYC87LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · Manchester, NHThe Cessna 152 was making a touch and go on rwy 35 with the winds reported to be 170 degrees at 11 knots. The pilot lost control after touchdown and veered off the runway to the left. The aircraft struck a runway light and flipped over receiving substantial…Apr 15, 1987 · N24784 · Substantial damageNTSB NYC87FA124Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · New Milford, CTAfter taking off on runway 16 at the candlelight farms airport, the flight remained low over the runway while gaining airspeed. As the aircraft approached the upwind end of the runway, witnesses observed it enter a steep climb that continued to an estimated…Apr 15, 1987 · N377SW · DestroyedNTSB LAX87LA178Accident · 1 fatalLimited investigationFinal reportBell 206B · Laupahoehoe, HIThe pilot of the Bell 206B and his three passengers arrived over a beached barge that they were to land on. The pilot hovered over the barge in a left quartering tailwind of about 10 knots and over a moderate sea with waves breaking against the barge. The two…Apr 15, 1987 · N370AH · DestroyedNTSB FTW87FA096Accident · 2 fatalField investigationFinal reportBell 222 · Ben Wheeler, TXAll six lower studs on drive hub assembly failed due to fatique. This disconnected all cyclic and collective controls. Tail boom then separated due to severe vibrations. Helicopter then collided with ground and was destroyed by post crash fire. The plts flt…Apr 15, 1987 · N1074T · DestroyedNTSB DEN87LA099Accident · No injuriesLimited investigationFinal reportMaule M-5-180 · Erie, COThe private plt had completed a landing from a business flt. On landing roll a strong wind gust from the left caused the aircraft to turn left. The plt added full pwr and the acft departed the rwy to the left. The acft was turned back to the right and crossed…Apr 15, 1987 · N84KG · Substantial damageNTSB DEN87LA098Accident · No injuriesLimited investigationFinal reportCessna 152 · Albuquerque, NMThe student plt was practicing unsupervised solo flt in gusty cross winds. He became distracted on takeoff and failed to correct for a left drift. At this point he had taken out all aileron correction and when the left wing came up, he also added left rudder.…Apr 15, 1987 · N5280Q · Substantial damageNTSB DEN87LA097Accident · Minor injuriesLimited investigationFinal reportMclachlan Moni · Tooele, UTThe private plt was cruising the local area near his home in his homebuilt experimental moni. The newly installed engine began to run rough. This engine is not a traditional acft engine and was a two cycle, two cylinder engine manufactured in italy, with an…Apr 15, 1987 · N96606 · Substantial damageNTSB LAX87LA177Accident · No injuriesLimited investigationFinal reportCessna T303 · Santa Maria, CAA Cessna T303 collided w the LOC antenna aft a total loss of pwr in both engs while on final app to rwy 30. The plt indicated that the engs failed due to fuel exhaustion. The flt made 5 stops to pick-up and drop off cargo and is normally flown daily by…Apr 14, 1987 · N2225C · Substantial damageNTSB DEN87LA096Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Glenrock, WYThe private plt planned a takeoff from the unimproved ranch rwy for a local flt. Elevator trim was not set for takeoff according to the plt. When the tailwheel came up during the takeoff roll, the acft swerved left, and the plt attempted to correct with…Apr 14, 1987 · N1851P · Substantial damageNTSB DCA87MA026Accident · 4 fatalMajor investigationFinal reportBoeing 707-351C · Kansas City, MODrg arr, buffalo airways flt 721 was vectored for an ILS rwy 1 apch. Except for deviations to avoid tstms, dscnt to the terminal area was routine. At 2151:01, the flt was adzd it was 5 mi fm the outer marker (om), was given a final vector to intercept the ILS…Apr 14, 1987 · N144SP · DestroyedNTSB SEA87LA078Accident · No injuriesLimited investigationFinal reportCessna 185 · Burnett Inlet, AKThe plt left the landing gear in the down position after takeoff. During the water landing, with the gear in the down position, the acft nosed over.Apr 13, 1987 · N1774R · Substantial damageNTSB LAX87LA175Accident · No injuriesLimited investigationFinal reportBeech C35 · Vacaville, CAThe plt stated he had flown the acft the day prior to the accident on the left fuel tank only. No fuel had been added on the day of the accident and the plt stated that the left tank was three quarters full and the right tank was full. The plt positioned the…Apr 13, 1987 · N271F · Substantial damageNTSB CHI87LA113Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Marine City, MIDuring a solo training flight, the student pilot landed too fast. The aircraft porpoised, the nose wheel collapsed and the plane nosed over.Apr 13, 1987 · N4857B · Substantial damageNTSB NYC87LA122Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Pottstown, PADuring landing approach to runway 28, ground fog was encountered and the pilot overshot his intended touchdown point. The pilot stated that he slowed the airspeed to zero mph and the acft started to shake and fall even though the motor and rotor were at 100%…Apr 12, 1987 · N85570 · Substantial damageNTSB NYC87FA121Accident · Minor injuriesField investigationFinal reportCessna 402C · Hyannis, MAShortly after the initial pwr reduction drg tkof, the plt noted a partial loss of pwr in the rgt eng. He said he 'went to full power on both engines' & noted an 'extremely high' fuel flow indcn to the rgt eng. He said, 'thinking that the engine was flooding,…Apr 12, 1987 · N87PB · DestroyedNTSB MKC87FA078Accident · 2 fatalField investigationFinal reportLake LA-4-200 · Nixa, MOThe normal procedure for operating at this airstrip was to always take off to the east and land to the west when winds were not excessive. Winds elsewhere in area were from southeast at 13 knots while at this strip, they were from the east at 30 knots. After…Apr 12, 1987 · N2847P · DestroyedNTSB MKC87FA077Accident · 1 fatalField investigationFinal reportCessna 150-H · Council Bluffs, IAAcquaintances stated that the student pilot was very motivated in the pursuit of his private pilot certificate and that, on the day of the accident, he was looking forward to this first solo flight. According to his instructor-pilot, who also witnessed the…Apr 12, 1987 · N50223 · DestroyedNTSB MIA87LA133Accident · Minor injuriesLimited investigationFinal reportBell 206L · Miami, FLUnlicensed pilot lost control of helicopter while in hover while attempting to steal the helicopter. The aircraft crashed to earth and rolled over. The pilot was on probation for attempting to steal a helicopter on a previous occasion. The plt received minor…Apr 12, 1987 · N16780 · Substantial damage