NTSB investigations
3,929 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
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 WHERE c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 130) 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 WHERE c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130) 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 MKC86LA187Accident · No injuriesLimited investigationFinal reportCessna P337 · Wichita, KSAfter a touch-&-go landing, the flt crew noted a problem with the landing gear. A check of the hydraulic sys revealed a lack of fluid in the reservoir; the plts were unable to either retract or extend the gear. Subsequently, they landed the acft with the nose…NTSB FTW86LA164Accident · No injuriesLimited investigationFinal reportHiller FH-1100 · Abilene, TXThe plt was conducting sight-seeing flts from a rodeo/fairground area. During a critical part of a takeoff, a tail rotor blade separated & the plt lost directional control. He attempted an autorotative landing. After spinning around about 3 times, the plt…NTSB CHI86LA219Accident · Minor injuriesLimited investigationFinal reportHughes 500 (369HS) · West Lafayette, INThe helicopter was at a low altitude hover video taping an athletic event when the aft flex coupling on the tail rotor failed. The plt was unable to regain control and during descent the main rotor blades struck the roof of a residence. The helicopter then…NTSB SEA86FA239Accident · No injuriesField investigationFinal reportErcoupe 415-C · Auburn, WAThe plt reported he was climbing after a touch and go, during the climb the 'blown fuse' light came on for the generator. After replacing the fuse sparks started coming from behind the instrument panel. Smoke filled the cockpit as the plt tried to smother the…NTSB MKC86LA184Accident · No injuriesLimited investigationFinal reportCessna 172N · Vichy, MOThe pilot stated that the aircraft's ammeter indicated the electrical system was discharging while at cruise five miles west of rolla national airport, Missouri, and that he decided to continue to his destination airport. Fifteen miles east of rolla national…NTSB MKC86LA183Accident · No injuriesLimited investigationFinal reportCessna 182F · Albany, MOThe plt-in-command (PIC) rprtd that a normal apch & flare were made, but as the acft touched down, the left main gear collapsed. The acft then swerved off the rwy & came to rest on upsloping dirt terrain. Investigation revealed the left main landing gear…NTSB LAX86FVG07Accident · Minor injuriesFinal reportPhillips Steen Skybolt · Sonora, CAAn amateur built Phillips steen skybolt experienced an inflight failure of the upper wing panel fabric which led to a rapid descent and subsequent hard landing in a parking lot. Examination of the wing panel revealed no evidence of glue or bonding material…NTSB SEA86FA231Accident · 1 fatalField investigationFinal reportErcoupe 415C · Prosser, WAThe plt was practicing fly-bys for the next days airshow. The left wing sustained an inflight structural failure. Investigation revealed a progressive crack in the #7 rib emanating from previous damage to the leading edge of the left wing tip. This resulted…NTSB MIA86LA245Accident · No injuriesLimited investigationFinal reportBeech G-35 · Lantana, FLShortly after takeoff the cabin door opened. The pilot continued the short flight to his home airfield. During approach he stated that due to the increased noise in the cabin he forgot to lower the landing gear. The aircraft contacted the runway with the…NTSB ATL86FEK06Accident · No injuriesFinal reportSunburst N/A · Lima, OHAccording to the plt, the ultralight was being taxied when a gust of wind caused it to become airborne. The plt elected to fly around the traffic pattern and return for a landing, however, while airborne it was noted the ailerons were locked in the left bank…NTSB SEA86LA227Accident · No injuriesLimited investigationFinal reportBeech A-36 · Elk City, IDDuring landing roll a loss of braking occurred due to excessively worn brake pads and a bent shaft in the left master cylinder. Near the end of the runway the pilot elected to ground loop the aircraft in order to avoid trees at the departure end of the runway.NTSB NYC86FHD03Accident · 1 fatalFinal reportPassonno Skybolt · Moorestown, NJThe Passonno skybolt was observed to recover from a loop and then the tail surfaces started to shake. The acft then descended to the ground and was destroyed by impact. Examination of various horizontal stabilizer and elevator components showed that the…NTSB LAX86LA332Accident · No injuriesLimited investigationFinal reportCessna TR182RG · San Jose, CAThe plt was unable to fully extend the landing gear and the acft collided with the surface of rwy 30R during landing. Post accident inspection revealed the gear down hose assembly was ruptured thus allowing for a loss of hydraulic fluid.NTSB DEN86LA239Accident · No injuriesLimited investigationFinal reportPiper PA-23E-250 · Grand Forks, NDThe acft was en route from flin flon airport, manitoba, cd, to mason city, IA, and had stopped at Grand Forks, ND, for fuel and to clear customs. During taxi for takeoff, the acft struck a 1-inch concrete lip on the ramp and the right main landing gear…NTSB MKC86LA174Accident · No injuriesLimited investigationFinal reportScheibe Flugzeugbau Bergfalke II-55 · Hutchinson, KSThe pilot stated that he performed what he thought was a thorough pre-flight inspection, including the installation of the horizontal tail, before he pushed the aircraft onto the runway and hooked the tow line. Immediately after liftoff, the pilot further…NTSB MIA86FA241Accident · 1 fatalField investigationFinal reportRussell Post Moni Motorglider · Fellsmere, FLWitnesses reported seeing the aircraft performing aerobatic maneuvers at approximately 1500 feet. The aircraft was later found with the tail surfaces separated. The tail surfaces were found 300 and 400 feet from the main wreckage. A metallurgical examination…NTSB LAX86FVA15Accident · Minor injuriesFinal reportI.C.A. Brasov IS-28M2 · Porterville, CADuring initial climb, shortly after takeoff, the pilot heard a loud whir then a boom sound. The aircraft started vibrating so the pilot shut down the engine. Having gained 200 to 300 feet of alt the pilot initiated a left 180 deg turn to attempt a forced…NTSB LAX86FUM02Accident · 1 fatalFinal reportStar-Lite UNK · Ramona, CADuring a local test flight of an experimental homebuilt acft, the plt was circling aprx 700 ft AGL when the right wing separated from the fuselage. The acft entered an uncontrollable steep angle dive and collided with the terrain. Inspection as to the…NTSB SEA86LA212Accident · Minor injuriesLimited investigationFinal reportMooney M-20-J · Aurora, ORAt about 9,000 feet MSL the pilot smelled smoke and electrical fumes. He then turned off the master switch and returned to land. He manually lowered the landing gear but it folded upon landing roll. Investigation revealed no mechanical reason for the gear to…NTSB NYC86LA206Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Sussex, NJThe Piper PA-28-140 had just taken off when the main cabin door unlocked at the top. The pilot returned for a landing, had to go-around due to traffic, and was on final for his second approach, with the top of the main cabin door still unlocked. When, passing…NTSB MKC86FCJ04Accident · Minor injuriesFinal reportAmateur Built Quickie Q2 · Grand Island, NEThe acft engine developed severe roughness during cruise and the plt decided to make an emergency landing. During approach, the engine quit and the plt attempted a tight turn to the runway. During the turn, the aircraft hit the asphalt ramp in a left wing…NTSB MIA86LA231Accident · No injuriesLimited investigationFinal reportPiper PA24-180 · Orlando, FLPlt was unable to completely extend landing gear via electric and manual means. A landing was made with gear partially extended. Examination of the aircraft after the accident revealed the landing gear extention mechanism was binding in the manual extention…NTSB ATL86FA218Accident · No injuriesField investigationFinal reportHughes 269C · Laurens, SCThe plt was flying an underground cable patrol at 500-600 ft AGL when the accident occurred. The plt reported pwr was set at 20' hg, 3,000 RPM when a 'very loud pop' was heard. The plt likened the sound to being hit by ground fire. The acft yawed and the eng…NTSB LAX86DVA13Accident · No injuriesFinal reportBell 47G-4A · Shafter, CAShortly after departing the loading rig, en route to an agricultural aerial application operation, the forward coupling tail rotor drive shaft failed. The helicopter was about 10 ft above ground level and about 100 ft west of the loading rig. The pilot…NTSB ATL86FLQ06Accident · 1 fatalFinal reportBernard Sonerai II · Trenton, KYWitnesses reported seeing the acft spin to ground impact with a section of the right wing hanging. Post accident exam revealed the outboard half (aprx 4 ft) of the right wing was bent aprx 120 degrees to the inside half of the right wing. Monnett experimental…NTSB SEA86LA191Accident · No injuriesLimited investigationFinal reportCessna T210 · Las Vegas, NVDuring landing roll the aircraft departed the runway to the right despite the pilots attempt to correct with left rudder. The acft struck a ditch and the nose gear separated from the acft. During acft repair the mechanic found the right master cylinder was…NTSB MKC86FA166Accident · 1 fatalField investigationFinal reportAttebery-Stainbrook Varieze · Osawatomie, KSWitnesses stated that the aircraft appeared to be operating normally and flying at cruise altitude when, suddenly the left (port) wing separated from the fuselage. Sounds of engine power ceased immediately following the in-flight breakup and the aircraft…NTSB NYC86LA208Accident · Serious injuriesLimited investigationFinal reportBeech C24R · Hartford, CTThe Beech 24R pilot noticed a build-up of a substance on the windshield. He also experienced a problem controlling the propeller. He said upon landing he could not judge forward visibility and flared high (30-40 ft). The pilot reported that the aircraft…NTSB CHI86FA194Accident · Serious injuriesField investigationFinal reportPiper PA-24-250 · Oshkosh, WIThe aircraft ran out of fuel after 3+41 hours of flight. The pilot stated that he was sure the tanks were full on takeoff. Flight planning and a documented conservative fuel burn rate indicated that the aircraft should have been able to remain airborne for at…NTSB CHI86FEP08Accident · Minor injuriesFinal reportNorth American T28D-FENNEC · Madison, WIAfter the aircraft was initally taxied for takeoff, the pilot returned to the ramp and stated that he was experiencing engine problems. He inquired at an FBO about chartering an aircraft to take himself and his son to an experimental aircraft association…NTSB CHI86FA193Accident · No injuriesField investigationFinal reportCapetown Builders Glasair RG · Fond Du Lac, WIThe pilot experienced a complete electrical system failure that was caused by a broken wire at an alternator terminal. Upon extension of the hydraulically operated landing gear a safe gear down indication was not obtained. Activation of the CO2 operated…NTSB SEA86LA183Accident · Minor injuriesLimited investigationFinal reportCessna 182 · East Sound, WADuring landing roll at about 25 mph the pilot applied both brakes. A short time thereafter the right brake pedal went to the floor. Despite the pilot's application of hard left brake and rudder, the acft veered to the left into a drainage ditch. The nose gear…NTSB CHI86LA185Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Morris, ILDuring cruise flight, the engine stopped and the pilot attempted to glide to an airport, but was forced to land in a cornfield, aprx one mile short of the airfield. A post-crash inspection revealed the flange of the left intermediate exhaust pipe (pn…NTSB CHI86FER15Accident · No injuriesFinal reportSamuel R. Hoskins Q-200 · Eden Prairie, MNAircraft was being test flown following ground adjustment of rudder control cables. During the flight rudder control was lost when rudder bearing blocks detached from their mounting surfaces. Pilot was unable to maintain directional control during landing…NTSB DEN86LA204Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Sisseton, SDThe plt reported that the eng lost about 200 RPM during the takeoff roll and he decided to abort. During the abort the plt swerved to avoid a fence at the end of the rwy and the acft slid sideways collapsing the lt MLG. Investigation revealed a broken…NTSB MIA86IA213Incident · No injuriesIncident investigationFinal reportBoeing 727-225 · Miami, FLFlt was unable to extend nose gear and a nose gear up landing was made. Investigation revealed the nose gear drag brace to be locked in the up position. Disassembly of the drag brace revealed the link assemblies which connect the locking pawls to the locking…NTSB NYC86LA190Accident · No injuriesLimited investigationFinal reportCessna 172P · Plainville, CTWhen the plt checked the airspeed indicator on takeoff, he saw no indication of speed & aborted the takeoff, but was unable to stop on the remaining rwy. The acft contd off the departure end, when down an embankment & became inverted. An exam revealed the…NTSB LAX86MA309Accident · No injuriesMajor investigationFinal reportAerospatiale AS-355F-1 · Morgan City, LAThe plt flew to a nearby arpt to practice takeoffs & lndgs. He rprtd that after 3 lndgs 'out of a hover,' he returned to the departure heliport & lndd again from a hover. Drg touchdown, the helicopter bgn to rock fm side to side & enteredground resonance. The…NTSB FTW86LA131Accident · No injuriesLimited investigationFinal reportBeech B-100 · Houston, TXThe pilot was unable to get a green light for the left main gear prior to landing and finally had to make an emergency landing on the nose and right main gear. The aircraft was substantially damaged when it veered off the runway on the landing roll out.…NTSB MIA86LA209Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Marathon, FLFlight experienced loss of engine oil and subsequent seizing of the engine at which time the aircraft was ditched in the gulf of Mexico. Post crash examination of the engine revealed the oil line from the propeller govenor to the engine nose case had failed…NTSB NYC86LA179Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Newburyport, MAPilot made a precautionary landing after experiencing a rudder control failure after a banner pick up. The left aft rudder cable had parted 49.5 inches aft of the rudder pedal attachment point.NTSB LAX86FVA11Accident · Serious injuriesFinal reportBell 47G-5 · Porterville, CADuring an aerial application flight the plt lost control of the helicopter and collided with a building. Examination revealed that the inside diameter of the tail rotor driveshaft was not coated with aluminized lacquer as required by the Bell finish process…NTSB LAX86LA283Accident · Serious injuriesLimited investigationFinal reportTexas Helicopter OH-13H/M · Valencia, CAThe pilot reported that he heard a loud bang and grinding noise from the engine/main transmission area while on a swath run. He stated that the main rotor RPM decayed immediately after he heard the noise. As the helicopter descended to about 50 feet above the…NTSB LAX86FA278Accident · 4 fatalField investigationFinal reportBeech C24R · Meyers, CAWith a density altitude of about 8400 ft, and an aircraft near its max certificated gross weight, the plt & 3 pax departed on rwy 18. During takeoff either the pilot's door was not closed or it came open. The open door degraded the acft's climb performance.…NTSB CHI86FEE05Accident · Serious injuriesFinal reportEipper Mxii · Aurora, ILDuring cruise flight the ultralight experienced an inadvertent deployment of the drag chute accompanied by a failure of the drag chute to inflate. This resulted in an uncontrolled descent and subsequent impact with the terrain.NTSB ATL86LA191Accident · No injuriesLimited investigationFinal reportCessna 337F · Cherry Point, NCWhen the gear selector handle was placed in the up position the gear unsafe warning horn sounded. The plt reported a stall warning horn to ATC and returned to the airport and landed. Finding nothing wrong with the aircraft the plt. Took-off again. Whenthe…NTSB MIA86LA191Accident · Serious injuriesLimited investigationFinal reportBeech 76 · Ft Lauderdale, FLThe plt stated that just as he rotated the acft for takeoff, the cabin door popped open. The acft then struck the ground hard in a nose down attitude, sheared off the main landing gear and slid to a stop on the runwy. According to the emergency procedures in…NTSB MIA86LA186Accident · No injuriesLimited investigationFinal reportCessna U206F · Ft. Myers, FLThe private pilot had just completed a short no-radio night flight and during the landing roll the nose gear wheel assembly separated from the aircraft. Examination revealed that the wrong nuts had been installed on the wheel assembly at the last annual…NTSB ATL86LA179Accident · Serious injuriesLimited investigationFinal reportAndrew D. Moore HP-18 · Chester, SCThe pilot related that while turning from base to final he heard a loud bang from the left side of the aircraft. The aircraft entered a steep left turn and crashed left of final approach course. Post crash examination of the aircraft revealed that the flap…NTSB ANC86IA088Incident · No injuriesIncident investigationFinal reportCessna 404 · St Marys, AKDuring the descent into st. mary's, Alaska, the door ajar warning light illuminated. The pilot-in-command checked the rear door and then the front crew door. When the handle of the crew door was retouched it flew open and departed the airplane taking about…