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 DEN85FA075Accident · 6 fatalField investigationFinal reportCessna 421C · Albuquerque, NMThe plt was flying his wife & her 4 friends to aspen, co for a ski vacation. Witnesses reported that during takeoff, the rgt baggage door opened. They observed the acft turn left onto a downwind with the landing gear extended. Eight witnesses reported the…NTSB ATL85FA089Accident · No injuriesField investigationFinal reportDouglas DC-3 · Charlotte, NCThe plt attempted an insrument departure from Charlotte, NC, without deicing the acft which witnesses stated, had ice on the airframe. During climbout, the plt was not able to maintain elevator control so he returned to land at Charlotte. During the landing…NTSB CHI85MA100Accident · Serious injuriesMajor investigationFinal reportSwearingen SA-227 · London, KYDrg arrival, at 0540:31, the capt was clrd for an RNAV rwy 5 apch & was told to contact London fss on 121.6 mhz, 'now.' However, he did not make the radio call until aprx 3 min later. The acft broke out of the wx at about 1000' & 1 mi fm the arpt (before the…NTSB DEN85IA068Incident · No injuriesIncident investigationFinal reportBoeing 737-291 · Steamboat Sprin, COShortly after departure from oakland, capt indicated he did not feel well. During the descent into den, the capt passed out for several minutes. He was revived with oxygen administered by a flt attendant. F/o made landing and capt taxied to the gate. Capt was…NTSB DCA85AA010Accident · 70 fatalFinal reportLockheed 188C · Reno, NVShortly after galaxy airlines flt 203 lifted off from rwy 16R, the coplt transmitted that they would like to 'make a left downwind, we gotta get back on the ground.' He then rprtd that there was a hvy vibration in the acft. Flt 203 was cleared as requested,…NTSB DEN85LA060Accident · Minor injuriesLimited investigationFinal reportBeech B36TC · Billings, MTPlt used cannula connected to portable oxygen system during climb starting at 11,000 ft MSL. At FL 170 plt switched to a mask connected to acft oxygen ststem. At FL 250, plt complained of stomach pains for aprx 1/2 hr. Plt then stated to his son that his…NTSB MIA85IA076Incident · No injuriesIncident investigationFinal reportDouglas DC3A · Naples, FLShortly after takeoff, the aircrew noted that the elevator control was locked. They declared an emergency & landed without causing damage to the acft. After landing, the elevator external gust lock was found still installed.NTSB NYC85FA047Accident · 1 fatalField investigationFinal reportCessna 402B · Rochester, NYPrior to tkf the plt was informed of wind shear as centerfield winds as 270 deg at 25 KTS gust to 46 KTS & nw boundary winds as 280 deg at 13 KTS. During tkf the plt reported an opened door & requested to return to land. The acft turned left and descended to…NTSB MKC85LA029Accident · 1 fatalLimited investigationFinal reportSikorsky S58J · Storm Lake, IAA passenger was being transported from a boat to shore. The plt lowered a wheel strut to the boat for the boarding and says he received a radio call from the passenger saying, 'ok I'm ready let's go.' The plt assumed that he was inside the acft and a climb…NTSB ANC85LA024Accident · No injuriesLimited investigationFinal reportCessna 170B · King Salmon, AKThe acft crashed during a takeoff from a sandbar on the King Salmon river. The plt stated that during his take- off roll, the windshield fogged over & he was unable to see, the acft's main gear struck a rock & the acft nosed over.NTSB MIA85LA033Accident · No injuriesLimited investigationFinal reportCessna 172C · Titusville, FLAccording to the plt, after he was unsuccessful in starting the acft eng he switched off the magnetos and master switch and exited the acft. Later, during the process of moving the propeller to a position to clear a hand toe bar, the acft started, taxied…NTSB FTW85LA046Accident · No injuriesLimited investigationFinal reportReed Bandit 1 · Amarillo, TXThe homebuilt acft, N52957, was observed to land hard, collapse the landing gear & slide into N3376V holding short of the rwy at an intersecting taxiway.NTSB CHI85LA028Accident · Serious injuriesLimited investigationFinal reportSwift GC-1A · Fraser, MIAccording to the plt, he took off on rwy 18 & was climbing thru about 250 ft AGL when the eng lost power & he made a forced landing. However, a co-owner, who was on board, stated that the plt had retarded the throttle, then the acft stopped stopped climbing,…NTSB CHI85LA018Accident · No injuriesLimited investigationFinal reportHughes 500 · Grosse Ile, MIPlt attempted to start helicopter with main rotor blades tied down.NTSB DCA85IA001Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-30 · Erie, PAThe orig destn was youngstown, OH, but its wx was blo mins, so the flt to transport a football team was planned to Erie which was slightly above mins. The coach & business manager were not happy about this, but plans were made to bus the team on to…NTSB SEA85LA002Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Hood River, ORAt about 150 ft AGL on climb out, the tow plane lost power for an unspecified reason. The glider pilot released the tow and executed a 180 degree course reversal to a downwind (15 KTS) landing. During roll out, the left wing contacted the ground, causing an…NTSB DCA84IA001Incident · No injuriesIncident investigationFinal reportBoeing VC-137B-BN · Akron, OHA Boeing VC-137B-BN, USAF #58-6971, operating as air force 2 (AF-2), departed cleveland, OH, at about 1745 EDT on an IFR clearance. After departing cleveland, AF-2 was assigned an alt of 8000 ft MSL by cleveland departure control & was transfered to cleveland…NTSB CHI84LA388Accident · No injuriesLimited investigationFinal reportAvian Balloon AX8 · Canton, OHPlt and passenger (student balloon pilot) elected a precautionary landing in an open field rather than overfly densely populated area and power lines, on touchdown, wind lifted balloon slightly and caused drift. As student plt was operating envelope vent, she…NTSB FTW84IA389Incident · No injuriesIncident investigationFinal reportDassault/Sud FAN JET Falcon · Washington, DCAprx 1-1/2 hrs after take-off, the capt took sinus medication. Aprx 30 minutes later, he complained of a headache, took tylenol & alka seltzer & went to the cabin to lie down. The capt was incapacitated for the rest of the flt. The coplt & a plt rated pax…NTSB MIA84IA247Incident · 1 fatalIncident investigationFinal reportPiper PA-28-161 · Dade Collier, FLThe non-rated passenger landed the acft after the plt suffered a heart attack & became totally incapacitated. During the landing, the nose gear collapsed.NTSB DEN84LA289Accident · Serious injuriesLimited investigationFinal reportRaven AX-8 · Clark, CODuring a normal high wind landing a pax received two fractures of the fibula bone. Another pax reported that the injured pax was standing on one leg with the other knee bent resting on a propane tank during the landing. Pax were reportedly briefed on the…NTSB DEN84LA273Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Littleton, COPlt stated that the entire flt was uneventful. The female passenger had her knees bent in preparation for landing but her body was twisted in a direction that was opposite to her feet when the balloon made ground contact.NTSB ATL84LA300Accident · No injuriesLimited investigationFinal reportLet L-13 · Warrenton, VAThe plt inadvertantly deployed the flaps on final apch instead of the spoilers. The glider overshot the airstrip touching down in rough terrain off the departure end.NTSB CHI84LA361Accident · No injuriesLimited investigationFinal reportBeech V35B · Eden Prairie, MNPlt reported that after operating the fuel boost pump on pre-flt, he exited the acft to turn the prop by hand. During a telephone interview, he stated he could not recall removing the ignition key. After pulling the prop through 1/4 turn, the eng started and…NTSB CHI84LA346Accident · Serious injuriesLimited investigationFinal reportCameron Viva 7 · Oswego, ILThe passengers stated that the landing was normal. One lady said she lost her balanced and thought she just sprained her ankle, but learned later it was broken.NTSB FTW84LA327Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Denton, TXThe pilot stated that after takeoff he did 3 touch and go landing then started a series of stalls. After entry into a cross-control spin to the left, he found that he could not apply enough right pedal to recover. Examination of the aircraft revealed that the…NTSB MKC84LA216Accident · Serious injuriesLimited investigationFinal reportAdams AB · Ballwin, MOThe plt reported that before landing, he rebriefed the passengers on the landing technique. He noted that a lady passenger seemed nervous about the landing. The plt landed in a pasture with an estimate 6 kt wind. Reportedly, the balloon made a soft touchdown,…NTSB CHI84FA292Accident · Serious injuriesField investigationFinal reportCessna 182A · Henryville, INThe aircraft's annual inspection was thirteen years overdue and the pilot had not logged any flight time inn almost one year. Twenty eight airworthiness directives had not been complied with. The engine quit shortly after take off, when the magneto coils…NTSB SEA84LA140Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Wenatchee, WAThe plt made a low pass over a herd of elk in hilly terrain. He reported that after encountering a downdraft, he decided he could not climb out of the valley & landed with full flaps. The density alt was aprx 5400 ft.NTSB LAX84FA361Accident · No injuriesField investigationFinal reportCessna 404 · San Francisco, CAThe nose baggage door of the acft came open right after the gear was raised during takeoff. The plt said the acft began to pitch up & roll right. He felt that control of the acft was in doubt, so he aborted the intersection takeoff & landed gear-up on the…NTSB CHI84LA244Accident · Serious injuriesLimited investigationFinal reportBarnes AX-7B · Lake Orion, MIA 74 year old passenger in a balloon lost her footing during landing and fell on her arm. Later examination revealed that her arm was broken. The plt and another passenger were not injured. The plt reported that the passengers had been briefed on landing and…NTSB CHI84LA242Accident · Serious injuriesLimited investigationFinal reportAdams A55S · Grayslake, ILThe plt stated that as the balloon touched down, he lost his footing & his left ankle slipped into the corner of the gondala. He suffered a fractured, dislocated ankle.NTSB FTW84LA254Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Amarillo, TXDuring a pre-flt breifing, the wind was reported to be from 280 deg at 6 to 12 KTS. At launch time, the plt estimated the wind was blowing at 7 KTS. He took off at 0720 CDT without difficulty & climbed to about 1000 ft AGL. Aprx 1 hr after taking off, the plt…NTSB CHI84LA216Accident · Serious injuriesLimited investigationFinal reportBalloon Works Barnes Firefly 8-24 · Burnsville, MNThe Balloon landed without incident. According to the plt, the envelope was being deflated when a gust of wind tipped the basket. The plt said he saw a young boy with his leg under the basket. The plt lifted the edge of the basket by stepping out of it to…NTSB DEN84IA163Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · Salt Lake City, UTFlt 428 landed on rwy 16R which was closed for construction. The closure info was contained in a NOTAM which was announced in ATIS info oscar. The flt crew reported they had obtained oscar. The flt was cleared to land on rwy 16L but instead landed on rwy 16R.…NTSB CHI84LA209Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Martin, MIThe plt had landed on a dragstrip after he encountered deteriorating wx. When the wx improved, he took off & attempted to depart over a bleacher area. The plt had difficulty climbing over the bleachers & said 'noticed RPM at 2700, helicopter in a turn.' He…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 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 NYC84LA172Accident · Serious injuriesLimited investigationFinal reportCessna 305A · West Hampton, NYThe acft had just landed & the plt was taxiing to hook up to another glider when the acft became lodged n soft dirt. Two ground crewmembers came over to the acft. The plt stated that he told one of them to 'stay behind the strut while I shutdown'. He then…NTSB NYC84FA159Accident · No injuriesField investigationFinal reportPiper PA-28-140 · North Andover, MAThe plt stated to police that he was positioning the prop for a photo when the engine started and the airplane traveled 2500 ft unattended across the arpt before it became airborne and struck the rear of a commercial bldg that housed three businesses,…NTSB DEN84LA136Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7B · Fargo, NDDuring a Balloon landing which the plt described as normal, a pax banged her knee & broke her knee cap.NTSB SEA84LA080Accident · No injuriesLimited investigationFinal reportSchweizer SGS1-26C · Mount Vernon, WAThe sailplane encountered deteridrating thermals & elected to make an off airport landing as he did not think he could reach the airport. He overshot the selected field in his attempt to miss some wires at the apch end of the field despitethe use of spoilers…NTSB ATL84IA137Incident · 2 fatalIncident investigationFinal reportPiper PA-34-200T · Parkersburg, WVAfter an unscheduled landing due to the condition of a patient aboard the acft, the acft turned off a taxiway into the grass and stopped. Rescue personnel found the plt incapacitated from a heart attack and collapsed over the controls and the nurse…NTSB DEN84IA116Incident · No injuriesIncident investigationFinal reportBoeing 727-224 · Denver, COPrior to taxiing at chicago, the plt had the ramp agent(r/a) check the rear airstair as the aft airstair light on the second officer's panel was 'on'. The r/a recycled the airstair & reported that it appeared closed. The light remained onso the plt referred…NTSB LAX84LA211Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5B · Carlsbad, CAThe plt reported that when the acft was about 10 ft AGL & he was beginning to flare for a landing on rwy 24, a slight gust of wind caused the plane to drift to the edge of the rwy. The plt began correcting for the drift, but the passenger grabbed the yoke &…NTSB CHI84IA127Incident · No injuriesIncident investigationFinal reportBoeing 737-200 · Erlanger, KYWhile the acft was about 15 mi sw of the arpt being vectored for a rwy 36 cat ii approach, the local controller gave theground controller permission to clear snow removal equipment to proceed north on rwy 36 & to exit rwy 36 at the intersection of rwy 27L.…NTSB LAX84FA221Accident · 1 fatalField investigationFinal reportTaylorcraft BC12D-85 · Edwards Afb, CAThe acft collided with the ground and rolled inverted in the desert near Edwards Afb. Examination of the wreckage gave no evidence of a failure or malfunction of equipment. The coroner reported that the plt died of a gunshot wound to the head before the acft…NTSB DEN84LA096Accident · Serious injuriesLimited investigationFinal reportRaven Rally RX7 · Albuquerque, NMThe student plt aboard the balloon suffered a broken leg during a landing. She had been briefed on the proper stance forlanding and the instructor thought she was in the proper position but later found out that the students left leg was broken above the…NTSB MIA84FA058Accident · 1 fatalField investigationFinal reportHiller UH-12C · San Juan, PRA performer fell from a trapeze rigged below the helicopter while it was hovering at about 150 ft AGL. The FAA had not authorized the modification to the acft. The plt was not certified for external load operations. The performer reportedly had not done this…NTSB LAX84IA119Incident · No injuriesIncident investigationFinal reportBoeing 707-123B · Oakland, CAThe acft experienced a strong shimmy & vibration on takeoff which was attributed to deep ruts in the snow. After landingon deceleration the vibration became so severe that the plt stopped on the rwy centerline & ordered an evacuation. It was determined that…