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 DEN82FTE24Accident · Serious injuriesFinal reportCessna 172M · Monarch Pass, COThe acft crashed in mountainous terrain at approximately 10,950 ft MSL 22 minutes after takeoff. The temperature at the accident site was about 50 deg f. rate of climb at 10,000 ft MSL & 50 deg f is about 251 fpm at 76 mph.Aug 27, 1982 · N3LT · DestroyedNTSB DEN82FA175Accident · Serious injuriesField investigationFinal reportConvair 340 · Del Norte, COAccording to the flight crew, VMC had deteriorated into IMC over the mountains. After entering IFR conditions the acft impacted a mountain ridge.Aug 25, 1982 · N477KW · Substantial damageNTSB ANC82DAG60Accident · 3 fatalFinal reportPiper PA-28R · Dillingham, AKPilot collided with mountainous terrain at the 1400 foot level. He proposed flight on V-452 which does not exist in that area. V-462 would have been appropriate but his position did not coincide with that route. He was on a VFR flight plan. Twilight ended…Aug 24, 1982 · N5936V · DestroyedNTSB MKC82FCJ05Accident · 1 fatalFinal reportTaylorcraft BC-12-65 · Max, NEPilot flying cross-country at low altitude collided with wires and crashed. No malfunctions of aircraft observed.Aug 23, 1982 · N29639 · DestroyedNTSB MKC82DA155Accident · Minor injuriesFinal reportAerospatiale AS-355F · Cedar Rapids, IAThe aircrew lost control of the helicopter while making a pedal turn at 800 to 900 AGL. After 5 rotations, the helicopter impacted the ground, bounced, rolled and fell on its right side. Switches were cut and the crew made an exit. An investigation revealed…Aug 23, 1982 · N57807 · Substantial damageNTSB LAX82DA311Accident · No injuriesFinal reportBell 206B · Grand Canyon, AZDuring flight at about 300 ft AGL, there was an abrupt loss of engine power. The pilot descended at 60 to 70 KTS, then made an autorotative landing on a dirt road. During the landing, the main rotor blades struck the tail boom. An engine teardown revealed…Aug 22, 1982 · N83037 · Substantial damageNTSB CHI82DA320Accident · No injuriesFinal reportPiper PA-22 · Houston, MNThe pilot obtained a weather briefing before departing on a cross-country flight from west bend, WI to waseca, MN. Reportedly, the ceiling was 2500 to 3000 ft or better (as briefed) until after crossing the Mississippi river. The weather then began to…Aug 22, 1982 · N8601C · Substantial damageNTSB ATL82DA242Accident · Minor injuriesFinal reportCessna 210M · Holly Springs, MSThe pilot, an aircraft mechanic, made a night forced landing on a highway near Holly Springs, MS. During the landing roll, the right wing contacted two signposts which caused substantial damage to the aircraft. The aircraft continued 520 feet before leaving…Aug 22, 1982 · N7320M · Substantial damageNTSB NYC82DA206Accident · No injuriesFinal reportBell 206L-1 · Ho Ho Kus, NJWhile in straight and level flight at 1000 ft, the pilot heard a "pop" in the engine area. He noted that the turbine outlet temperature (tot) began an immediate rise to the high yellow area initially, the power was reduced to 50% torque and the tot returned…Aug 21, 1982 · N57480 · Substantial damageNTSB LAX82DA314Accident · No injuriesFinal reportAeronca 65-TC · Mira Loma, CAThe pilot reported that during flight, he ran out of fuel and the plane was damaged during a forced landing. An examination verified there was no preimpact, structural engine failure. Only residual fuel was found in the fuel filter, carburetor, header tank…Aug 21, 1982 · N29473 · Substantial damageNTSB FTW82DA342Accident · No injuriesFinal reportBell 206B · Port Mansfield, TXThe helicopter was being ferried to shore from an oil rig when the tailrotor gear box failed and separated from the aircraft. The pilot autorotated to the water. Upon water contact the helicopter rolled over. The pilot had called his skipper on the radio as…Aug 21, 1982 · N208EH · Substantial damageNTSB DEN82DA172Accident · No injuriesFinal reportBeech C24R · Palisade, COAccording to the pilot, the flight departed the arapahoe airport with the fuel tanks half full because of passenger load factor. As the aircraft approached within 45 miles of the destination airport, the pilot switched from the right fuel tank to the left…Aug 21, 1982 · N18906 · Substantial damageNTSB CHI82DA324Accident · No injuriesFinal reportPiper PA-28-160 · Knox, INThe pilot departed on a flight from lake village to Knox, IN. While en route, he landed to refuel at rensselaer, IN. During the flight from rensselaer to Knox, the engine began loosing power when he was about 5 mi from the destination. When the pilot realized…Aug 21, 1982 · N5796W · Substantial damageNTSB ATL82DA244Accident · No injuriesFinal reportPiper PA-28-140 · Lexington, MSAbout 6 minutes after takeoff, there was a partial loss of engine power when the mixture lever was retarded to lean the engine for cruise. The mixture was quickly advanced, but the engine continued to lose power. The pilot turned back toward the departure…Aug 21, 1982 · N5044T · Substantial damageNTSB MKC82DA150Accident · No injuriesFinal reportEagle DW-1 · Holdrege, NEThe aircraft nosed over during a forced landing after the engine stopped from fuel exhaustion. The pilot had finished spraying and was on his way to refuel when the loss of power occurred. He picked out a short field for landing and the tailwheel aircraft…Aug 20, 1982 · N8809J · Substantial damageNTSB SEA82DA146Accident · No injuriesFinal reportAuster A.O.P.6 · Toledo, WAAircraft lost wooden propeller during cruise. Aircraft was forced to land on a highway. During approach aircraft wing hit a light pole and yawed. During touchdown it bounced hard on left main landing gear which collapsed.Aug 19, 1982 · N38220 · Substantial damageNTSB MKC82DA147Accident · Minor injuriesFinal reportPiper PA-32-260 · Manhattan, KSThe pilot departed Manhattan, KS and flew to minneapolis, MN. At minneapolis, he refueled with 10 gal added to the left main tank. He said both main tanks were full, the right auxiliary tank was empty, and he estimated there was 5 gal in the left auxiliary…Aug 19, 1982 · N3436W · Substantial damageNTSB LAX82FUG15Accident · No injuriesFinal reportPiper PA-34-200T · Fontana, CAApproximately 5 hrs after takeoff the plt contacted ontario tower & requested radar vectors to the arpt because he had an eng out. After switching to approach control the plt began receiving vectors to the arpt. At 0209 the plt advised a/c that he ran out of…Aug 19, 1982 · N24MF · Substantial damageNTSB MIA82DA172Accident · No injuriesFinal reportHelio H-395 · Near St. Marks, FLDuring flight, the engine began missing and started vibrating excessively. The pilot force landed in a swamp with sawgrass and the aircraft flipped inverted. The #3 exhaust push rod was missing and was not found, but debris from the push rod shroud tube was…Aug 17, 1982 · N4197D · Substantial damageNTSB NYC82DA201Accident · No injuriesFinal reportErcoupe 415C · Gardner, MAThe engine lost power during flight and the pilot engaged the starter with the prop windmilling. The starter gear was found shattered and the starter gear teeth were scattered through various parts of the engine. No reason was found for the original engine…Aug 16, 1982 · N3366H · Substantial damageNTSB MIA82DA171Accident · No injuriesFinal reportEngineering & Research 415-C · Clearwater, FLThe pilot reported that after he took off on runway 35R, he turned out to the northeast. He reported that when he reached 900 ft, the engine stalled and restarted. He notified the tower and was cleared to land on runway 09. A witness reported observing the…Aug 16, 1982 · N99987 · Substantial damageNTSB MIA82DA170Accident · Minor injuriesFinal reportCessna 210 · Gainesville, FLThe pilot ran out of fuel on the last leg of a flight that involved 4 enroute stops. He stated that the fuel gauge showed about 2 hours of fuel when he departed Gainesville. The forced landing occurred about 1 mile east of the airport.Aug 16, 1982 · YS325 · Substantial damageNTSB FTW82IA331Incident · Minor injuriesIncident investigationFinal reportCessna 421B · El Paso, TXN1969J is a 1974 Cessna 421B modified by a riley conversion kit. The aircraft was descending through about 1900 ft MSL when, without previous warning, it yawed left. The pilot reported that the acft then immediately yawed severely to the right and began to…Aug 16, 1982 · N1969J · Minor damageNTSB DEN82DA174Accident · No injuriesFinal reportPiper PA-28RT-201T · 15mi. Ne Of Chr, COWhile en route, the engine began to lose power, and subsequently, there was a total power loss. The pilot landed in a small clearing, but during the landing roll, the right main gear hit a large rock. The gear failed and punctured a hole in the fuel tank. The…Aug 16, 1982 · N3072Z · DestroyedNTSB DEN82DA173Accident · No injuriesFinal reportCessna A188B · Britton, SDWhen the pilot departed to spray the last field for that day, he estimated that he had 19 to 20 gallons of fuel remaining. He figured it would take about 16 to 17 gallons of fuel to complete the job. About 1 hr later, as he was returning to land, the engine…Aug 16, 1982 · N91919 · Substantial damageNTSB DEN82DA163Accident · No injuriesFinal reportPiper PA-28-140 · 5nm Colorado Sp, COThe pilot on a cross-country landed after 2.4 hrs. No refueling crew was found so he measured 15 gals into each tank forabout 25 gals each. The next leg was 3.5 hours. At 3.3 hrs both tanks were out of useable fuel 6 miles from the destination. A forced…Aug 16, 1982 · N2292T · Substantial damageNTSB LAX82DA304Accident · Serious injuriesFinal reportMenees LP-49MS · Sparks, NVThe plt stated he released from the tow plane at 1,200 ft AGL in a 200 fpm lift. Almost immediately he encountered a 1,000 fpm sink & immediately entered the pattern for a landing. He was unable to arrest the sink rate & the acft landed hard breaking off the…Aug 15, 1982 · N1524 · DestroyedNTSB DEN82DA162Accident · No injuriesFinal reportCessna 172XP · 3 Miles Sw Of D, COThe aircraft was cruising at 11000 ft when the engine began to run rough. Attempts to enrich and then lean the mixture, throttle adjustments and switching the fuel tanks did not alleviate the engine roughness. The engine then lost all power. Another plt…Aug 15, 1982 · N736JX · DestroyedNTSB FTW82FQD12Accident · Serious injuriesFinal reportLuscombe 8E · Timberon, NMPlt stated he could not gain sufficient altitude to clear terrain. A witness observed the acft at approximately 150-200 ft AGL, well below the top of the canyon.Aug 14, 1982 · N2996K · DestroyedNTSB ATL82DA236Accident · No injuriesFinal reportCessna 150L · Jacksonville, NCThe pilot reported that the engine lost power while the fuel gauges were indicating at or near 1/4 full. Reportedly, the power loss occurred when the aircraft ran out of fuel. The aircraft was substantially damaged when it was landed in a corn field.Aug 14, 1982 · N5301Q · Substantial damageNTSB ANC82IA074Incident · No injuriesIncident investigationFinal reportCessna 207 · Near Anvik, AKDuring a deadheading flight back to his operations base, the pilot experienced an inflight fire and smoke in the cockpit. After he extinguished the fire and evacuated the smoke, a normal landing was made. Examination of the aircraft revealed that the…Aug 14, 1982 · N1717U · Minor damageNTSB SEA82FA142Accident · 1 fatalField investigationFinal reportPiper PA32-300 · Shelton, WAWitnesses 3 miles west of the arpt heard the sounds of the departing acft. As the acft proceeded northbound, sounds of eng power cycling were heard, followed by increasing noise levels as if the acft was returning to the field. At the sudden sound of high…Aug 13, 1982 · N9732K · DestroyedNTSB NYC82FHD18Accident · Serious injuriesFinal reportBeech E18S · Lakewood, NJPrior to flt the spark plugs on both engs were replaced due to minor eng vibration & the landing gear retract system wiring repaired due to the gear not retracting electrically on a prior occasion. After takeoff the gear would not retract electrically & the…Aug 13, 1982 · N380MA · DestroyedNTSB DEN82FTE23Accident · Serious injuriesFinal reportHughes 369D · Meredith, COThe pilot reported that during flight, the engine lost power while he was over steep wooded terrain. He spotted a clearing, but had to use residual RPM to clear trees during the approach. Subsequently, the helicopter landed hard and was substantially damaged.…Aug 13, 1982 · N5014F · Substantial damageNTSB MKC82DA145Accident · No injuriesFinal reportCessna 150J · Conway Springs, KSThe aircraft engine lost power during landing and the aircraft hit trees 100 yards short of the runway. Post-accident examination disclosed low compression on 3 cylinders and none on number four cylinder. The engine had been low on RPM since the beginning of…Aug 12, 1982 · N61142 · DestroyedNTSB SEA82DA140Accident · Minor injuriesFinal reportCondor 150L · 16nm No. Of Pie, IDThe eng failed enroute & while landing on a logging road the right wing contacted vegetation causing the acft to swerve & come to rest nose low. The eng had been inspected 1 hr previous to the accident & had 8 hrs of operating time since new at the…Aug 10, 1982 · N10517 · DestroyedNTSB MIA82DA169Accident · No injuriesFinal reportCessna 172 · Moore Haven, FLThe student pilot was on the return portion of a cross-country flight when she deviated to avoid weather. She tried to circumnavigate around lake okeechobee, but in her opinion, the weather began to close in with the visibility decreasing in heavy rain. She…Aug 10, 1982 · N68266 · Substantial damageNTSB SEA82DA139Accident · No injuriesFinal reportEnstrom F280 · Seattle, WAHelicopter made an emergency forced landing after power loss aircraft landed heavily in loose dirt and damaged skids and rotors. Post-accident exam found "throttle activating arm was improperly engaged to throttle stop."Aug 9, 1982 · N267Q · Substantial damageNTSB SEA82DA138Accident · Minor injuriesFinal reportCessna 150 · Forks, WAThe student pilot, on a night cross country flight, became lost, disoriented and low on fuel. He established radio communications with seattle center and was radar vectored to Forks, WA, airport. The pilot was not able to see the runway lights or the…Aug 9, 1982 · N9368U · DestroyedNTSB DEN82DA159Accident · No injuriesFinal reportAerospatiale SA-315B · Afton, WYEn route during a seismic operation a loud screeching, grinding sound was heard. The pilot reported the aircraft seemed to buck. A long flame emitting from the aft end of the aircraft was observed by witnesses. The engine ceased and the aircraft crashed into…Aug 9, 1982 · N10067 · DestroyedNTSB ATL82FKW09Accident · 1 fatalFinal reportGrumman AA-1 · Lafayette, TNThe acft crashed while apparently trying to land in a field drg IFR conditions after loss of a top eng cowling. The plt had just made a may day transmission that he had lost his cowling. It could not be determined whether the cowling was lost before or after…Aug 9, 1982 · N5628L · Substantial damageNTSB NYC82DA189Accident · No injuriesFinal reportPiper PA-12 · Wellesley, MAThe pilot experienced a power loss and decaying RPM and decided to land short of destination which was 10 miles away. After surveying a pond for landing, the RPM was 600 and the landing was hard enough to damage the floats. As inspection revealed a blockage…Aug 8, 1982 · N4463M · Substantial damageNTSB FTW82FRG39Accident · 1 fatalFinal reportPiper PA-23-250 · Bandera, TXWhile returning from Mexico, the pilot landed at eagle pass, TX and cleared U.S. Customs. Without refueling or obtaining a weather briefing, he continued toward his home airfield at the flying l ranch near Bandera, TX. Local weather observations indicated…Aug 8, 1982 · N148AF · DestroyedNTSB SEA82FYA09Accident · 2 fatalFinal reportCessna R172K · Ketchum, IDThe acft was observed flying low over a road in mountainous terrain prior to impact. All pilot and aircraft records were destroyed by fire.Aug 7, 1982 · N736VC · DestroyedNTSB SEA82DA137Accident · No injuriesFinal reportHughes 369D · Shelton, WADuring a sight seeing flight the pilot smelled a burning odor and prepared to make a precautionary off-airport landing. Shortly thereafter, engine RPM decayed and an autorotative landing was effected on a dirt road. On touchdown, the main rotor blades flexed…Aug 7, 1982 · N10966 · Substantial damageNTSB ATL82FA233Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Folkston, GAThe acft crashed into the okefenokee swamp in se Georgia. Thunderstorms, varying in magnitude from levels 3 to 5, were moving from west of jacksonville FL to an area north of the okefenoke swamp. The storms were moving nw at 20K.Aug 7, 1982 · N7379J · DestroyedNTSB ANC82DA045Accident · Minor injuriesFinal reportPiper PA-12 · Near Anchorage, AKThe pilot reported that during flight, the engine quit when the right tank went dry. He switched the fuel selector to the left tank, but the engine would not start. Subsequently, the plane was damaged during a forced landing in a creek bottom Near powerlines.…Aug 7, 1982 · N251T · Substantial damageNTSB MIA82DA182Accident · No injuriesFinal reportBeech 65 · Andros Is, BahamasWhile en route at 9000 ft MSL at night, the right engine reportedly lost power and was feathered. The pilot reported that the left engine had a partial loss of power and the aircraft would not maintain altitude. Communication was maintained with miami center…Aug 6, 1982 · N35PK · DestroyedNTSB FTW82DA315Accident · No injuriesFinal reportPiper PA-28-140 · Springdale, ARThe pilot stated taht the aircraft was at 4200 ft descending when the engine suddenly lost power. He was unable to glide to an airport so he landed on a road. During the landing, the right wing hit a road sign and was substantially damaged. After landing, the…Aug 6, 1982 · N7176R · Substantial damageNTSB MKC82IA137Incident · No injuriesIncident investigationFinal reportMitsubishi MU-2B-25 · St. Joseph, MOAfter takeoff, the pilot was cleared to climb to 6000 ft MSL. While climbing through about 5000 ft, he heard a loud noise (bam) as the left engine lost power. The left engine was shut down and feathered and a landing was made with no other problems. An…Aug 5, 1982 · N312MA · Minor damage