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 FTW83FA108Accident · 1 fatalField investigationFinal reportBeech A36TC · Addison, TXThe non-instrument rated, student plt used another person's name while filing an instrument flt plan. When he contacted ground control for departure, he was advised that the arpt had just become IFR. After some confusion concerning canceling & filing flt…Feb 10, 1983 · N37365 · DestroyedNTSB MKC83FA065Accident · 2 fatalField investigationFinal reportCessna TR182 · Garwin, IADuring a briefing for a flt to western Oklahoma, the plt was advised that IMC wx was forcasted along the route. He changed his destination to waterloo, IA & was advised of IMC in that area also. While en route, the acft crashed in a field covered with snow.…Feb 9, 1983 · N6144T · DestroyedNTSB LAX83FA096Accident · No injuriesField investigationFinal reportAerospatiale AS 350 Astar · Pacoima, CAThe main rotor blades separated the tail boom during a forced landing following a total loss of power. The plt stated the acft was equipped with an experimental engine torque and temperature limiting device and this flt was to collect data concerning its…Feb 9, 1983 · N3605T · Substantial damageNTSB CHI83IA105Incident · No injuriesIncident investigationFinal reportGates Learjet LR-25 · Wilkes Barre, PAAcft autopilot/autotrim system failed to disengage due to a malfunction of the engage switch which occurred only in cold environment.Feb 9, 1983 · N4PN · No damageNTSB LAX83FA095Accident · 4 fatalField investigationFinal reportCessna T210N · Gorman, CAThe plt received a wx briefing before takeoff, but did not file a flt plan. Aprx 35 min later, the acft was observed flying low over interstate highway 5 near the Gorman VOR & tejon pass. A patrolman that saw the acft estimated that it crossed aprx 25 ft over…Feb 7, 1983 · N1244U · DestroyedNTSB FTW83LA105Accident · No injuriesLimited investigationFinal reportCessna T210M · Farmington, NMThe plt received a weather briefing & filed an IFR flt plan prior to the flt. Reportedly, the fss specialist did not advise the plt of a pertinent forcast for moderate icing in clouds & precipitation up to 18,000 ft. the forecast was available to the…Feb 7, 1983 · N732KS · Substantial damageNTSB DEN83FA056Accident · 2 fatalField investigationFinal reportNavion G · Leadville, COThe acft crashed into a mountain at the 12000 ft level in bad weather during a cross-country flt. Before takeoff the pilot had been advised of adverse weather enroute with VFR flt not recommended. He said he would fly out to check the weather and return if it…Feb 7, 1983 · N91774 · DestroyedNTSB LAX83FA091Accident · 3 fatalField investigationFinal reportCessna 177RG · Las Vegas, NVThe acft collided with a mountain during a night cross-country. The weather was VMC at takeoff but became IMC later nearthe mountains. A VFR flight plan was filed but never opened. The pilot continued flight into an area of known IMC conditions. He had…Feb 6, 1983 · N1547H · DestroyedNTSB ATL83FA099Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Lascassas, TNThe acft crashed in a field about 8 miles after a night takeoff in IMC weather. No flt plan was filed. The pilot had received several briefings. During his final briefing the possibility of icing was discussed. The takeoff time was ABOUT2030 hrs. The…Feb 6, 1983 · N8366W · DestroyedNTSB NYC83FA062Accident · No injuriesField investigationFinal reportPiper PA-28-151 · Newbury, MAAfter takeoff, the plt leveled at 2500 ft & after cruising for about 20 min, descended to 1500 ft MSL. Shortly after leveling at 1500 ft, there was a slight reduction in engine RPM. The plt stated that he applied carburetor heat, but the RPM continued to…Feb 5, 1983 · N6845J · Substantial damageNTSB ATL83LA096Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Greensboro, NCThe acft was damaged during a forced landing in a plowed field after the engine quit. The student pilot was on a solo cross-country and had landed once during the flight but did not refuel the acft. The student had increased his flight time on the 1st leg of…Feb 5, 1983 · N3032V · DestroyedNTSB SEA83FA052Accident · Serious injuriesField investigationFinal reportMaule M-5-220C · Near Asotin, WAWhile flying in the vicinity of the snake river, the engine lost power. Emergency landing areas were limited. The plt elected to land on a road Near the river. While in a right turn to line up with the road, the acft collided with a single power line, then…Feb 4, 1983 · N51599 · DestroyedNTSB LAX83FA090Accident · 2 fatalField investigationFinal reportBeech 58 · Indio, CAThe plt & passenger had flown from bermuda dunes to yucca valley, CA on a business flt. Reportedly, they terminated their business early because wx was building over the mountains between yucca valley & bermuda dunes. While on the return trip, the plt…Feb 4, 1983 · N1586W · DestroyedNTSB CHI83IA103Incident · No injuriesIncident investigationFinal reportEmbraer EMB-110 · Milwaukee, WIThe acft experienced extreme oscillations about the pitch axis with the control column moving fore & aft from 1 to 3 inches. The oscillations varied directly with airspeed. No out of limit conditions were found until after a second occurrence when the…Feb 4, 1983 · N1356P · Minor damageNTSB NYC83FA060Accident · 2 fatalField investigationFinal reportAero Commander 680FL P · Sunbury, PAAt aprx 0928 EST, the plt obtained a fss wx briefing by telephone. He was briefed on conditions of low ceilings, fog, light rain, drizzle, snow & blowing snow along his route. However, he did not ask about icing conditions & the briefing did not include a flt…Feb 3, 1983 · N12LF · DestroyedNTSB MKC83FA060Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Salem, MODuring the 0910 telephone wx briefing by the st. louis fss, the plt mentioned that there was ground fog in the Salem area. At about 1010 the plt departed from rwy 16, made a left turn & crossed the arpt heading north. A witness who drovethe plt to the arpt…Jan 31, 1983 · N99SJ · DestroyedNTSB SEA83LA046Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Yakima, WAAircraft lost power during night cross-country and was landed on a highway. During landing the aircraft collided with a pickup truck a tree and a fence. The aircraft had run out of fuel.Jan 29, 1983 · N22824 · DestroyedNTSB CHI83LA095Accident · No injuriesLimited investigationFinal reportCessna 140 · Richview, ILThe acft collised with a ditch and nosed over during a forced landing after the engine stopped in cruise flt. The pilot said he checked the carburetor heat on the ground but did not use it in the air. After the landing the engine was inspected and no…Jan 29, 1983 · N2377V · Substantial damageNTSB LAX83LA084Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Ocotillo Wells, CAThe acft was on a night sightseeing flight when the engine quit. The fuel selector was on the left tank and the left tank was empty. The pilot switched tanks but the engine did not restart. The acft impacted the desert in a skid with left wing low. Post…Jan 28, 1983 · N210DK · Substantial damageNTSB LAX83FA083Accident · 6 fatalField investigationFinal reportMitsubishi MU-2B-60 · Scottsdale, AZThe acft diverted from Scottsdale AZ to a flt course to sedona because of thunderstorms & high winds at Scottsdale, but after a radio conversation with Scottsdale twr, the plt decided to reroute to land at Scottsdale. The plt did not read back the weather…Jan 28, 1983 · N440MA · DestroyedNTSB DEN83LA054Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Jamestown, NDWhile en route, the plt encountered freezing rain and climbed to aprx 3500 ft to be on top of all weather. When he throttled back, the engine began surging and would not produce enough power for level flight. The pilot knew that the ground level in that area…Jan 28, 1983 · N1597U · Substantial damageNTSB DEN83FA053Accident · 4 fatalField investigationFinal reportCessna T210N · Minersville, UTThe acft impacted in a near vertical attitude near the top of a mountain & adjacent to a highway where witnesses had observed the acft flying at very low altitues under a low ceiling. There was no record of a preflight wx briefing or inflight advisories. No…Jan 28, 1983 · CGRFV · DestroyedNTSB LAX83FA438Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Redlands, CAAt 0638 PST, the plt received a wx briefing on a flt to sacramento, CA, and was advised that VFR was not recommended. At 0800, he received another briefing & filed a VFR flt plan to palm springs, CA. During flt, he advised palm springs tower that if he could…Jan 27, 1983 · N8139D · DestroyedNTSB MIA83FA064Accident · No injuriesField investigationFinal reportPiper PA-31 · Miami Lakes, FLThe plt & a prospective buyer/passenger were on a local demonstration flt. Prior to this flt, the acft had been parked for nearly 1 yr. Since the last annual inspection on 1/12/82, it had been flown only 66 hrs. During the preflt, the plt found the fuel tanks…Jan 26, 1983 · N9003Y · DestroyedNTSB SEA83FYM04Accident · No injuriesFinal reportMooney M20K · Dufur, ORThe aircraft collided with an irrigation pipe line and fence during rollout of a forced landing after engine failure. The engine stopped while the aircraft was cruising en route. The pilot remained in radio contact throughout the emergency and landed in a…Jan 24, 1983 · N97429 · Substantial damageNTSB LAX83IA080Incident · No injuriesIncident investigationFinal reportBoeing 767-231 · San Diego, CAWhile descending thru 12,000 ft aprx 40 mi east of San Diego, CA, the left overwing evacuation slde annunciator light illuminated. The slide separated from the acft aprx 7 mi east of the arpt. No flt control problems were noted. Integrity of the sys was found…Jan 24, 1983 · N602TW · Minor damageNTSB CHI83FA089Accident · No injuriesField investigationFinal reportCessna 172 · Rockford, ILThe acft collided into the 2nd floor of a building while making an ILS approach to runway 36 at Rockford, IL. The weather was IMC. An IFR flight plan was filed. A pilot weather briefing was not given. The pilot was instrument rated. An approach was attempted…Jan 24, 1983 · N61558 · DestroyedNTSB LAX83LUQ01Accident · 2 fatalFinal reportCessna 152 · Castaic, CAAbout 3 hrs after he took off, the plt called burbank tower & advised he was lost & was at 4000 ft, heading southbound. Tower personnel advised him to contact burbank apch control on 121.5, but received no acknowledgement. A few minutes later, a helicopter…Jan 23, 1983 · N25061 · DestroyedNTSB CHI83FA090Accident · 2 fatalField investigationFinal reportPiper PA-22-20 · Siren, WIWitnesses heard a sound of an acft eng, but because of low clouds & fog they could not see the acft. They heard the sound of the eng, a loud roar, the breaking of trees, & thena 'bang.' They then found the acft which had penetrated a wooded area at a 70 deg…Jan 23, 1983 · N3925P · DestroyedNTSB FTW83FA097Accident · 2 fatalField investigationFinal reportBell 206L-3 · Goliad, TXThe helicopter collided with trees and the ground in an attempt to reverse directions at low alt & at night after encountering weather. The plt had received a weather briefing and knew the weather was bad with low ceilings and fog. Heradioed he could make it…Jan 21, 1983 · N3899U · DestroyedNTSB ATL83FLJ01Accident · 3 fatalFinal reportPiper PA-28-140 · Robersonville, NCThe acft collided with trees during an attempted emergency landing. The acft was 5 miles form an airport. The pilot had called on UNICOM and said he was lost and had partial power loss. He asked if anyone could hear him and he didnot believe he could make the…Jan 20, 1983 · N98302 · DestroyedNTSB CHI83FA086Accident · Minor injuriesField investigationFinal reportPiper PA-32-300 · Monroe, WIWhile cruising at 4,000 ft MSL the eng quit. During a forced landing on rolling farm terrain both main landing gear separated. The acft then slid through a barbed wire fence & caught fire. Metallurgical examination revealed a fatigue failure of the idle set…Jan 19, 1983 · N5818F · DestroyedNTSB LAX83LA074Accident · No injuriesLimited investigationFinal reportAero Commander 500 · Dixon, CAReportedly, the acft was on an air taxi cargo flt, operated by air express, hayward, CA. The acft reportedly departed reno, NV without a flt plan for a flt to sacramento & hayward, cal. While en route, the acft had an electrical failure. The plt stated that…Jan 18, 1983 · N6239B · Substantial damageNTSB CHI83LA085Accident · No injuriesLimited investigationFinal reportBell 206B · Cincinnati, OHThe Bell 206 helicopter experienced fuel exhaustion during approach for landing at a helipad. During autorotation the pilot moved left to avoid a pickup truck on the off ramp of I-75 and collided with a light pole at about 10 feet AGL. The aircraft yawed…Jan 17, 1983 · N59426 · Substantial damageNTSB MIA83LA060Accident · No injuriesLimited investigationFinal reportCessna 336 · Key Largo, FLThe acft ditched in shallow water 1/2 mi south of Key Largo, FL while on a flight from zephyrhills, FL to marathon FL. On 1/13 a flt plan was filed for the acft for a flt from kingston jamaica to tampa FL. It departed kinston at 0810 with ETA tampa at 1610.…Jan 16, 1983 · N1737Z · Substantial damageNTSB CHI83LA084Accident · No injuriesLimited investigationFinal reportCessna 182 · Wheaton, ILWhile in cruise flight at 2500' AGL the carburetor ice warning light came on. The pilot applied carburetor heat and the light went out. After the light went out the pilot returned the heat to 'off.' The pilot repeated the above sequence and when the light…Jan 16, 1983 · N3318F · Substantial damageNTSB CHI83LA083Accident · No injuriesLimited investigationFinal reportCessna 150 · Campbell, MNThe pilot made a forced landing on a country road during a cross-country flight. During the ground roll the acft left the road and collided with a ditch collapsing the nose gear. The two occupants were not injured. The pilot started this flight the previous…Jan 16, 1983 · N9218U · Substantial damageNTSB LAX83LA072Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Barstow, CAThe acft was damaged in an off arpt precautionary landing after an encounter with weather. The student pilot had left onthe second leg of a cross-country flt without checking the weather over the remaining route. Enroute he decided the weather was bad and…Jan 15, 1983 · N2422A · Substantial damageNTSB FTW83FA092Accident · No injuriesField investigationFinal reportCessna 150 · Midland, TXThe acft nosed over during an emergency landing after an engine failure. The landing was made off arpt in a cotton fieldthe nose gear dug in and the acft nosed over. The engine was torn down after the accident and it was discovered that the #3 connecting rod…Jan 15, 1983 · N45528 · Substantial damageNTSB CHI83LA082Accident · No injuriesLimited investigationFinal reportMaule M4-180C · Brainerd, MNThe aircraft experienced power failure during slow descent to enter traffic pattern after a test hop. A landing was accomplished in an open snow covered field. During the roll-out in the 18 inch deep snow the aircraft nosed over. Preliminary examination of…Jan 15, 1983 · N2062U · Substantial damageNTSB CHI83LA081Accident · Serious injuriesLimited investigationFinal reportCessna 172 RG · Green Bay, WIThe acft collided with the ground during an ILS approach. The weather was IMC at the time and an IFR flt plan was filed. The pilot was instrument rated and had received a weather briefing which forecast icing and freezing drizzle. The pilot told the weather…Jan 14, 1983 · N9916B · Substantial damageNTSB ANC83FA032Accident · 1 fatalField investigationFinal reportBell 206B · Cordova, AKThe helicopter was on a rescue/recovery flt for the Alaska state troopers with the plt & a state trooper on board. They departed in variable wx conditions to rescue the plt of another acft. Reportedly, snow was falling in the search area & the winds were…Jan 13, 1983 · N74PR · DestroyedNTSB MIA83LA070Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Culebra, PRThe flight had departed st. thomas, VI at 0900 on a VFR flight plan to roosevelt roads after discharging passengers in st. thomas. While enroute in cruise at 1800 MSL the engine failed. He turned toward the island of Culebra and when all efforts to restart…Jan 11, 1983 · N20FH · DestroyedNTSB FTW83IA084Incident · No injuriesIncident investigationFinal reportBell 222 · Houston, TXThe helicopter developed a severe vibration while in flt. The pilot executed an emergency landing with no further acft damage. An examination of the acft revealed that the walking beam assembly located between the swash plate and rotor pitch link had failed.…Jan 11, 1983 · N23021 · No damageNTSB MKC83LA052Accident · No injuriesLimited investigationFinal reportBeech 200 · Springfield, MODuring an emergency forced landing on a highway the aircraft collided with a sign. The aircraft had run out of fuel on final approach to Springfield, MO. The aircraft was enroute from white plains, NY. To tulsa, OK. The pilot departed white plains with less…Jan 10, 1983 · N1847A · Substantial damageNTSB LAX83LJA04Accident · Minor injuriesFinal reportPiper PA-28-151 · Near Honolulu, HIThe plt & passengers departed on a sight-seeing flt to view a volcano on the island of Hawaii via kona, HI & return. The fuel tanks had been topped off before departure, & reportedly, there was sufficient fuel for the flt. Except for difficulties in starting…Jan 10, 1983 · N32658 · DestroyedNTSB CHI83LA078Accident · No injuriesLimited investigationFinal reportMooney M20A · Ashkum, ILThe pilot made a precautionary landing in a plowed field during a ferry flight because of lowering ceiling and darkness,during the landing the gear collapsed from overload. The pilot was delayed in his departure for maintenance and service. Increasing clouds…Jan 9, 1983 · N8343E · Substantial damageNTSB ATL83MA084Accident · 7 fatalClass 1 · MajorFinal reportBeech D55 · Cherry Point, NCThe two acft collided at about 9,500 ft MSL 30 mi south of Cherry Point. After departing nassau, the plt of the BE-D55 never activated his flt plan. An adiz penetration time was therefore never established. When the unidentified acft entered warning area…Jan 9, 1983 · N7142N · 2 aircraft · DestroyedNTSB SEA83LA209Accident · 2 fatalLimited investigationFinal reportBellanca 14-19-3 · Goldendale, WAThe pilot's inadequate preflight and in-flight planning, which resulted in flight into adverse weather conditions and clearance from trees not maintained. Factors contributing to the accident included the clouds, low ceilings, and turbulence.Jan 8, 1983 · N8807R · DestroyedNTSB SEA83LA039Accident · Serious injuriesLimited investigationFinal reportBoeing 727 · Near Yakima, WADuring a climb to cruise, one passenger was injured when turbulence was encountered at about 20,500 ft MSL. The injured passenger was a 73 year old male, a retired priest and the only passenger not seated and wearing a seatbelt. As he exited the restroom, the…Jan 8, 1983 · N292WA · No damage