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 CHI84LA203Accident · No injuriesLimited investigationFinal reportHughes 269B · Toulon, ILThe plt landed the helicopter in a grassy area to talk to a friend. During departure, he flew over a corn field, & at that time, an empty paper/plastic corn seed sack was drawn up into the main rotor & a severe vibration began. He then landed in the field &…NTSB CHI84LA200Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1B · Millstadt, ILThe acft was stalled during the landing approach over trees to an 1800 ft strip. After clearing the trees the plt reduced the power to idle while aprx 30 ft AGL. The acft stalled, contacted the soft plowed soil and nosed over about 150 ft short of the rwy.NTSB CHI84LA184Accident · Serious injuriesLimited investigationFinal reportBell 47D1 · Alpena, MIPrior to the accident, the owner/plt of the helicopter reportedly 'buzzed' a local baseball game. Shortly after that, the helicopter was observed to maneuver over a wooded area, enter a nose high attitude, then roll or bank & enter a descent into a wooded…NTSB ATL84LA181Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Jessup, GAThe acft landed off the rwy during a forced landing following a power loss. Wx conditions were conducive to carburetor icing.NTSB ATL84LA179Accident · No injuriesLimited investigationFinal reportCondor III · Kennesaw, GAThe two place ultralight actt crashed 30FT short of the rwy due to fuel exhaustion. The acft had been flying into a headwind of 13 knots at an indicated airspeed of 40 knots. The acft impacted in some underbrush.NTSB ATL84LA178Accident · No injuriesLimited investigationFinal reportCessna 152 · Lacey Springs, ALWhen the plt was arriving at the uncontrolled arpt, no UNICOM was available, since the office was closed. The plt elected to land on rwy 24 after seeing another acft depart. The 1st apch was aborted due to gusty winds. After the 2nd apch, the acft touched…NTSB ATL84LA177Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Tallassee, ALThe plt stated he departed fulton county arpt with aprx 12 gals of fuel on board. About 20 mins later, the left fuel tank ran dry & the plt selected the right tank & continued the flt with the intention of refueling at either tuskegee ortallassee. Upon…NTSB ATL84LA176Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Leeds, ALThe plt made a flt of about 30 min to practice landings, then landed to pick up 2 passengers. About 10 min after taking off on the 2nd flt, he began having symptoms of a medical problem. He said he felt hot & the air felt stagnant & stale. The vents & a…NTSB SEA84FA113Accident · 1 fatalField investigationFinal reportCessna 150F · Gleneden Beach, ORTwo witnesses observed the student plt in the acft at about 1500 PDT. They reported that they were waiting for the wx to clear & that they tried to get the student to spend the night instead of leaving, but they were unsuccessful. Subsequently, the acft…NTSB SEA84FA110Accident · 1 fatalField investigationFinal reportRockwell S-2R · American Falls, IDThe load/ground crew reported that the plt planned to make 1 more spray run before flying back to the home base. When the acft did not return to the loading area, they assumed he had returned to the base. They drove 20 mi back to the base, but found neither…NTSB NYC84FIG02Accident · Serious injuriesFinal reportCessna 172 · Elkton, MDThe acft was flown over the field at low alt in an attempt to pick up an AD banner. The acft had dived in a shallow angle from 300 ft to perform the pick-up. The banner was missed by the plt who climbed away in a steep ascent until he entered a hammerhead…NTSB LAX84LA308Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Kernville, CAAfter takeoff, the plt took a direct route (heading 150 deg) & began climbing to 7500 ft to cross over a 6300 ft pass. He encountered strong winds from the northeast & stated that he 'experienced severe downdrafts caused by mountain waves.' The plt initiated…NTSB LAX84FU028Accident · Serious injuriesFinal reportPioneer FLT Star · Elk Grove, CAThe ultralight was on a solo training flt when the engine stopped as the vehicle passed over the rwy. The student made a shollow bank to the right and descended into an adjacent field where she and the vehicle collided with some bales of hay. The student had…NTSB LAX84FA300Accident · Serious injuriesField investigationFinal reportPiper PA-28-151 · Corona, CAThe acft experienced an eng power failure during takeoff & collided with the ground while maneuvering to return to the airport. The plt stated that he 'turned right trying to return to the runway,' & at the same time, 'maintain 80 (KTS IAS), but it (the acft)…NTSB LAX84FA299Accident · Serious injuriesField investigationFinal reportCessna TR182 · Big Bear City, CAJust after takeoff, shortly after landing gear retraction, the eng backfired and experienced a total power loss. The plt lowered the landing gear and landed straight ahead just off the rwy. The acft bounced once and came to rest in a city park. It immediately…NTSB CHI84LA202Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Ortonville, MIThe acft landed hard short of the rwy, bounced, & both landing gear collapsed.NTSB CHI84LA199Accident · Serious injuriesLimited investigationFinal reportMeyers LIL Toot · White Bear Lake, MNPlt reported power loss while on initial climb. The left wing contacted the ground and the acft cartwheeled. Examinationof aircraft by FAA disclosed no malfunction of aircraft or of powerplant.NTSB ATL84LA180Accident · No injuriesLimited investigationFinal reportCessna 140 · Harrisonburg, VAThe acft's left main landing gear strut failed during a landg. A mechanic, who examined the acft, stated that the strut had a previously existing crack prior to the accident. The strut failed at a hole where the step was attached.NTSB ATL84LA175Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Franklin, NCDuring flt, the eng lost power. The plt chose a small clearing for a forced landing, but just before touching down, the acft contacted an aluminum roofed shed & an electrical wire, then crash landed. An exam of the acft revealed no preimpact mechanical…NTSB SEA85LA116Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Ephrata, WAThe pilot was returning from his third aerial tow. After releasing the tow rope while on the ramp, the plt was making clearing turns to avoid parked acft. The tow plane's parked unoccupied acft. The acft then pivoted into the mid portion of the right wing…NTSB NYC84LA177Accident · Minor injuriesLimited investigationFinal reportCessna 152 · West Milford, NJThe plt stated that during the initial climb of a max performance takeoff the best angle rate of climb could not be maintained. The acft contacted trees and subsequently crashed in an abandoned parking lot.NTSB MKC84LA140Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Dubuque, IAWhile manuevering over a university a ttl loss of pwr was experienced. Attempts to restart the engine failed. The plt made a hard forced landing which resulted in substantial damage. Inspection of the engine did not reveal any mechanical failure/malfunction.NTSB LAX84LA309Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Lakeside, AZThe plt was unable to clear rising terrain after a low pass for a photo. The density alt was about 8700 ft.NTSB LAX84LA298Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Ramona, CAAs part of an experimental test flt in the turbine powered acft, intentional spins were performed. The planned one turn spin evolved into a flat spin. Recovery procedures were ineffective and the plt elected to deploy the anti-spin parachute. Despite repeated…NTSB LAX84LA297Accident · No injuriesLimited investigationFinal reportLet L-13 · El Mirage, AZThe glider plt reported that after a release from the tow line, he had difficulty finding lift. He concentrated on finding lift so much that he became disoriented with respect to the rwy. When he elected to return to the arpt, he inadvertently selected a…NTSB FTW84LA248Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · New Roads, LAThe flt instructor stated that the 17 hr student plt was on a supervised solo flt when the accident occurred. The student was landing on rwy 18 with a wind from 220 degrees at 6 KTS. The student was unable to maintain directional control and the acft traveled…NTSB DEN84LA153Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Wiggins, COWhile en route to a field for aerial application, an oil mist appeared on the windshield of the acft. Shortly after that, the eng progressively lost power & the plt made a forced landing in a pasture. During the landing roll, the acft hit a hole in the ground…NTSB DEN84FTE01Accident · 1 fatalFinal reportHarper/Cricri MK-12 · Longmont, COThe homebuilt acft was on downwind leg of the traffic pattern, after initial takeoff, when it went into a dive & collided with the ground. A witness said he heard a power reduction before the dive & power added again as it started down. The plt's son said his…NTSB CHI84LA198Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Sardinia, OHThe acft collided with trees during the landing approach. Witnesses said the wind was gusty but no gusts were officiallyreported. No malfunctions of equipment were reported. Due to a head injury the student plt has no recall of the accident.NTSB ATL84LA174Accident · No injuriesLimited investigationFinal reportEiriavion PIK 20E · Thomasville, NCThe plt reported that the acft suffered a partial power loss at 150 ft AGL while on initial climb. The plt attempted to return to the airport to land and the eng lost total power. The pilot made a forced landing in a mature wheat field. Examination of the eng…NTSB ANC84LA079Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Sand Point, AKThe plt stated that at the end of the landing roll, a strong gusty crosswind blew the acft to the left side breaking the left landing gear & wing.NTSB SEA84LA109Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Craigmont, IDDuring aerial application the engine lost power & a forced landing was initiated to a wheat field. During the landing approach the acft stalled at about 10 to 20 feet AGL. The acft landed hard and flipped over. Examination of the engine revealed a broken…NTSB LAX84LA296Accident · Minor injuriesLimited investigationFinal reportGinn Thorp T-18 · Lancaster, CAThe acft lost power and nosed over during a forced landing on desert terrain. An inspection of the engine showed that the automotive type filter had disintegrated and had been ingested in the carburetor. The filter was 4 years old. After the filter was…NTSB FTW84LA235Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30 · Plainview, TXA tlt loss of power occurred during the initial takeoff climb. The landing gear collapsed when a forced landing was made in an open field. The acft just came out of an annual inspection. After the accident a fuel leak was found where the main inlet fuel line…NTSB DEN84IA152Incident · No injuriesIncident investigationFinal reportCessna U206G · Dulce, NMThe plt reported that the arpt was in a valley surrounded by mountains & the elevation was about 6800 ft. with the wind out of the northwest, rwy 33 was the most favorable for the takeoff. There was a ridge about 1/2 mi north of the arpt making it necessary…NTSB CHI84IA196Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10-40 · Minneapolis, MNDuring climb from FL330 to FL370 the 1st officer saw sparks and smoke coming from the left side panel under his glare shield. Cockpit lights were turned off and smoke stopped. Flt returned to Minneapolis and landed without incident. Inspection of the acft…NTSB ATL84FA173Accident · Serious injuriesField investigationFinal reportBoeing 727 · Covington, KYAfter leveling at FL330, the #2 eng fire warning light & bell activated. The crew followed the published procedures, shut down the eng & used a fire bottle. They then diverted to cincinnati & made a precautionary landing. After landing, fire dept personnel…NTSB ATL84FA172Accident · 2 fatalField investigationFinal reportBeech 35 · Chesapeake, VAThe acft was being flown on a test flt after a new fuel pump had been installed. While taxiing for takeoff, the eng stopped. The plt restarted the eng & subsequently performed a takeoff. Witnesses saw the acft climb to about 500 ft AGL & begin a turn onto the…NTSB NYC84LA176Accident · No injuriesLimited investigationFinal reportCessna 172 · Sayville, NYAbout 6 min after departure the pilot experienced a total loss of power and advised the tower that he would be landing in the water.NTSB FTW84LA240Accident · No injuriesLimited investigationFinal reportRockwell S2R · Alexandria, LAThe acft collided with a static wire between two electrical poles while maneuvering during aerial application. Control was maintained and the acft returned to the airport and landed without futher incident.NTSB FTW84LA234Accident · Serious injuriesLimited investigationFinal reportCanadair CL-600 · Clarksville, TXCruising at FL350, N215RL encountered wake turbulance from a descending 'heavy' Boeing 767. The resultant upset caused an uncontrolled loss of 11,000 ft in 10 to 15 seconds before the crew was able to recover. The acft was not damaged but an unrestrained pax…NTSB FTW84LA233Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Colcord, OKThe flight departed downwind from an unimproved field to avoid power lines at the upwind end of the field. During the takeoff roll sufficient speed could not be attained to lift off and clear a fence at the departure end of the runway. The pilot attempted to…NTSB DEN84LA151Accident · Serious injuriesLimited investigationFinal reportCessna A185F · Grand Junction, COThe plt-in-command (PIC) was checking out another plt on a pipeline route. The copilot was occupying the left seat & was flying the acft. While surveying the pipeline, they proceeded north up a canyon toward Douglas pass. No turbulence & little effect from…NTSB CHI84LA193Accident · No injuriesLimited investigationFinal reportCessna 172M · West Lafayette, OHThe acrt swerved off the rwy into soft plowed terrain and nosed over. The plt said that the wind had changed direction and velocity since his takeoff 2 hours before.NTSB CHI84IA195Incident · No injuriesIncident investigationFinal reportCessna 152 · Mansfield, OHThe plt stated that he made a normal cross wind landing and after a 5-10 ft ground roll, was blown off the rt side of the rwy.NTSB ANC84LA071Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Mt Mckinley Vil, AKThe helicopter experienced an engine failure while cruising at about 600 ft AGL. The pilot made a forced landing during which the main rotor blades collided with trees. Examination of the aircraft fuel system revealed that the check valves located in the fuel…NTSB SEA84LA108Accident · No injuriesLimited investigationFinal reportCessna 182P · Douglas Island, AKThe plt reported a complete loss of power with oil visible on the left side of the windscreen. The plt was unable to glide to land and the acft was ditched in deep water about 100 yds from shore. The acft was not recovered.NTSB SEA84LA107Accident · No injuriesLimited investigationFinal reportCessna 180H · Bellingham, WADuring the landing roll with a cross-wind, directional control was lost & the acft ground-looped to the left collapsing the right main landing.NTSB NYC84LA197Accident · No injuriesLimited investigationFinal reportCessna C172 · Mansfield, MAStudent plt on first solo landed hard due to late flare. The acft touched down on the nose gear resulting in substantialdamage. A go-around was accomplished followed by an uneventful landing.NTSB NYC84LA173Accident · No injuriesLimited investigationFinal reportBeech B19 · Danbury, CTThe plt stated while performing the last landing of the day a gust of wind blew the left wing up as the acft was being flared. The acft landed hard and bounced back into the air. A go-around was initiated but when another taxing acft was viewed in the…