NTSB investigations
902 cases where the first occurrence was “Miscellaneous/other”.
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\" = 430) 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" = 430) 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 ATL87LA102Accident · Serious injuriesLimited investigationFinal reportBoeing 727-295 · Miami, FLAn 84 year-old male pax got up from his seat shortly after takeoff and headed toward the aft lavatories. The seat belt and no smoking signs were still illuminated. The acft was at about 1000 ft AGL and in a steep climb attitude. The pax fell face forward…NTSB CHI87IA110Incident · 1 fatalIncident investigationFinal reportCessna 172L · Plainfield, ILThe pilot decided the weather was not good enough to fly, but he would run the engine and turn the tires. He was discovered in the plane by other pilots and later pronounced dead, from carbon monoxide asphyxiation. The muffler had a 12 inch crack which a…NTSB BFO87DID02Accident · Serious injuriesFinal reportEagle Balloons C-7 · Montvale, VAThe balloon plt selected a downsloping field with powerlines at the apch end and woods at the upwind end in which to land. On touchdown, the basket tipped over and the plt was pulled from the basket by his grip on the crown valve line. The balloon began to…NTSB CHI87DEE06Accident · No injuriesFinal reportSchleicher ASK-21 · Plainfield, ILThe glider plt rprtd that drg takeoff, the tow plt released the tow rope at aprx 15' AGL. Rprtdly, he released the tow rope due to a perceived lack of takeoff & climb performance. After being released, the glider plt made a right turn to avoid unacceptable…NTSB MIA87LA097Accident · No injuriesLimited investigationFinal reportBeech B-65 · Key Largo, FLThe aircraft was found crashed in shallow water near Key Largo FL. Attempts to locate the pilot or current operator were fruitless. The circumstances surrounding the crash and the cause are unknown.NTSB LAX87FA126Accident · Serious injuriesField investigationFinal reportBoeing 747-236B · Los Angeles, CAA Boeing 747-236B crew evacuated all occupants via escape slides after returning to Los Angeles after receiving a specific bomb threat. One passenger sustained serious injury during the evacuation. According to a witness, the 370 passengers evacuated the acft…NTSB MIA87LA095Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Clearwater, FLThe private pilot attempted to reduce throttle and land but the throttle control did not reduce the power. He then landed and attempted to use the brakes to stop the aircraft but it slid off the end of the runway into a ditch. Post accident examination of the…NTSB CHI87LA086Accident · 1 fatalLimited investigationFinal reportCessna 172RG · Camp Douglas, WIThe passenger rprtd that about 5 min after takeoff, the plt became incapacitated & was no longer able to maintain control of the acft. The non-certificated passenger assumed control. With the assistance (instructions) from an airborne flt instructor & an…NTSB DEN87IA058Incident · 1 fatalIncident investigationFinal reportBeech 58 · Colorado Spring, COThe PIC became unconscious while at the controls during cruise. The co-owner of the acft, a rated pilot who was in the right front seat, took control and diverted to a nearby apt. The PIC was transported to a hospital where he was pronounced doa. An autopsy…NTSB NYC87LA090Accident · No injuriesLimited investigationFinal reportCessna 150C · Manville, NJAfter making a rest stop, the plt attempted to restart the eng, using a normal start procedure, but the starter would not engage. He tried to turn off the ignition switch, but said that 'possibly due to the fact that I was wearing heavy gloves, I failed to…NTSB CHI87FA081Accident · Serious injuriesField investigationFinal reportBoeing 747-122 · Detroit, MIDrg flt, united flt 108 recd info of a bomb threat. Due to a short time limit, specified in the threat, the flt divertedto Detroit & the slides were used to evacuate the acft; 8 of 10 slides deployed nmly & were used. The slide at door 4R didn't inflate &…NTSB NYC87LA054Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Fairfax, VTThe CFI reported that he had initiated a simulated eng failure for the student. The student responded properly to the simulated emergency and lined the acft up on an apch to a field. At 200 ft AGL, the student was instructed to go-around at which time full…NTSB MIA87IA054Incident · Minor injuriesIncident investigationFinal reportBoeing 747-121 · Miami, FLDuring taxi for takeoff the captain of the air carrier became partially incapacitated. The first officer took over and the flight taxied back to the gate. The captain was evacuated to a local hospital where he was treated with glucose for hypoglycemia and…NTSB NYC87LA041Accident · No injuriesLimited investigationFinal reportCessna 441 · Erie, PAReason for the Cessna to veer in a semi-circle and collide with another aircraft is undetermined. Examination of the start lock assemblies could not be completed due to the extensive impact and fire damage. The acft was being prepared for a flt. During a…NTSB MIA87IA038Incident · No injuriesIncident investigationFinal reportBeech BE-95-55 · Ft. Lauderdale, FLThe private pilot suffered a massive heart attack in cruise flight shortly after take-off. The pilots wife who held an expired private pilots certificate took over and landed successfully. The pilot was pronounced deceased upon arrival at a local hospital. No…NTSB NYC87LA032Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Philadelphia, PADuring hand propping, the aircraft began to move and rolled across a field crashing through a fence when fire erupted destroying the aircraft. The plt stated that after setting brakes to full pressure he atmptd to had prop acft. The eng started and while the…NTSB CHI87FA018Accident · Serious injuriesField investigationFinal reportGates Learjet 23 · Charleston, WVThe PIC lost consciousness during cruise near Charleston WV while on a revenue flt. The co-plt assumed command and landed at Charleston WV without further incident. The PIC was hospitalized and the flt continued on to detroit mi after a replacement PIC was…NTSB LAX87LA020Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Pacoima, CAThe plt refueled the acft, but was unable to restart the eng by using the battery. He hand propped the eng which started immediately. The acft began to move unattended & the plt clung to the left wing strut, but relinquished his grip after the acft moved aprx…NTSB DEN87DTE01Accident · No injuriesFinal reportCassutt Sport Racer · Brighton, COThe plt rprtd that he did not properly lock the canopy & it came open drg flt at 7000 ft MSL. He reduced the speed & attempted to close the canopy, but was not successful. He diverted & attempted to land at the van aire arpt while holding the canopy with his…NTSB LAX86LA357Accident · No injuriesLimited investigationFinal reportCessna 210N · Douglas, AZThe acft was found abandoned 25 miles west of Douglas, Arizona. A landing was made on a dirt road where the acft contacted a ditch and nosed over. The acft was reported stolen and the plt was not located. According to the local sheriff's office, traces of…NTSB CHI86FEP09Accident · 1 fatalFinal reportPiper PA-32R-300 · Wisconsin Rapid, WIATC had cleared the aircraft for an approach to an airport with several nonprecision instrument approaches and to maintain an altitude until established on a segment of an approach to that airport. Shortly after that time witnesses located 4.5 miles northwest…NTSB SEA86IA240Incident · No injuriesIncident investigationFinal reportCameron D-50 · Seattle, WAThe acft plt and gnd crew were conducting gnd handling and mooring procedures. The plan was to ascend about 10 ft AGL over the fld. The fld was in a depression surrounded by tall trees and se of a 400 ft AGL radio twr. During lift off the gnd crew held the…NTSB LAX86LA360Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G102 III B · California City, CAThe plt stated he was towed to an alt of aprx 2,000 ft AGL. After release the canopy came open and the plt returned to the arpt. On final apch he noticed the airspeed indicator was indicating 'low forties'. The plt stated the next thing he remembered was…NTSB ATL86LA236Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Coshocton, OHThe plt initiated a maximum power takeoff from a confined parking lot with 2 passengers on board. The area was boardered by obstructions & people. The plt rprtd that during lift-off, she increased power to 2900 RPM, lifted off to a 4' hover with 33' of…NTSB ATL86LA226Accident · No injuriesLimited investigationFinal reportCessna 150L · Campobello, SCWhile on her 2nd solo x-country flt, the student plt became lost/disoriented after the comm/nav radios developed a problem. Subsequently, she made a precautionary landing in an open field. During the landing roll, the acft hit a ditch & nosed over.NTSB SEA86LA199Accident · No injuriesLimited investigationFinal reportSchweizer 2-22EK · Easton, WAThe instructor pilot was flying the glider with a student in the front seat on a local instructional flight. About 2200 ft down the 2640 foot grass strip, the tow aircraft, at about 50 to 100 feet AGL, lost power and started to descend back to the runway. The…NTSB FTW86LA132Accident · Serious injuriesLimited investigationFinal reportBoeing 727-200 · Dfw Airport, TXThe aircraft was in smooth air and in straight and level flight. The 'fasten seat belt' sign was illuminated. A male passenger went to the forward lavatory and fell, injuring his head and back. The floor was dry and there was no loose or torn carpet ot other…NTSB CHI86FEV04Accident · Minor injuriesFinal reportPate Quickie · Danville, ILAfter performing hi speed taxi tests, the plt of a new home built acft took off on the acft's 1st flt. After taking off,he realized something was wrong; however, by then, the acft was past the dep end of the rwy at 50 to 75 ft AGL & would not climb any…NTSB SEA86FA211Accident · Serious injuriesField investigationFinal reportSchweizer SGS-2-33 · Toledo, WAThe weak link at the tow vehicle broke during launching. The plt lowered the nose of the acft and turned into the wind. The plt stated that the acft was stalled and that he was unable to stop the descent rate. The acft struck the runway in a slight nose down…NTSB CHI86LA186Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Mattoon, ILThe glider was being towed for takeoff behind a tow plane. According to the glider instructor, the initial acceleration appeared normal. As the tow plane and the glider neared the end of the runway, the glider instructor believed the tow plane was…NTSB MIA86LA219Accident · No injuriesLimited investigationFinal reportCessna 172M · Fort Myers, FLThe plt stated that his non-rated wife was onboard the acft while he was pulling the propeller through, priming the engine. While doing so, the engine started due to the mag switch being left on. The acft then taxied uncontrolled, colliding with a parked…NTSB ATL86LA201Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Topsail Beach, NCThe plt was on a x-country flt from new york state to Florida with a planned refueling stop at wilmington, NC. He reported that he became disoriented when the acft's VOR needle began wavering, about 28 miles north of wilmington. Also, he stated that he no…NTSB MIA86FA216Accident · 3 fatalField investigationFinal reportBeech V35 · Tampa, FLThe private pilot transmitted to the contrl tower shortly after lift off that he had a door ajar, and he was turning back to the runway. Witnesses saw the aircraft execute a teardrop type of turn back to the runway with a nose high attitude, gear down and in…NTSB LAX86LA286Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Paso Robles, CAThe plt was informed that he was trailing smoke on climb out. The plt elected to continue the climb due to IMC at the departure arpt and divert to another arpt located 26 NM north. He continued to climb to 4,500 ft MSL to VMC. The oil warning light…NTSB NYC86IA215Incident · No injuriesIncident investigationFinal reportBoeing 737-200 · Pittsburgh, PACo-plt was flying acft on short final approach/landing. Capt observed co-plt having difficulty maintaining glideslope and airspeeds. Co-plt stopped flying the acft. Capt took control at 50' AGL and landed safely. Medical help requested and received from cabin…NTSB MIA86FA200Accident · 1 fatalField investigationFinal reportGrumman G-164B · Vega Baja, PRThe plt of the Grumman ag cat allowed 2 parachutists to board the resticted catagory acft for a parachute jumping flt. Each parachutist was positioned on a wing with his arm crooked around the respective wing center strut. After takeoff, the parachutist on…NTSB DEN86LA189Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Hurley, NMDuring landing, one of the paxs in the Balloon basket suffered a broken ankle. Plt says landing was a normal rip out landing. Neither he nor pax knows how injury occurred.NTSB ATL86IA190Incident · Minor injuriesIncident investigationFinal reportSwearingen SA-26AT · Waycross, GAThe pax had received instructions by the plt on how to open the cabin door. The acft was shut down on the ramp and the pax attempted to open the cabin door. The latch was turned; the door began to fall open and the pax caught the door step channel at a hinge…NTSB SEA86LA152Accident · No injuriesLimited investigationFinal reportRockwell S2R · Caldwell, IDShortly after departure the pilot could not get any aileron response. A landing was attempted at a nearby airport where a go around became necessary. During the go around control of the aircraft was lost and it descended to ground impact. Investigation…NTSB LAX86MA275Incident · No injuriesMajor investigationFinal reportBoeing 747-122 · Pacific Ocean (Pacific Ocean)While ual flt 1 was cruising at FL 310, aprx 1.8 hr after takeoff, a flt attendant (f/a) rprtd a headache & lightheaded-ness. The flt climbed to FL 350, then another f/a & svrl pax rprtd similar symptoms. At that time, the tropopause was AT40,000'. As the flt…NTSB LAX86MA268Accident · No injuriesMajor investigationFinal reportAerospatiale AS-355F-1 · Galveston, TXThe plt rprtd that while apchg an oil drilling platform for a lndg, he observed the main rotor blades go out of track about 8 to 10 inches. He also rprtd the helicopter developed a 1:1 vertical vibration. Drg the lndg, the helicopter entered into ground…NTSB ATL86LA165Accident · No injuriesLimited investigationFinal reportCessna 172M · Cobb, GAThe plt reported a rough running eng. He attempted a precautionary ldg during which the acft's nose wheel dug in the soft ground and the acft nosed over. Post accident inspection of the eng failed to disclose any failures/malfunction.NTSB LAX86LA244Accident · No injuriesLimited investigationFinal reportPiper PA-28-150 · Santa Margarita, CAThe pilot stated that he had problems with his navigation radio and overflew his destination airport. He subsequently became disoriented, ran one fuel tank dry, and then made a precautionary landing, since he was low on fuel. On landing, the nose gear…NTSB ATL86IA162Incident · No injuriesIncident investigationFinal reportBoeing 727-225 · Charleston, SCDuring a scheduled air carrier flight at normal cruising altitude, the captain passed out upon re-entering the cockpit after excusing himself to go to the lavatory. The flight crew diverted to an alternate destination due to the medical emergency. A review of…NTSB LAX86MA238Accident · Minor injuriesMajor investigationFinal reportAerospatiale AS-355F-1 · Kameula, HIThe plt rprtd that as he 'hovered' the helicopter btn 5 & 10 ft after lift-off, he noted a 'slight lateral vibration.' He lndd immediately, but the vibration/ground resonance (vib) increased in severity, so he 'shut-off' both throttles. The vib contd to the…NTSB LAX86LA228Accident · Minor injuriesLimited investigationFinal reportBeech A19 · Taylor, AZThe acft collided with wires after a loss of alt during the initial climb while on a night VFR flt. The plt indicated that it took 3/4 of the rwy to get airborne and the acft did not seem to climb with full pwr applied. The plt decided to return to the arpt…NTSB SEA86LA114Accident · No injuriesLimited investigationFinal reportEiriavion PIK 20-D · Minden, NVThe cockpit canopy opened during takeoff roll. The glider became airborne and climbed to an alt of aprx 10 ft AGL before descending to ground impact in a nose low attitude.NTSB LAX86LA184Accident · No injuriesLimited investigationFinal reportCessna 310N · Fullerton, CAThe acft overran the rwy during an aborted takeoff. The plt had flown the acft the day prior on his bfr and conducted a 'thorough preflight' insp. On the day of the accident, he preflighted the acft again and flew it without incident. He then refueled the…NTSB FTW86FA066Accident · 2 fatalField investigationFinal reportGrumman G164A · Hankamer, TXTwo Grumman ag cats operated by the same air service collided in mid air. The accident occurred as one was departing and the other was returning to a temporary air strip adjacent to the fields they were fertilizing. Witnesses indicated that both pilot…NTSB SEA86LA087Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Warm Springs, ORA precautionary landing was made due to the pilot becoming lost, the aircraft's navigation radio not working, and low fuel. A gusting crosswind was present during landing. On rollout the aircraft's wing tip caught a fence and the aircraft nosed over.