NTSB investigations

35,889 cases where the phase of flight was Enroute.

Cases, newest first

Query with SQL
duckdb -csv -c "WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
    crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
    current_codes AS (
      SELECT e.case_mkey, TRY_CAST(e.\"tier1Number\" AS INTEGER) AS code,
        row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e.\"isDefiningEvent\", false) DESC, e.position) AS n
      FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
      WHERE e.aircrafts_position = 1 AND e.\"tier1Number\" GLOB '[1-9][0-9]*'
        AND (e.\"isDefiningEvent\" OR e.case_mkey IN (SELECT \"mKey\" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE \"isPre1982\"))
    ),
    phases AS (
      SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
      FROM current_codes WHERE n = 1
      UNION ALL
      SELECT o.case_mkey, 'older', o.\"phaseOfFlightCode\", w.main
      FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o.\"phaseOfFlightCode\"
      WHERE o.aircrafts_position = 1 AND o.\"occurrenceNumber\" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
    ),
    case_phases AS (
      SELECT p.*, c.\"eventDate\", c.\"highestInjuryLevel\" = 'Fatal' AS fatal, a.aircraft_model_code
      FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = p.case_mkey
      LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
      WHERE c.\"eventDate\" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
    )
  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 case_mkey FROM case_phases WHERE main = 400)
  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 DEN84FA298Accident · 1 fatalField investigationFinal reportCessna 182P · Glen Canyon, UTThe acft crashed into the 10388 ft high navaho mountain at about the 9800 ft level. Reportedly there was no moon that evening. The plt had departed hayward, CA at 1351 MDT & was enroute to farmington, NM. The acft crashed at 2027 MDT. Investigation revealed…Sep 18, 1984 · N1939M · DestroyedNTSB ANC84LA185Accident · 1 fatalLimited investigationFinal reportPiper PA-12 · Dadina Lake, AKPrior to the accident the plt had been involved in moose hunting activities. On the morning of the occurrence he had made two successful flts hauling meat from a small unnamed lake to Dadina Lake, about 3 miles north. Shortly after the third takeoff from the…Sep 18, 1984 · N3269M · Substantial damageNTSB ANC84FA190Accident · Serious injuriesField investigationFinal reportBellanca 8KCAB · Ouzinkie, AKPlt completed 5 turn spin, cockpit began filling with smoke. Electrical equipment was turned off and plt was descending for precautionary landing when elevator control was lost. Acft settled into 75 ft tall trees. Source of fire which resulted in battery…Sep 17, 1984 · N8592 · Substantial damageNTSB SEA85FA016Accident · 1 fatalField investigationFinal reportCessna 172M · Aberdeen, WAAcft wreckage indicates impact was nose down inverted. No evidence was found of acft failure/malfunction. Plt departed on night cross-country after an evening out with friends. Wreckage found two months later, no toxicological tests possible.Sep 16, 1984 · N1150T · DestroyedNTSB NYC84FGM07Accident · Serious injuriesFinal reportPiper PA-28-140 · South Fork, PAUpon departure the plt estimated 25 gal of fuel. The total power loss occurred 1 hr and 55 min later. After the forced ldg on unimproved terrain no evidence of fuel remained in the fuel system. There was no indication of any full spill from the ruptured left…Sep 16, 1984 · N8257N · Substantial damageNTSB SEA84LA229Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Kelso, WAClimbing through 4,000 ft the engine failed. Emergency procedures resulted in a momentary restoration of power prior to the forced landing. During final approach the left wing struck a tree. The right main landing gear collapsed during the landing roll.…Sep 15, 1984 · N1054Q · DestroyedNTSB SEA84LA221Accident · No injuriesLimited investigationFinal reportCessna T206 · Austin, NVPersonnel employed by the operator stated that the pilot flew the acft for 1.8 hours the night before the accident. Without refueling, the plt flew for 3.6 hours when the engine failed due to fuel exhaustion. During the forced landing roll the acft traveled…Sep 15, 1984 · N1949U · Substantial damageNTSB NYC84FA313Accident · Serious injuriesField investigationFinal reportPiper PA-34-200T · Buffalo, NYThe acft crashed on main street, Buffalo, NY, while executing a forced landing during an air taxi cargo operation. Investigation revealed that based on fuel consumption calculations the plt had not allowed for all contingencies during his orginal flt planning…Sep 15, 1984 · N4512E · DestroyedNTSB LAX84FA481Accident · Serious injuriesField investigationFinal reportPiper PA-28-236 · Santa Paula, CAAfter departing rwy 22 at Santa Paula arpt, the acft flew sw along the Santa clara river + struck a telephone wire 2.6 sm from the rwy end. Witnesses saw acft fly level at about 8O ft AGL with normal power sounds prior to wire contact. Thewire strike caused…Sep 15, 1984 · N8279L · DestroyedNTSB FTW84IA400Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10-10 · Dfw Airport, TXThe acft experienced sepn of the rgt wing #3 leading edge slat while descending for an apch. An investigation revealed that on 7/5/84, the company performed a 'c' check inspection of the acft. At this time a rgt wing #3 leading edge slat retract aluminum…Sep 15, 1984 · N124AA · Minor damageNTSB CHI84LA391Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Medina, OHAcft had been fueled for aprx 4 hrs endurance. Two hrs into flt on IFR flt plan, plt descended to 3000 ft with intermittent visual ground contact. Shortly thereafter, with the acft about 10 mins from destination, the engine began to sputter. Plt stated he…Sep 15, 1984 · N3058F · Substantial damageNTSB SEA84FA228Accident · Serious injuriesField investigationFinal reportPiper PA-32-301T · Burley, IDWhile climbing after takeoff, the eng surged twice, then quit. The plt repositioned the fuel selector, checked that the electric fuel pump was 'on' & restarted the eng, then started to return to the departure arpt. However, about 1 min later, the eng lost…Sep 14, 1984 · N8160B · DestroyedNTSB LAX84LA479Accident · No injuriesLimited investigationFinal reportCessna 150M · Baker, CAThe acft was damaged in a forced landing after the engine quit. The acft made a stop during its x-country and fuel was added which did not fill the tanks. During the next days flt the plt noticed the fule gages indicated almost empty and headed for the arpt…Sep 14, 1984 · N9177U · DestroyedNTSB FTW84LA395Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Mandeville, LAThe acft made an emerg landing on the south lanes of the lake pontchatrane causeway bridge after encountering a loss of eng power. Examination of the acft fuel tanks revealed both tanks empty. Activation of the fuel tank drain valves & the fuel strainer…Sep 14, 1984 · N737LD · Substantial damageNTSB FTW84LA392Accident · No injuriesLimited investigationFinal reportCessna 140 · Liverpool, TXAt aprx 900 ft AGL the eng lost power and the plt executed a forced landing in the unimproved terrain. At touchdown the acft struck trees and a dirt enbankment nosing over inverted. Investigation revealed water in the gascolator as well as the left fuel tank.…Sep 13, 1984 · N89318 · DestroyedNTSB DEN84LA288Accident · Minor injuriesLimited investigationFinal reportBell 206B · Vernal, UTPlt stated that while on a heading of 050 degs (wind from 270 degs at 5 KTS) the acft began to shudder and veered to the right. Plt attempted remedial action but acft continued descending in a right spiral to ground contact. Examination of the helicopter did…Sep 12, 1984 · N1086Y · Substantial damageNTSB MKC84LA276Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Cedar Rapids, IAThe Balloon landed in a field and as wind drifted it, the envelope draped over a pwr line. The plt said his burner malfunctioned and caused the inaccurate landing. Another account was told later in which the plt switched to an empty propane tank for landing.…Sep 11, 1984 · N4066T · Substantial damageNTSB CHI84LA390Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Westfield, INThe acft collided with a powerline during landing. The plt said he 'found himself too low and gunned the engine to stay over the corn field but did not see the wires. Had never known they were there.'Sep 11, 1984 · N6761F · Substantial damageNTSB MKC84FA271Accident · Serious injuriesField investigationFinal reportCessna R182 · Ottumwa, IAThe acft entered IMC weather, the plt became disoriented & cruised without ATC navigational assistance after failing to make radio contact or file a flt plan. The non-instrument rated private plt flew until acft power was lost due to fuel exhaustion. The…Sep 9, 1984 · N756TN · Substantial damageNTSB LAX84FA473Accident · 3 fatalField investigationFinal reportCessna R172K · Independence, CAThe plt and two pax departed on a pleasure flt to look for a deer hunting area. Witnesses near the accident site stated that the saw the acft 'fly down the canyon on a northerly heading, reverse course and attempt to fly up the canyon.' They saw the acft…Sep 9, 1984 · N736XF · DestroyedNTSB FTW84LA384Accident · No injuriesLimited investigationFinal reportCessna 175 · Corsicana, TXThe plt stated the acft lost eng power & he attempted an emerg landing in a field. During the landing roll the acft collided with a wire fence due to darkness. The exact amount of fuel remaining in the acft was not determined during removal of the acft from…Sep 9, 1984 · N7483M · Substantial damageNTSB CHI84FA383Accident · 2 fatalField investigationFinal reportCessna 172N · Lisle, ILAt 0029 CDT the plt contacted a local ATCT stating that he was in IMC with 0 visibility requesting assistance and desiring to land at the closest arpt. The non-instrument rated plt was at 2,000 ft and was given a climb to 2,500 ft. the controller stated that…Sep 9, 1984 · N5289D · DestroyedNTSB SEA84FA223Accident · 2 fatalField investigationFinal reportCessna T210M · Skamania, WAA witness, located 3 mi se of the accident site, reported hearing the acft 'rev up to a scream followed by a crash that sounded like a miniature sonic boom.' The acft contacted the terrain in an uncontrolledd descent at an elev of 2100 ft MSL. Inspection of…Sep 8, 1984 · N191WB · DestroyedNTSB MIA84FA251Accident · 1 fatalField investigationFinal reportCessna 402C · Naples, FLShortly after takeoff, both engs lost power & a wheels up landing was made in an open field. The acft was destroyed by impact & fire. An investigation revealed that the acft had been refuel with jet-a fuel rather than 100 low lead avgas. The lineman had…Sep 8, 1984 · N89PB · DestroyedNTSB 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…Sep 8, 1984 · N460MC · No damageNTSB NYC84LA308Accident · No injuriesLimited investigationFinal reportBeech J35 · Hyannis, MAAprx 30 min after departure, according to the plt, the eng began running rough and stopped about 1 min later. The gear down forced landing was made in salt water aprx 6 mins from the dest arpt. Exam of the wreckage by FAA personnel revealed that the electric…Sep 7, 1984 · N12LH · Substantial damageNTSB DEN84LA286Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315B · Lyman, WYThe plt stated that engine RPM began deteriorating during a climb to cruise flt. He returned to the landing site where the RPM decayed to flt idle, an autorotation was entered and a hard landing resulted. The engine ran for 1 hour in a test cell after the…Sep 7, 1984 · N62338 · Substantial damageNTSB DEN84IA281Incident · No injuriesIncident investigationFinal reportMooney M20F · Saratoga, WYWhile in level cruise flt at 10500 ft, the plt heard a high-pitched whine that lasted for about 5 seconds. The engine then seized and the plt made a forced landing in mountainous foothills. During the landing roll, the landing gearcollapsed. Examination of…Sep 5, 1984 · N9121V · Minor damageNTSB NYC84FA295Accident · 1 fatalField investigationFinal reportAero Commander 680V · Bridgeport, CTThe acft descended into the water six & 1/2 miles sw of Bridgeport, CT. The acft was on an ILS apch to rwy 06. The acft was in communication with NY TRACON arrvl radar and on his initial call had indicated a desire for a clearance direct tobridgeport. A brief…Sep 4, 1984 · N100CT · DestroyedNTSB 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.Sep 4, 1984 · N8330G · Minor damageNTSB FTW84LA378Accident · Minor injuriesLimited investigationFinal reportBell 206B · Houma, LAThe helicopter was on a cargo, non scheduled air taxi flight when the plt smelled smoke. A precautionary landing was made on a beach after which the acft was destroyed by fire.Sep 4, 1984 · N4830 · DestroyedNTSB ANC84LA173Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Nushagak River, AKThe plt said he was flying along a River when the engine sputtered and quit. He located the nearest possible emergency landing site, switched tanks, applied carburetor heat, and pumped the throttle and primer. The engine did not restart. The wx was conducive…Sep 4, 1984 · N7690L · Substantial damageNTSB NYC84LA301Accident · No injuriesLimited investigationFinal reportCessna 152II · Washington, PAFuel exhaustion occurred 3.3 hrs into flt. Plt stated tanks appeared to be full on preflight but acft records showed 0.6 hrs flown on previous flight and acft not subsequently refueled. Aprx 1.5 gals found in tanks on post-mishap inspection.Sep 3, 1984 · N95035 · Substantial damageNTSB MIA84LA249Accident · No injuriesLimited investigationFinal reportAlon A2 · Vero Beach, FLThe acft collided with mail boxes during a forced landing after the engine failed. The plt said he lost all engine powerwhile climbing through 1800 ft AGL. Post crash inspection of the engine revealed that the gasket on the fuel transfer pump bowl had failed.…Sep 3, 1984 · N5609F · Substantial damageNTSB CHI84LA377Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Olney, ILThe a/c was flown in an airshow by the owner. After he landed the acft was shut down and refueled. The refueling and the preflight were done rapidly to allow the owners son, a student plt, to leave the airport ahead of the crowd. About 3 minutes after takeoff…Sep 3, 1984 · N6620H · Substantial damageNTSB SEA84LA218Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Las Vegas, NVThe instuctor pilot allowed the aircraft to approach mountainous terrain with insufficient altitude to counter wind conditions, reported at 35 mph. Downdrafts prevented climb to higher altitude before forcing a descent. On touchdown on a road, the left wing…Sep 2, 1984 · N49141 · DestroyedNTSB DEN84LA276Accident · Serious injuriesLimited investigationFinal reportMolino PIK-20 · Calhan, COThe glider struck a barbed wire fence while landing in a pasture. The plt said he encountered a downwash at the edge of a storm that resulted in an 800 fpm rate of descent and forced landing.Sep 2, 1984 · N858E · Substantial damageNTSB SEA84FA215Accident · 6 fatalField investigationFinal reportPiper PA-28-180 · The Dalles, ORN6499J departed The Dalles municipal arpt shortly after 0930 PDT on a flt to vancouver, WA. N4622T departed chenoweth airfield ( aprx 4 NM west of The Dalles) at about 0930 PDT on a flt to The Dalles municipal arpt. A witness who observed both acft before the…Sep 1, 1984 · N6499J · 2 aircraft · DestroyedNTSB FTW84LA377Accident · No injuriesLimited investigationFinal reportCessna 177B · Texas City, TXAccording to the plt, during the pre-flt inspection the fuel tanks were checked by dipping his fingers into the tanks to determine how much fuel remained. Neither tank was full but the plt estimated that sufficient fuel remained for the flt. Above the fuel…Sep 1, 1984 · N19953 · Substantial damageNTSB ATL84FA277Accident · Serious injuriesField investigationFinal reportBell 222 · Knoxville, TNThe helicopter was in a hover when a rt pedal turn was initiated and a climb attempted. Plt stated, 'I was unable to climb, and the aircraft began to lose rotor RPM. I increased power to 100% mrtq. The acft was settling.' Unable to sustain flt, a landing was…Sep 1, 1984 · N22299 · DestroyedNTSB ANC84LA158Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Kenai, AKThe acft was damaged in an off arpt precautionary landing atter the engine began vibrating with the oil temperature in the red. The plt said he turned off the ELT to conserve the battery.Sep 1, 1984 · N9712H · Substantial damageNTSB ATL84FA275Accident · Serious injuriesField investigationFinal reportCessna TR182 · Wilmington, NCThe power loss occurred in cruise at 10,000 ft. at 0903 EDT the pilot notified Wilmington approach control that he had a 'rough engine' and requested vectors to Wilmington. Approach control responded with heading information for the back course approach and a…Aug 31, 1984 · N5071R · DestroyedNTSB ANC84LA150Accident · No injuriesLimited investigationFinal reportMaule M-6 · Kiana, AKThe acft made a forced landing in the kobuk sand dunes after the engine quit during cruise flt. The plt reported that the engine quit, sputtered once, picked up RPM and then quit completely. The prop windmilled until ground contact. In attempting to restart,…Aug 31, 1984 · N56490 · Substantial damageNTSB LAX84FJA02Accident · Serious injuriesFinal reportPiper PA-28-140 · Wailuku Maui, HIThe acft collided with rising terrain during a pleasure flt around Hawaii. The plt turned from the shorline inland to look at a waterfall. He started a climb from 500 ft to clear the 2000 ft level. The plt does not remember any of the accident sequence.Aug 30, 1984 · N835FC · DestroyedNTSB LAX84FA504Accident · 4 fatalField investigationFinal reportPiper PA-32R-301T · Tucson, AZcontrolled flight into terrain that resulted from the pilot's failure to ensure a safe VFR altitude. The dark night, which restricted the pilot's view of terrain, was a factor in this accident.Aug 30, 1984 · N4575L · DestroyedNTSB CHI84LA372Accident · No injuriesLimited investigationFinal reportCessna 120 · Hopedale, ILThe acft nosed over during a forced landing in a corn field after the engine quit. The plt said he was operating on the left tank and when the engine sputtered he realized what was wrong and even though he immediately switched tanks the engine quit and did…Aug 30, 1984 · N76490 · Substantial damageNTSB ATL84LA273Accident · No injuriesLimited investigationFinal reportRockwell S2R · Shellman, GAPlt was en route to airstrip after spray run when he smelled smoke. Shortly thereafter the engine surged and lost power. Plt executed a forced landing in a corn field as flames from engine area became visible. Acft damaged by post-landing fire. Investigation…Aug 30, 1984 · N7771V · DestroyedNTSB MKC84FA264Accident · 2 fatalField investigationFinal reportCessna 177B · Bloomfield, MON30755, collided with a radio tower guy wire and crashed three miles east of Bloomfield, MO, while on a business flight. Instrument meteorological conditons prevailed at the time of the accident. Witness stated that the low clouds obscured the top of the 80…Aug 29, 1984 · N30755 · DestroyedNTSB CHI84LA371Accident · No injuriesLimited investigationFinal reportCessna 210M · Howell, MIThe plt stated that about 10 min after takeoff, the fuel flow fluctuated & slowly went to zero. He turned the aux fuel pump on, increased the mixture to rich & repositioned the fuel selector to another tank, but to no avail. The plt made a forced landing in a…Aug 29, 1984 · N732RJ · DestroyedNTSB ANC84LA147Accident · No injuriesLimited investigationFinal reportCessna 207A · Sleetmute, AKWhile cruising at 1100 ft AGL the eng failed without warning. Efforts to restart were unsuccessful. A forced landing was made into wooded terrain and the acft nosed over during the roll. Eng exam revealed that the crankshaft was broken through the crank cheek…Aug 28, 1984 · N7325U · Substantial damage