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 NYC88FA229Accident · 4 fatalField investigationFinal reportPiper PA-28R-201 · Pomfret, CTThe Piper arrow PA-28R-201, had asked ATC for vectors to windam airport. After being vectored the pilot requested his distance from the airport. He was told that he was 12 miles from the airport, the pilot then decided to descend. ATC advised the pilot to…Aug 28, 1988 · N3478M · DestroyedNTSB MKC88FA164Accident · Serious injuriesField investigationFinal reportPiper J3 · York, NEVisual outlook not maintained by pilot in command.Aug 28, 1988 · N3J · Substantial damageNTSB MKC88DCA03Accident · Serious injuriesFinal reportLuscombe 8A · Painton, MOPilot did not maintian the proper decent rate on the final approach to the airport.Aug 28, 1988 · N1404K · DestroyedNTSB LAX88LA329Accident · No injuriesLimited investigationFinal reportCessna 172N · Camarillo, CAWhile taxiing for takeoff, the pilot maneuvered off the taxiway centerline to allow an oncoming Cessna 182 to pass. The Cessna 172 then collided with an airport t-hangar located near the taxiway.Aug 28, 1988 · N789CE · Substantial damageNTSB LAX88LA300Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Lower Lake, CAThe pilot departed NOVAT0, CA with the fuel selector in the right tip tank position. She did not switch the selector to the main tank position. Four miles from Lower Lake, CA the engine lost all power. After the accident, only the right tip tank was found…Aug 28, 1988 · N9429W · Substantial damageNTSB CHI88LA224Accident · Serious injuriesLimited investigationFinal reportCessna 182RG · Dodgeville, WIWhile attempting to land on a runway with wind gusts and a quartering tailwind, the pilot failed to adequately judge and compensate for the wind conditions. The aircraft landed long, and the pilot was unable to bring the aircraft to a stop before the end of…Aug 28, 1988 · N728JS · Substantial damageNTSB CHI88DEC07Accident · No injuriesFinal reportCessna 305A · Gregory, MIFailure (at first partial, then total) of the aircraft's powerplant at an altitude of about 100 feet above the ground during the initial climbout with a glider in tow; a forced landing ensued, during which the aircraft struck a fence, a small tree, and…Aug 28, 1988 · N5166G · Substantial damageNTSB BFO88LA078Accident · No injuriesLimited investigationFinal reportCessna 152 · Easton, MDThe student pilot reported that he allowed the airspeed to deteriorate on final apch. The acft touched down nosewheel first and began to porpoise on the runway. The acft porpoised 3 or 4 times before the propeller and right wing contacted the runway.Aug 28, 1988 · N49572 · Substantial damageNTSB BFO88LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Oakland, MDAccording to the pilot the landing approach for runway 22 was made over power lines. He stated that during the approach the stall warning horn activated and he increased power to maintain 60 mph with 20 degs of flaps. Once estimating that his intended point…Aug 28, 1988 · N4156F · Substantial damageNTSB ATL88LA240Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1A · Fairhope, ALThe plt rprtd the eng lost pwr 'without warning' as he & his pax were flying over water near the shore at aprx 500'. He performed emerg procedures & regained partial pwr, but not enough to cont flt. He maneuvered toward the shore, then elected to ditch the…Aug 28, 1988 · N9392L · Substantial damageNTSB ANC88LA119Accident · No injuriesLimited investigationFinal reportCessna 185F · Joseph Village, AKThe pilot-in-command stated the airplane struck a depression in the runway upon landing at Joseph, Alaska. Examination of the left main gear showed that a bracket, part number 0713495-61 failed due to overload, and allowed the landing gear to separate from…Aug 28, 1988 · N4838C · Substantial damageNTSB SEA88LA164Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Nehalem, ORAfter executing one go-around due to overshoot, plt landed long on second approach. Plt attempted to brake to stop, then rejected landing, applied power and became airborne prematurely. Loss of control and collision with terrain followed.Aug 27, 1988 · N5813X · Substantial damageNTSB NYC88LA230Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Manville, NJAfter completing six landings with an instructor the student plt was released by the instructor for his first solo flt to be conducted as a series of closed pattern touch-and-go landings. On his first solo landing the student plt landed nose wheel first with…Aug 27, 1988 · N2445N · DestroyedNTSB NYC88DFJ03Accident · Serious injuriesFinal reportGarlick/Guppy SNS-2 · Honeoye Falls, NYThe homebuilt airplane was being operated on the first test flight after its completion. During takeoff, the airplane climbed about 100 ft AGL, then crashed in an open field adjacent to the airport. No preimpact part failure/malfunction of the airplane was…Aug 27, 1988 · N222AG · Substantial damageNTSB LAX88LA299Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Chino, CAWhile on final approach, the instructor noticed the airspeed fall below 55 knots. He took control of the airplane from the student. The instructor pushed forward on the yoke and added full power to regain airspeed. He lost control of the airplane and it…Aug 27, 1988 · N67649 · Substantial damageNTSB LAX88LA298Accident · No injuriesLimited investigationFinal reportStinson L-5 · Chino, CADuring the initial climb, the pilot reported that the engine lost power. The pilot initiated a forced landing and during the descent, the airplane collided with a fence coming to rest inverted. Fuel was observed to be leaking from the left wing. When the fuel…Aug 27, 1988 · N723E · Substantial damageNTSB FTW88LA156Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Katy, TXFuel exhaustion induced power loss, which necessitated the forced landing. Contributing to this accident was the pilot's decision to attempt to continue the flight without being able to refuel, and becoming lost during that effort.Aug 27, 1988 · N7746U · Substantial damageNTSB FTW88LA154Accident · No injuriesLimited investigationFinal reportAlon A2 · Guthrie, OKThe private pilot was trying to sell his airplane and allowed the student pilot to fly it from the left seat. The student pilot landed on the runway but lost control, departed the side of the runway, then hit a VASI light. The airplane stopped when it hit a…Aug 27, 1988 · N6588Q · Substantial damageNTSB DEN88LA201Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Fort Morgan, COThe plt reported that at the time of takeoff, the winds were 'light to moderate from 015 deg at 5 KTS or less.' Shortly after takeoff, the winds increased to 10-15 KTS and the plt decided to land on 'grassy, relatively smooth terrain.' The plt said he…Aug 27, 1988 · N779TV · No damageNTSB DEN88FA193Accident · 2 fatalField investigationFinal reportMooney M20F · Jackson Hole, WYThe pvt plt obtained his instrument rating 14 days prior to the accident. 12 hrs of actual instrument flt time was logged in March of 1987. The remaining instrument flt time was simulated. Visibility in the Jackson Hole area was reduced by smoke. The plt…Aug 27, 1988 · N9528M · DestroyedNTSB CHI88LA225Accident · Minor injuriesLimited investigationFinal reportBeech B-95 · Alma, MIDuring approach to landing the pilot entered a steep (45 degree bank) left turn from base to final. The pilot stated that he did not realize it at the time, but this action unported the fuel line to the left engine, causing the engine to fail due to fuel…Aug 27, 1988 · N9673R · Substantial damageNTSB CHI88LA222Accident · Serious injuriesLimited investigationFinal reportPiper J-3 · Youngstown, OHThe aircraft experienced a total loss of engine power due to fuel exhaustion while on final approach to the runway. The aircraft sustained substantial damage, and the pilot was seriously injured when the aircraft impacted the ground approximately 25' short of…Aug 27, 1988 · N38346 · Substantial damageNTSB CHI88LA221Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Burnsville, MNDuring a local pleasure/aerial photography flight, the pilot failed to handle the aircraft properly. Subsequently the pilot was unable to maintain sufficient airspeed and/or altitude to remain clear of obstacles. The aircraft was configured for slow flight as…Aug 27, 1988 · N5561G · Substantial damageNTSB CHI88LA220Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Gary, INFailure of the powerplant due to an oil leak and subsequent forced landing into unsuitable terrain.Aug 27, 1988 · N5140S · DestroyedNTSB CHI88FA223Accident · Minor injuriesField investigationFinal reportBoeing 727-31 · Chicago, ILImproper procedural checklist in which a critical step was not listed.Aug 27, 1988 · N852TW · Substantial damageNTSB BFO88LA079Accident · No injuriesLimited investigationFinal reportCessna 180 · Harding, WVThe pilot departed morgantown, WV, en route to a private airstrip, durrett air ranch, near Harding, WV to attend a Cessna 180 fly-in. He stated he circled the airstrip to determine the wind and rwy conditions. He also called UNICOM for active rwy info but did…Aug 27, 1988 · N2922A · Substantial damageNTSB BFO88LA076Accident · No injuriesLimited investigationFinal reportRobinson R22A · Gaithersburg, MDThe flt was initiated with the student plt bringing the helicopter up to a hover with some forward speed. The student rapidly and forcefully applied aft cyclic. The CFI was unable to compensate in time, even though he was on the controls with the student. The…Aug 27, 1988 · N8559A · Substantial damageNTSB ATL88FA239Accident · Serious injuriesField investigationFinal reportBoeing 767 · Charleston, SCAug 27, 1988 · N120DL · No damageNTSB MKC88LA163Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Freeburg, MOWhile attempting to land on a farm pasture that the plt had previously walked over to check, the aircraft nose wheel collapsed, followed by a nose over. The aircraft landed nose low with no flaps and dug into the grass runway.Aug 26, 1988 · N3171Z · Substantial damageNTSB LAX88LA303Accident · Minor injuriesLimited investigationFinal reportFairchild SA-227-AC · Sacramento, CAMechanics failure to properly secure the right engine cowling after maintenance.Aug 26, 1988 · N2683B · Substantial damageNTSB FTW88LA155Accident · No injuriesLimited investigationFinal reportHelio H-250 · Tyler, TXDuring flight, the engine stopped developing power. The fuel was feeding from the main tanks and the pilot attempted to transfer some fuel from the auxiliary tanks to the mains but was not able to get a restart. During the forced landing, the airplane…Aug 26, 1988 · N444FF · DestroyedNTSB DEN88LA194Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Lakeside, MTThe plt and his pax departed bzn at 1500 MDT and flew to Hughes bay on flathead Lake, near Lakeside, MT, arriving at aprx 1700. The plt said he noticed a diminishing wave pattern from the southwest and a strong gust surface pattern from the east. There were…Aug 26, 1988 · N1299L · Substantial damageNTSB ATL88DKG14Accident · Minor injuriesFinal reportAyres Thrush S2R · Ochlocknee, GAShortly after takeoff the pilot allowed the nose to drop resulting in a collision with the ground. The airplane hit the ground, right wing first, and traveled about 500 feet before stopping. The pilot had been spraying methyl parathion all day and stated he…Aug 26, 1988 · N4006P · Substantial damageNTSB SEA88LA163Accident · No injuriesLimited investigationFinal reportCessna 152 · Cascade Locks, ORThe student pilot reported that during cruise while on a solo cross country training flight the engine began to surge. He called ATC and was directed to the nearest available airport. The student pilot landed long and fast and departed theend of the runway.…Aug 25, 1988 · N94649 · Substantial damageNTSB MIA88FA261Accident · 3 fatalField investigationFinal reportPiper PA-60 · Pembroke Pines, FLWitnesses stated that the acft used almost the entire length of the runway during the ground run. After rotation & gear retraction, it continued to climb in a nose high attitude to aprx 100-150 feet, then it started an aprx 20 degree bank to the right until…Aug 25, 1988 · N6069W · DestroyedNTSB LAX88LA296Accident · No injuriesLimited investigationFinal reportCessna 402C · Prescott, AZWhile taxiing, in order to clear a parked airplane to the right, the pilot maneuvered the airplane left of the centerline. The left main landing gear traveled off the asphalt. The airplane pivoted 90 degrees from the direction of travel collapsing the landing…Aug 25, 1988 · N5715C · Substantial damageNTSB FTW88LA152Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Sallisaw, OKAcft experienced a hard landing and rolled over following a loss of control in a hover. Plt delayed cutting the throttle in order to clear a ditch. Investigation revealed that the tail rotor driveshaft coupling retaining screw had separated. The separation…Aug 25, 1988 · N2264U · Substantial damageNTSB FTW88DPA06Accident · No injuriesFinal reportCessna 150K · Whitney, TXThe student pilot decided to make a touch and go landing before flying to another airport. The airplane touched down more than 1000 feet down the 2000 foot runway, went off the end and 300 feet beyond the end before hitting a dirt bank and nosing over to the…Aug 25, 1988 · N2550Q · Substantial damageNTSB DEN88LA189Accident · Minor injuriesLimited investigationFinal reportCessna 195 · Rawlins, WYAug 25, 1988 · N3455V · Substantial damageNTSB BFO88LA075Accident · No injuriesLimited investigationFinal reportCessna 172N · Port Royal, VAThe pilot departed fredericksburg, VA, for a power line patrol flight in Port Royal, VA. After intersecting the power lines at the substation, the patrol was initiated flying 10 ft above and 20 ft to the left of the lines. The plt stated he was looking…Aug 25, 1988 · N213JA · Substantial damageNTSB BFO88DID04Accident · 1 fatalFinal reportPiper PA-25-250 · Waverly, VAThe acft contacted pwr lines, crashed and burned during an aerial appliation flt. Witnesses reported that it looked as if the plt descended to fly under the lines when it suddenly pulled up and contacted them.Aug 25, 1988 · N8668L · DestroyedNTSB ATL88LA243Accident · No injuriesLimited investigationFinal reportSchempp-Hirth 2 · Whitwell, TNThe pilot was completing a 130 mile cross country flight. Just prior to touchdown, the left wing collided with a water sprinkler pipe along the edge of the runway. The pilot lost directional control. The grass was taller along the runway edge. The pilot did…Aug 25, 1988 · N795 · Substantial damageNTSB ATL88IA238Incident · No injuriesIncident investigationFinal reportBell 47G · N Myrtle Beach, SCAug 25, 1988 · N902Z · Minor damageNTSB ANC88LA117Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Rainy Pass, AKThe plt attempted to fly thru Rainy Pass, AK, but said he flew up the wrong valley. As he contd, the acft got into a situation where the plt was unable to turn around or outclimb rising terrain. Subsequently, the acft crash landed on the mountain side at an…Aug 25, 1988 · N95165 · Substantial damageNTSB SEA88FA160Accident · 3 fatalField investigationFinal reportAero Commander 100-180 · John Day, ORWhile elk spotting in mountainous terrain, the aircraft collided with trees in a nose low turn similar to the intermediate stages of a stall. A severe post impact fire erupted. The density altitude at the accident site elevation was approximately 10,100 feet.…Aug 24, 1988 · N4175X · DestroyedNTSB NYC88LA228Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Doylestown, PAThe CFI and student plt took off from a 2330 ft turf rwy. Witnesses said the wind was calm and it was hot. The pilots both said that everything seemed normal until the acft reached about 200 ft AGL at which time they lost lift due to either a power loss or…Aug 24, 1988 · N1203K · DestroyedNTSB LAX88FA297Accident · 1 fatalField investigationFinal reportMooney M20J · Inyokern, CAPilots inflight loss of control after encountering a level four thunderstorm on a night VFR cross country. Contributing to the accident was the pilot's failure to obtain a preflight weather briefing.Aug 24, 1988 · N5769Y · DestroyedNTSB FTW88FA151Accident · 2 fatalField investigationFinal reportCessna 152 · Bushland, TXThere were no witnesses to this accident. The airplane impacted the terrain at high speed, in a near wings level, 75 degree nose down attitude. No preimpact problems were found with the airplane or powerplant. Airplane was over weight and had an aft CG at…Aug 24, 1988 · N5351M · DestroyedNTSB FTW88DRD20Accident · 1 fatalFinal reportAlon A2A · New Orleans, LAThe highly modified airplane was observed in a near vertical dive before it impacted into a marsh. No mechanical or medical reasons were found for the crash. Although toxicological analysis indicated a blood alcohol level of .11%, there was evidence of…Aug 24, 1988 · N5626F · DestroyedNTSB DEN88LA176Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Lordsburg, NMFollowing takeoff the acft lost power at 150-200 ft AGL. Plt landed in rough terrain. During landing the left wing and landing gear separated. Examination revealed a failed exhaust valve guide and soft valve springs due to blow-by heat. At the time of the…Aug 24, 1988 · N6189H · Substantial damage