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 CHI88DEX01Accident · 1 fatalFinal reportPiper PA-24-250 · Salem, INN6478P crashed during a forced landing near the Salem, IN, airport. The aircraft had experienced an engine failure due to failure of the number 5 connecting rod cap bolt. The aircraft struck a tree during the approach and crashed 100 yards north of the runway.Jan 5, 1988 · N6487P · DestroyedNTSB CHI88DET01Accident · Minor injuriesFinal reportPiper PA-28-181 · Fort Wayne, INPilot on night cross country flight with clear, very cold weather, experienced total loss of engine power while cruising at 7500 feet MSL. Approach control gave position of closest field, but pilot elected to continue to destination which was five miles…Jan 5, 1988 · N3003M · Substantial damageNTSB FTW88FA044Accident · 1 fatalField investigationFinal reportCessna 414A · Midland, TXThe aircraft collided with power lines and the ground shortly after takeoff during instrument conditions. The only evidence of a malfunction or failure which was found was the gyro for the pilot's attitude indicator which had no indication of rotation at…Jan 4, 1988 · N6576C · DestroyedNTSB ANC88LA023Accident · No injuriesLimited investigationFinal reportCessna 207 · Akiachak, AKThe pilot stated that during the landing roll on the ice covered runway, he lost control causing the plane to exit the departure end of the runway into a snow bank.Jan 4, 1988 · N73036 · Substantial damageNTSB MIA88LA082Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Tampa, FLAfter preflighting the acft, 30.8 gal of fuel were added. No further insp was performed. The flt took off after an eng runup was accomplished. No problems were noted. During the initial climb of the first touch-and-go landing, at an alt of aprx 75 ft, the eng…Jan 3, 1988 · N40AZ · Substantial damageNTSB LAX88LA080Accident · No injuriesLimited investigationFinal reportBell 47D1 · Fontana, CANone submittedJan 3, 1988 · N175K · Substantial damageNTSB CHI88LA043Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Stanley, WIJan 3, 1988 · N863A · Substantial damageNTSB ATL88FA073Accident · Serious injuriesField investigationFinal reportCessna P210N · Huntsville, ALJan 3, 1988 · N6438W · DestroyedNTSB MIA88LA080Accident · Minor injuriesLimited investigationFinal reportBellanca 14-13 · Merritt Island, FLThe private pilot experienced a power loss after takeoff. He then collided with water after hitting a mast of a boat and a dock. The plt stated that he experienced carburetor ice prior to the eng quitting. The plt stated that on an earlier flt he had problems…Jan 2, 1988 · N8429H · Substantial damageNTSB MIA88FA081Accident · 1 fatalField investigationFinal reportCessna 152 · Parkland, FLAcft was seen descending in a near vertical dive at a high rate of speed with no rotation along the roll axis. The acft crashed nose first into a newly planted corn field. Post crash examination of the acft structure, flight controls, and engine revealed no…Jan 2, 1988 · N24480 · DestroyedNTSB FTW88LA045Accident · Minor injuriesLimited investigationFinal reportAero Commander 100-180 · Mineola Quitman, TXDuring a practice touch and go landing, the engine back fired and then surged. At about 150' AGL the engine RPM dropped about 80% and the pilot attempted to make an emergency landing in an open field. The aircraft flew over a trash dump and between two trees.…Jan 2, 1988 · N3709X · Substantial damageNTSB DEN88LA046Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Vernal, UTThe commercial plt and two passengers were surveying a road route in mountainous terrain. At cruise, the pilot noticed a drop in manifold pressure, followed by a loss of oil pressure. The plt reported that the engine quit. An autorotation to a snow covered…Jan 2, 1988 · N400AH · Substantial damageNTSB ATL88LA071Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Springfield, KYOne witness stated that the eng misfired during the takeoff roll, others stated that the acft was about 75 ft high when it lost power. There were several interruptions of power before it quit totally. The pilot attempted to return to the departure airfield.…Jan 2, 1988 · N2906X · Substantial damageNTSB ATL88FA072Accident · 2 fatalField investigationFinal reportNorth American T-28C · Woodstock, GAA plt/witness rptd that the airplane first flew over the arpt to the North at about 500 ft AGL, and subsequently performed a wingover at the North end of the arpt. The airplane then made a high-speed pass over the rwy to the south, at about 50 ft AGL. Upon…Jan 2, 1988 · N9719G · DestroyedNTSB ATL88FA070Accident · 2 fatalField investigationFinal reportCessna 152 · Ravenna, OHJan 2, 1988 · N5364M · Substantial damageNTSB MKC88LA036Accident · No injuriesLimited investigationFinal reportCessna 414 · Fayetteville, ARDuring an instructional flt, the CFI and student plt heard a loud pop while attempting to lower the gear in preparation for landing. Several flybys past the control tower were made to confirm an unsafe nose gear configuration. They flew the aircraft an…Jan 1, 1988 · N30ML · Substantial damageNTSB MKC88DCQ01Accident · 1 fatalFinal reportFlagg Star Lite · Ft. Scott, KSThe failure of the main spars at the attachment points inside the fuselage.Jan 1, 1988 · N87LF · DestroyedNTSB LAX88LA079Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Phoenix, AZJan 1, 1988 · N74169 · Substantial damageNTSB NYC88LA061Accident · No injuriesLimited investigationFinal reportCessna 172 · Concord, NHThe aircraft was landing at Concord municipal airport, and during landing roll, the aircraft veered to the left leaving the runway surface and nosed over in the field between the taxiway and runway 35.Dec 31, 1987 · N5383R · Substantial damageNTSB NYC88FA062Accident · 4 fatalField investigationFinal reportPiper PA-32RT-300 · Burlington, VTDrg flt fm wilmington, de to rutland, VT, the plt diverted to binghamton after recg the albany wx & learning rutland wx was not available. After lndg, he told fss psnl he phoned rutland & was told the wx was good. He got 2 wx briefings bfr contg the flt & was…Dec 31, 1987 · N2243J · DestroyedNTSB MKC88LA035Accident · No injuriesLimited investigationFinal reportCessna 182Q · Davenport, IAThe PIC had chosen rwy 15 for the LOC app and was cleared by approach control. The PIC stated that he cancelled his IFR flt plan entering clear conditions at 3,000 ft. the PIC further stated that he planned an approach using a ltl higher spd for the gusty…Dec 31, 1987 · N96934 · Substantial damageNTSB LAX88LA078Accident · No injuriesLimited investigationFinal reportCessna 150K · San Andreas, CADec 31, 1987 · N6422G · Substantial damageNTSB CHI88LA038Accident · No injuriesLimited investigationFinal reportCessna 210-5 · East Lansing, MIThe aircraft was landed at night on runway 9 which is 2530' in length with a 600' displaced threshold. This runway was ice covered and winds were recorded 25 minutes before the accident at a reporting facility 5 nautical miles west of the accident site as 160…Dec 31, 1987 · N1802Z · Substantial damageNTSB SEA88FA034Accident · 3 fatalField investigationFinal reportCessna 182J · Molalla, ORThe recently certificated, non-instrument rated, pvt plt flew into the an area of low ceilings, low vis, rain & snw w/o filing a flt plan. No record of a wx briefing was fnd. A surviving pax rprtd that drg flt, the plt flew into clds that were initially…Dec 30, 1987 · N2758F · DestroyedNTSB DEN88LA045Accident · No injuriesLimited investigationFinal reportRaven Rally RX7 · Dona Ana, NMThe commerical plt was conducting a sightseeing flight in his balloon. After a one and one half hour flight, he landed beside a paved road. The envelope collapsed over a power line. The ground crewman somehow contacted the balloon and was electrically…Dec 30, 1987 · N40364 · Substantial damageNTSB DEN88FA044Accident · Serious injuriesField investigationFinal reportSwearingen SA-26AT · Telluride, CODuring a visual apch, the plt said he encountered 2000 fpm downdrafts. The plt stated he added power and executed a normal apch at 120 KTS, compensating for downdrafts/crosswinds. After touchdown, the plt said he did not get a beta light on the right eng. He…Dec 30, 1987 · N4468M · Substantial damageNTSB SEA88LA033Accident · 1 fatalLimited investigationFinal reportCessna 182C · Las Vegas, NVThe aircraft bounced on landing touchdown, swerved off the side of the runway and impacted a concrete culvert in a drainage ditch. Witnesses observed the acft bounce and stated that no application of power for recovery was heard nor any apparent attempt to…Dec 29, 1987 · N8819T · DestroyedNTSB MIA88IA079Incident · No injuriesIncident investigationFinal reportCessna U206G · Key West, FLWhile water taxiing nw from the ramp to takeoff with the wind from the north at 22 KTS, the rt wing lifted resulting in the lt float digging into the water. The plt attempted to correct this by turning into the wind and applying full-up right aileron but was…Dec 29, 1987 · N4820R · Minor damageNTSB LAX88LA081Accident · No injuriesLimited investigationFinal reportCessna 172M · Banning, CADuring a pleasure flight while on final approach, aprx 10 ft above the rwy, the acft suddenly dropped and bounced on the rwy. After a nearby rain storm passed over the area, the acft was flown to the home base. Several days later, the operator discovered…Dec 29, 1987 · N12943 · Substantial damageNTSB FTW88LA043Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Woodworth, LAThe plt stated that during landing roll the aircraft veered left due to a strong wind gust. The aircraft fell into a ravine, coming to rest 180 degrees from the runway heading, damaging both wing spars at the fuselage attach points and collapsing the nose…Dec 29, 1987 · N5719G · Substantial damageNTSB FTW88LA042Accident · No injuriesLimited investigationFinal reportCessna 182 · Fargo, OKDuring takeoff roll, the engine RPM dropped to 2600 and started running rough. Shortly after takeoff, the pilot elected to make a precautionary landing. During landing roll the aircraft's left wing hit a tree causing substantial damage to the aircraft. Prior…Dec 29, 1987 · N94546 · Substantial damageNTSB MIA88NA070Accident · Minor injuriesFinal reportMcDonnell Douglas DC-9-31 · Pensacola, FLDec 28, 1987 · N8948E · Substantial damageNTSB MIA88LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Tallahassee, FLEn route to the destination during a cross country flt, the acft was diverted to an alternate arpt due to weather conditions below minimums. Unable to land at the alternate due to poor visibility the non-instrument rated plt requested vectors to the…Dec 28, 1987 · N89126 · Substantial damageNTSB LAX88LA070Accident · No injuriesLimited investigationFinal reportCessna 172 · Goodyear, AZDuring a cross country flt while cruising at 7500 ft MSL, the acft began to vibrate severely. The plt shut the engine down and landed without further incident. Inspection of the acft revealed that a section of one of the propeller blades had separated. The…Dec 28, 1987 · N4297F · Substantial damageNTSB MIA88IA072Incident · No injuriesIncident investigationFinal reportBoeing 727-231 · Miami, FLPlt was instructed to turn the tail to the right as viewed by the signal man during power back. As power back started the tail was turned to the left as viewed by the signal man. The signal man corrected this turn but the acft was now making a much larger arc…Dec 27, 1987 · N54344 · Minor damageNTSB LAX88DUQ03Accident · Serious injuriesFinal reportRolladen-Schneider LS-3 · Santa Ynez, CADuring a pleasure flight, the left wing of the glider struck a tree and collided with the terrain during a left turn in sinking air. The plt stated that he was looking over his right shoulder at nearby traffic then turned to look forward into the hazy setting…Dec 27, 1987 · N75FE · DestroyedNTSB FTW88DPA02Accident · No injuriesFinal reportCessna 150M · Gainesville, TXThe pilot lost engine power due to a throttle cable which failed during flight. He then made a 360 degree turn to lose altitude before initiating an emergency landing on an airport. He lost excessive altitude during the turn which resulted in an off-airport…Dec 27, 1987 · N63385 · Substantial damageNTSB DEN88IA043Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-80 · Denver, CODuring landing roll the acft struck a taxiway marker. Visibility was reported by RVR to be 2200. Actual visibility was near zero due to blowing snow. Plt stated he did not lose cntrl but finite cntrl not possible due to lack of visibility and cross winds of…Dec 27, 1987 · N72830 · Minor damageNTSB DCA88RA019Accident · 1 fatalForeign investigationCessna 402 · St. Barthelemy, WNDec 27, 1987 · N8209QNTSB MKC88LA034Accident · No injuriesLimited investigationFinal reportLuscombe 8-A · Chillicothe, MODuring a ldg attempt, acft touched down and swerved abruptly. Loss of control was experienced by PIC, and acft made a 180 degree turn on the runway. PIC stated the brakes may have been frozen, as he had taxied thru standing water during departure.Dec 26, 1987 · N71288 · Substantial damageNTSB MKC88LA033Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Hays, KSDuring a personal cross country IFR flt, PIC encountered forecast icing conditions. He then made a 180 degree turn to an alternate airfield. He said the acft accumulated substantial icing on propeller, wings and windshield. He said full pwr was necessary to…Dec 26, 1987 · N83BC · Substantial damageNTSB MIA88LA076Accident · Minor injuriesLimited investigationFinal reportCrusenberry Windwagon · Lantana, FLWhile on a high speed taxi test the acft inadvertently became airborne. While looking out the rt side of the acft the plt rolled it into a rt bank. He then leveled the wings after which the acft stalled, touched down and separated the main landing gear wheels…Dec 26, 1987 · N5223C · Substantial damageNTSB MIA88LA075Accident · No injuriesLimited investigationFinal reportBoeing 727-200 · San Juan, PRN705AA was number two in position for takeoff behind N893AA. N705AA received takeoff clearance first and as it began to taxi to the runway it's left wing tip struck and passed under the right wing tip of N893AA.Dec 26, 1987 · N705AA · 2 aircraft · Substantial damageNTSB DEN88LA041Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-125 · Riverton, WYThe instructor plt and student were practicing forced landings to an open field. The instructor stated that he descended to approx 50 to 75 ft AGL over the intended landing area. He initiated a go around, pulled up and banked left to go over powerlines. At an…Dec 26, 1987 · N211T · Substantial damageNTSB CHI88LA036Accident · No injuriesLimited investigationFinal reportCessna 150M · Redwood Falls, MNWind was 210 degrees at 13 knots when the student pilot attempted a landing on snow compacted runway 12. The student stated that a gust of wind pushed the aircraft sideways and it struck a snowbank when it exited the runway to the left.Dec 26, 1987 · N704XX · Substantial damageNTSB ATL88FA069Accident · Serious injuriesField investigationFinal reportCessna 172M · Warner-Robins, GAThe non-ifr rated plt dptd in VFR wx. He subsequently encountered IFR wx several hrs after departure and attempted to continue on to his destination arpt in IFR conditions. He made several VOR approaches to the destination arpt. But was unable to visually…Dec 26, 1987 · N13609 · Substantial damageNTSB NYC88LA060Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Flushing, NYAs the plts were taxiing at dusk to takeoff, the acft was struck by a food svc van at a vehicle svc road. The acdnt occurred as rain was falling & the ramp area was wet with standing water. The van driver said he had just maneuvered his vehicle to the left to…Dec 25, 1987 · N58MH · Substantial damageNTSB CHI88LA037Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Mt. Pleasant, WIThe stu plt climbed to 1600 ft MSL aft tkof. Shortly aft level off, the engine stopped. He attempted an air start without success. During the forced lndg the nose wheel dug in and the acft nosed over in the soft soil. During a post crash interview, the stu…Dec 25, 1987 · N6468S · Substantial damageNTSB BFO88FA011Accident · 1 fatalField investigationFinal reportChampion 7ECA · Keymar, MDWitnesses heard and observed the aircraft takeoff, bank to the left, and nose down into the adjoining dirt field with no change in engine sound. Exam of the wreckage revealed that an elevator cable had separated at a point where grounding strap was found to…Dec 25, 1987 · N11089 · DestroyedNTSB ATL88FA068Accident · 4 fatalField investigationFinal reportPiper PA-28RT-201 · Rutherfordton, NCThe pilot was cleared for the adf approach. The aircraft was last observed on radar about one mile inside the rbn. The aircraft was located on December 27 about 4 NM NE of the airport. The aircraft impacted the trees at about the 2270-foot level of carson Mt.…Dec 25, 1987 · N2869C · Destroyed