OpenAirDocs.org

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 SEA84LA079Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Idaho Falls, IDThe student plt was on a solo x-country flt & had refueled at twin Falls, ID. When she took off, both fuel tanks were full. While descending thru about 6000 ft, near the destination arpt, the eng sputtered & quit running. The student enriched the mixture,…Apr 4, 1984 · N1436X · Substantial damageNTSB LAX84LA242Accident · No injuriesLimited investigationFinal reportCessna 210 · Tucson, AZThe acft had a hydraulic line failure during an attempt to lower the landing gear. The hydraulic fluid was lost and a gear up landing was made. The retaining ring of the main door actuator had failed allowing the piston to pop out of the actuator. There was a…Apr 4, 1984 · N9889M · Substantial damageNTSB MIA84FU003Accident · 1 fatalFinal reportPterodactyl Ascender II · Palm Bay, FLThe plts of 2 ultralight vehicles were accompanying each other & were flying west at 500 ft AGL in calm air when an acft crossed ahead of their flt path. The acft was estimate to be flying at about 140 KTS & aprx 40 ft above the ultralights' alt. The…Apr 1, 1984 · UNREG · DestroyedNTSB FTW84LA179Accident · Minor injuriesLimited investigationFinal reportCessna U206G · Lake Charles, LAThe acft hit a tree and a ditch during a forced landing on a road after the engine lost power. Examination of the engineafter the accident revealed that the throttle rod had disconnected from the throttle control arm at the bolt hole. The hole had worn…Apr 1, 1984 · N7383N · Substantial damageNTSB FTW84FA180Accident · 4 fatalField investigationFinal reportCessna 210-5(205) · Beaumont, TXThe acft was flown into IMC wx after the flt had been advised by the wx service that VFR flt was barely feasible. No wx briefing by FAA was recorded & no flt plan was filed. The accident occurred during the hrs of darkness. A witness near the accident site…Apr 1, 1984 · N8150Z · DestroyedNTSB DEN84FA122Accident · Serious injuriesField investigationFinal reportCessna 414A · Douglas, WYDuring an approach for a downwind landing, the acft stalled & impacted the ground 192 ft short of rwy 28. The plane had encountered icing conditions during flt & ice was still adhering to the acft as the plt made an approach for landing. Instrument conditions…Apr 1, 1984 · N414EM · Substantial damageNTSB MKC84FA115Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Garden City, KSThe plt departed kendallville, IN, at about 1800 EST & made a refueling stop at topeka, KS. At topeka, he obtained a wx briefing for a flt to pueblo, CO, his intended destination, & was advised of marginal VFR to IFR conditions on his proposed route. He then…Mar 31, 1984 · N40846 · DestroyedNTSB FTW84LA187Accident · No injuriesLimited investigationFinal reportOwen Robert R Quickie 2 · Ponder, TXThe plt reported that he had a loss or power & the acft flipped over during an emergency landing in a wheat field. The acft owner stated the loss of power was because of fuel mismanagement.Mar 31, 1984 · N419Q · Substantial damageNTSB SEA84LA075Accident · No injuriesLimited investigationFinal reportCessna T210N · Seaside, ORThe acft nosed over during a forced landing in a soft field after a loss of power. The plt said that while the acft was descending thru about 6000 ft MSL, he ran the left fuel tank dry before switching tanks. His attempt to restart the engine, using the right…Mar 30, 1984 · N7972N · Substantial damageNTSB ATL84IA135Incident · No injuriesIncident investigationFinal reportPiper PA-28R-200 · Clayton, NCDuring flt, the plt & a passenger noted a loss of eng power accompanied by a metallic sound. Subsequently, a wheels-up forced landing was made in a plowed field. An eng teardown revealed that the crankshaft, p/n 54297-1, had failed from fatigue. A…Mar 30, 1984 · N4999S · Minor damageNTSB LAX84LA236Accident · No injuriesLimited investigationFinal reportCessna 152 · Escalon, CAThe acft was damaged during a forced landing. The acft collided with trees and nosed down. Post accident examination of the acft showed 1 gallon of fuel on board the acft. The flt had lasted 3 and 1/3 hours. The endurance of a Cessna 152 under the stated…Mar 29, 1984 · N757RU · Substantial damageNTSB LAX84LA233Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Novato, CAThe acft was ditched in san pablo bay following a power loss during x-country cruise flt. The plt admitted 'to running out of fuel.'Mar 29, 1984 · N82858 · Substantial damageNTSB FTW84LA188Accident · No injuriesLimited investigationFinal reportCessna 150L · New Boston, TXThe non-rated plt/owner was flying at night when he noticed that the fuel quanity was low. About 15 mins later, the eng lost power from fuel exhaustion. During an emergency night landing, the acft struck several tree stumps & was damaged. Police officers…Mar 29, 1984 · N11273 · Substantial damageNTSB DEN84LA112Accident · No injuriesLimited investigationFinal reportCessna 175 · Ogden, UTAfter takeoff, the eng began to smoke & lose power. During a forced landing in a muddy plowed field, the acft nosed over. A compression check was accomplished & the #5 cylinder was found to have zero compression. The cylinder was removed & found to be cracked…Mar 29, 1984 · N7270M · Substantial damageNTSB ATL84IA134Incident · No injuriesIncident investigationFinal reportBeech C90 · Herndon, VAThe acft entered an uncommanded dive at about 11,000 ft MSL, with recovery made below 2,000 ft MSL. Investigation revealed that during the descent, in order to accomodate other air traffic, the plt exceeded vne speeds. Shortly, thereafter the elevator trim…Mar 29, 1984 · N66KA · Minor damageNTSB ATL84FLT07Accident · No injuriesFinal reportWeatherly 201C · South Fulton, TNFive miles after takeoff the acft engine began sputtering and losing power. The plt dumped his load and still could not maintain flight. The acft could not be stopped before colliding with fence and trees during a downwind landing on wet pasture grass.…Mar 29, 1984 · N1296W · Substantial damageNTSB MIA84FA122Accident · 4 fatalField investigationFinal reportCessna 402C · Mineral Springs, FLThe acft collided with trees and the ground during flt in adverse weather. There is no record of the plt receiving a pre-flt briefing and no flt plan was filed. Witnesses heard an acft flying low followed by a loud thud. About 16 mi north at sarasota, FL, the…Mar 27, 1984 · N620AC · DestroyedNTSB FTW84LA178Accident · No injuriesLimited investigationFinal reportPiper PA-32-301T · Haskell, TXThe plt received a wx briefing and said, 'today was not the day to go', but later went. En route weather encouraged him to land at an arpt with a 1600 ft rwy with winds of 30 KTS gusting to 50 KTS, according to a witness. The plt landedwith no flaps and…Mar 27, 1984 · N8194E · Substantial damageNTSB FTW84LA174Accident · No injuriesLimited investigationFinal reportCessna 150M · Bryan, TXThe eng lost power from fuel exhaustion before the plt reached his final destination. During a subsequent emergency landing at night the acft collided with a fence as it was touching down. The plt stated that he estimated there was 1.5 gals of usable fuel on…Mar 26, 1984 · N6494K · DestroyedNTSB CHI84LA140Accident · No injuriesLimited investigationFinal reportCessna 182L · New Hudson, MIShortly after leveling off at 3000 ft the cabin of the acft filled with smoke and the acft lost all oil pressure. Shortly after this the engine quit. During the forced landing in a corn field the acft nosed over. During a post accident investigation it was…Mar 26, 1984 · N42855 · Substantial damageNTSB NYC84LA116Accident · No injuriesLimited investigationFinal reportCessna 336 · Hogansburg, NYThe acft nosed down in a soggy muddy field during a forced landing. The plt reported a power loss on the rear eng and when attempts to restart were unsuccessful made the forced landing into a soggy muddy field.Mar 24, 1984 · N1711Z · Substantial damageNTSB DEN84FTG01Accident · No injuriesFinal reportLee M. Brown Taterbug SB-1 · Sawyer, NDThe plt switched from main tank to aux tank, & about 10 minutes later, the eng began losing power switching back to the main tank did not help. The engine continued running but at greatly reduced power. A forced landing was made in a frozen stubble field. The…Mar 22, 1984 · N9026T · Substantial damageNTSB MKC84FA106Accident · 2 fatalField investigationFinal reportBeech B36 · Webb City, MOThe plt was advised by springfield tower that icing conditions existed along his proposed route of flt. However, he elected to takeoff, & about 4 min later, the plt advised that he had encountered rime ice. He continued the flt to joplin, picking up more ice…Mar 20, 1984 · N6665X · DestroyedNTSB ATL84LA125Accident · Serious injuriesLimited investigationFinal reportHughes 269 · Supply, NCThe plt and passg stated that as the flt approached Supply, NC, the wx conditions deterioriated and the helicopter encountered a fog bank. The passg recalled that the visibility reduced completely and visual contact with the ground was lost. The plt decided…Mar 20, 1984 · N8782F · Substantial damageNTSB MKC84FA110Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Gasconade, MOThe plt landed at an arpt where, by his own description, the wx was near zero in rain. He then received 2 wx briefings. During the 1st briefing the plt indicated that he could make the flt IFR. The plt was advised of a SIGMET for severe icing conditions at…Mar 19, 1984 · N30667 · DestroyedNTSB MIA84LA118Accident · Serious injuriesLimited investigationFinal reportCessna 310C · Key West, FLWhile en route, the plt had switched from the main tanks to the aux tanks, then back to the main tanks. About 10 min later, both engs lost power. He was able to restart the right eng, but it lost power again. Subsequently, he ditched the acft at sea. Both…Mar 19, 1984 · N12T · DestroyedNTSB LAX84LA223Accident · No injuriesLimited investigationFinal reportCessna 152 · Palo Alto, CAThe acft was landed on a highway during a forced landing following a power loss. About 1 quart of fuel was drained from the acft after the accident.Mar 19, 1984 · N68159 · Substantial damageNTSB ATL84LA124Accident · No injuriesLimited investigationFinal reportCessna 172 · Flemingburg, KYAccording to the plt, the flt was about 12 miles from the airport at 2000 ft when the engine failed. The plt establishedan emerg descent to an open field, ran through a small pond and flipped inverted. Investigation revealed wx conditions conducive to…Mar 19, 1984 · N6870X · Substantial damageNTSB ATL84FKG07Accident · No injuriesFinal reportCessna 172P · Atlanta, GAThe plt was having trouble with his radios, electrical system, fuel/eng gages & ammeter, so he turned off his electrical equipment & prepared to make an emergency landing. Because he was afraid of fuel exhaustion, his spacing behind another acft in the…Mar 19, 1984 · N53655 · Substantial damageNTSB MIA84LA115Accident · Minor injuriesLimited investigationFinal reportBengtson Swallow B · Belleview, FLThe homebuilt acft crashed after experiencing an eng failure in cruise flight. The plt reported that he turned the acft to avoid cows in a pasture and the wing hit the ground. The reason for eng failure was not determined.Mar 18, 1984 · N3261E · Substantial damageNTSB LAX84LA222Accident · Serious injuriesLimited investigationFinal reportVari EZE · Rancho, CAThe acft made a forced landing and collided with a ditch after propeller failure during climb after takeoff. The plt hadmade his propeller of fiberglass instead of recommended wood. This was the first flt with this propeller.Mar 17, 1984 · N3VE · Substantial damageNTSB CHI84LA132Accident · Minor injuriesLimited investigationFinal reportCessna 337A · Genesee, WIThe acft made a forced landing after the engine lost power. The acft was inspected after the accident and found to contain no usable fuel. When the fuel was drained from the auxiliary tanks, the fuel quantity indicators showed five gallons in each tank.Mar 17, 1984 · N6271F · Substantial damageNTSB ATL84LKG06Accident · No injuriesFinal reportHomebuilt Dragon FLY 294 · Franklin, GAThe Homebuilt acft with 3 persons aboard lost its propeller after the crankshaft failed during cruise. A forced landing was executed on a state highway. The plt said he lost directional control at about 30 mph and contacted a ditch and two fence posts. The…Mar 16, 1984 · N83WH · Substantial damageNTSB SEA84FA071Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201T · Humphrey, IDWhile on a x-country flt, the acft entered an area of rising terrain & blowing snow & the plt initiated a turn to reverse direction. During the turn, he encountered reduced visibility & the acft collided with the top of a knoll on snow covered rolling…Mar 15, 1984 · N29033 · DestroyedNTSB MKC84LA102Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Ulysses, KSThe plt made an autorotative precautionary landing after feeling vibrations in the anti-torque pedals. The acft was turned into the wind but landed hard in a field. The plt upon exiting the acft found the anti-torque rotor and gearbox missing. They were found…Mar 15, 1984 · N1021Y · Substantial damageNTSB MIA84LA111Accident · No injuriesLimited investigationFinal reportCessna U206F · Arecibo, PRThe plt related that the flt dept st croix with 28 gal of fuel aboard. In the vicinity of arecilo, PR the eng lost power. Examination of the fuel tanks showed more than 8 gal of fuel but 'the fuel bladder trapped the fuel from flowing into the engine.Mar 15, 1984 · N51032 · Substantial damageNTSB MIA84LA110Accident · No injuriesLimited investigationFinal reportShark BI-PLANE · Winter Garden, FLThe acft crashed during a forced landing after the engine quit. The plt said the power loss was due to fuel exaustion. He stated that when the tanks were full when he departed savannah and a siphon effect might have been created accountingfor the loss of…Mar 15, 1984 · N67SC · Substantial damageNTSB FTW84LA168Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Houston, TXThe non-instrument rated plt departed dallas, TX, and was on a VFR flight plan to Houston gulf port arpt. Unable to landthere due to wx, the plt requested ATC vectors to Houston intercontinental (iah). Iah ATC gave the plt vectors for an ILS apch to rwy 08.…Mar 14, 1984 · N54647 · Substantial damageNTSB DEN84FA106Accident · Serious injuriesField investigationFinal reportAerospatiale SA-316B · Story, WYOn the day prior to the accident, the plt noted that the fuel gage indicated 30 to 35 gal remaining. He added 40 gal & made a flt of about 15 min. On the next day, he noted that the gage indicated about 40 gal of fuel remaining. The reported fuel consumption…Mar 13, 1984 · N8655 · Substantial damageNTSB SEA84FA068Accident · 6 fatalField investigationFinal reportPiper PA-28RT-201 · Hood River, ORAfter crossing the dalles at 12,500 ft MSL, the plt reported to ARTCC he was entering solid clouds. He subsequently reported level at 3,000 ft MSL followed by 'if ah we can't stay VFR we'll go ahead and climb up to about five and file IFR.' The acft was…Mar 12, 1984 · N8301T · DestroyedNTSB MIA84LA107Accident · No injuriesLimited investigationFinal reportCessna 210N · Lacrosse, FLThe plt reported that the right fuel tank went dry when the fuel gage indicated it had 6 gal remaining. He switched fuel tanks, & shortly thereafter, the left tank emptied when the gage indicated it had 13 gal remaining. He tried to land in a pasture, but was…Mar 12, 1984 · N6006P · Substantial damageNTSB MIA84LA105Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Ocala, FLWhile on a flt to lakeland, FL, the plt elected to divert to Ocala, FL, when his fuel gages indicated that each fuel tank was about 1/4 full. However, before landing, the eng lost power. The plt selected an open field for an emergency landing, but stated he…Mar 12, 1984 · N704WZ · Substantial damageNTSB MIA84FA104Accident · 1 fatalField investigationFinal reportGross Benson B-8M · Sanford, FLThe student plt & the plts of 2 other benson gyrocopters took off from a private strip & proceeded to fly in a loose formation. The plts of the other 2 gyrocopters did not witness the accident, but noticed that 1 of the 3 was missing. Witnesses on the ground…Mar 12, 1984 · N3154A · DestroyedNTSB FTW84LA161Accident · No injuriesLimited investigationFinal reportAmerican AA-1A · Smithville, TXThe pvt non-instrument plt received two wx briefings for his route of flt from madison, MS, to lufkin, TX, to college station, TX, to san antonio, TX. The last briefing from college station fss informed the plt that marginal VFR conditions exsisted along the…Mar 12, 1984 · N9460L · Substantial damageNTSB DEN84FA223Accident · 3 fatalField investigationFinal reportCessna 310H · Questa, NMThe acft collided with rising terrain at the 12500 ft level. The summit was about 200 ft above the crash site. A friend of the plt was interviewed by the iic from NTSB. This friend was the host of the 3 accident victims for the weekend at his gunnison ranch.…Mar 12, 1984 · N1111Q · DestroyedNTSB FTW84LA167Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Kingsville, TXWhile flying over a water basin the plt and pax both stated they felt an updraft. They said that they next remember climbing out of the acft which was inverted and under water.Mar 11, 1984 · N3337J · DestroyedNTSB MIA84LA102Accident · No injuriesLimited investigationFinal reportPiper J-3 · Indian Beach, FLDuring a banner towing operation, the plt descended from 1200 ft to 500 to tow over water near a Beach. When he advanced the throttle to level off there was no response to throttle movement. The eng continued operating at about 1500 RPM. Subsequently, he…Mar 10, 1984 · N88168 · Substantial damageNTSB LAX84LA213Accident · No injuriesLimited investigationFinal reportCessna 172M · Lebec, CAIn a preliminary oral statement, the plt said that they encountered an unforcasted overcast & rising mountainous terrain. Later, she stated they were trying to maintain VFR flt in mountains with scattered clouds in the area; then when they were initiating a…Mar 10, 1984 · N880LS · DestroyedNTSB FTW84IA160Incident · No injuriesIncident investigationFinal reportBoeing 727-23 · Dfw Airport, TXThe crew stated that while at FL370, the cabin alt began to climb. An emergency descent was initiated & after landing the passengers deplaned in a normal manner. Investigation revealed a 9X18' hole in the fuselage about 3 ft foward of the acft cargo door.…Mar 10, 1984 · N1993 · Minor damageNTSB NYC84FA189Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · South Paris, MEBefore the accident, the plt was last seen on 3/9/84 at 1530 EST & had not expressed any intentions of flying. At 1730, his car was located at the arpt & his acft, which had been kept there, was gone. The acft was found on 5/24/84 where it had crashed on…Mar 9, 1984 · N95040 · Destroyed