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 NYC83LA258Accident · No injuriesLimited investigationFinal reportCessna 172G · Woodford, VTAccording to the pilot weather was clear at time of departure with clouds at about 4000-4500 feet but clr above. He entered a break in the clouds and began following a road. As the weather began closing in from above and the road became curvy, the pilot had…Sep 27, 1983 · N3692L · DestroyedNTSB FTW83FA441Accident · 3 fatalField investigationFinal reportCessna 172E · Leesville, LAEarlier in the day the four occupants of the acft had been reported to the sheriff's dept as being drunk at a lounge near zwolle,LA. After landing at the Leesville arpt the acft ran off the asphalt bending both ends of the prop blades. The occupants attempted…Sep 27, 1983 · N3058U · DestroyedNTSB CHI83FA445Accident · 1 fatalField investigationFinal reportCessna 182B · Constantine, MIThe non-instrument rated plt was on a x-country flt on a dark night. During the flt, the acft crashed in a corn field. Just prior to the initial impact, there was aprx a 15 deg descending angle cut thru the corn in the direction of flt & a 30 deg angle cut to…Sep 26, 1983 · N2531G · DestroyedNTSB CHI83FA441Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Bethany, ILPrior to this flt, the plt had contacted a fss & inquired about the wx. He was advised that VFR flt to terre haute, IN, was not recommended. He took off at about 1830 CDT. The plt again contacted the fss & inquired about the wx at burlington, IA &…Sep 26, 1983 · N8236U · DestroyedNTSB ATL83LA382Accident · Minor injuriesLimited investigationFinal reportAero Commander A-9 · Andalusia, ALAfter spraying 2 fields, the plt was en route to spray a 3rd field when a severe vibration of the acft was encountered. He elected to land in the 1st available field & dumped his chemical load. During the landing, the acft hit a terrace & nosed over. The plt…Sep 26, 1983 · N8031V · Substantial damageNTSB CHI83LA439Accident · No injuriesLimited investigationFinal reportCessna 206 · Eveleth, MNWhile returning from a fishing trip in ontario, Canada, the plt landed at crane lake, MN, where he cleared customs & had 10 gal of fuel added to the right fuel tank. He then flew to Eveleth, MN, aprx 90 mi away. From Eveleth, he proceed toward ely lake, MN.…Sep 25, 1983 · N7169Q · Substantial damageNTSB CHI83FA440Accident · 2 fatalField investigationFinal reportErcoupe 415-C · Raymond, ILDuring a wx briefing at 1433 CDT, the plt was advised to expect 500 ft ceilings, 2 mi visibilities, rain showers & thunderstorms. He then took off from bismark, MO with no flt plan. Reportedly, wx was encountered during the flt which deteriorated as he…Sep 25, 1983 · N3184 · DestroyedNTSB ATL83LA381Accident · No injuriesLimited investigationFinal reportAerotek S-2A · Dublin, GAThe plt landed at eastman, GA, where he planned to refuel, while en route from milton, FL to sumter, SC. Fuel was not available, so he departed for swainsboro, GA. However, he decided that would be too FAR, and planned instead, to land at Dublin which was 30…Sep 25, 1983 · N15KP · Substantial damageNTSB MKC83LA224Accident · No injuriesLimited investigationFinal reportBeech A36 · Oberlin, KSThe plt stated he was flying near his relatives' house when he switched fuel tanks and the eng began running rough. The plt suspected the magnetos since they had recently been serviced. The plt switched fuel tanks again with the boost pumpson and the engine…Sep 24, 1983 · N797CC · Substantial damageNTSB MIA83LA238Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Clermont, FLDuring flt, the eng began running rough & oil began leaking & spreading onto the windshield. The eng subsequently failed & the plt selected an area for a forced landing, during the landing, the acft contacted trees & was damaged. An investigation revealed…Sep 24, 1983 · N8898K · Substantial damageNTSB CHI83IA442Incident · No injuriesIncident investigationFinal reportCessna 172RG · Shell Lake, WIThe number 4 exhaust pushrod failed in flight for an undetermined reason.Sep 24, 1983 · N4963V · No damageNTSB SEA83FA204Accident · 2 fatalField investigationFinal reportLake LA-4-200 · Eastsound, WAThe acft collided with the glassy water during a low alt maneuver. The acft was observed by witnesses to descend from about 100 ft in a flat attitude,touch down,skim along the water then the nose pitched down and the acft nosed over. The occupants were…Sep 23, 1983 · N1251L · DestroyedNTSB MKC83LA222Accident · No injuriesLimited investigationFinal reportS.N.I.A.S. AS350D · Cape Girardeau, MOThe plt reported that during flt, he heard a grinding noise, then the helicopter pitched up & to the left. He reduced power & noticed that the tail rotor was inoperative. During a run-on landing approach, the helicopter begun to yaw, then before touchdown, it…Sep 23, 1983 · N5786B · Substantial damageNTSB MIA83IA237Incident · No injuriesIncident investigationFinal reportPiper PA 28-180 · Verna, FLAcft made an emergency due to powerplant failure. Access to the wreckage was never gained.Sep 23, 1983 · N7032W · Minor damageNTSB LAX83FA456Accident · 1 fatalField investigationFinal reportMooney M20K · Patterson, CADuring a x-country flt, the acft crashed into rising terrain in a semi-box canyon in the diablo range. The crash site was at an elevation of aprx 1200 ft MSL. The canyon tops ranged from 1500 to 1700 ft. according to a farmer residing 2 mi west of the…Sep 22, 1983 · N231GJ · DestroyedNTSB NYC83FA253Accident · 1 fatalField investigationFinal reportBeech 58 · Arkville, NYPrior to taking off, the plt advised company personnel that he planned to fly vfr-on-top at 8500 ft MSL. He planned to depart at 1400 EDT, but did not specify his route of flt. When the acft did not arrive, a search was initiated, it was found where it had…Sep 21, 1983 · N6657R · DestroyedNTSB LAX83FA455Accident · 1 fatalField investigationFinal reportPiper PA 28-140 · Lake Genevieve, CADuring cruise flight the acft encountered a downdraft while flying in mountainous terrain. The pilot lost control of the acft & it crashed. The pilot was student pilot rated only & had not been endorsed for this flight. He also was carrying a passenger who…Sep 21, 1983 · N4297T · DestroyedNTSB LAX83LA452Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Palm Springs, CAWhile en route, the plt encountered deteriorating wx. He was an instrument plt, but had chosen not to file & fly under IFR due to terrain, wx, low performance of the acft & lack of pitot heat. The plt noted a ceiling at 5500 ft MSL when he crossed banning…Sep 20, 1983 · N3636X · Substantial damageNTSB LAX83LA450Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Joshua Tree, CAThe plt reported that he was flying under a 2000 ft MSL cloud layer while en route from san carlos, CA to glendale, AZ. He flew into a valley & the clouds began closing in. He then made a 180 deg turn, but the clouds had closed in behind him. He attempted a…Sep 20, 1983 · N5437B · DestroyedNTSB SEA83LA193Accident · Minor injuriesLimited investigationFinal reportAnderson Starduster TOO SA300 · Lynnwood, WAThe plt reported that during flt, there was a change in the engine sound which was followed by a drop in fuel pressure. The plt started to look for a place to land when a total loss of power occurred. He elected to land on a football field. However, after…Sep 18, 1983 · N44HA · Substantial damageNTSB LAX83FA442Accident · No injuriesField investigationFinal reportCessna 150H · Venice, CAThe acft ditched in the ocean after losing power while towing a banner. The pilot stated that the eng quit while the acft was over land. He turned toward the ocean and managed to start the engine 2 times for a brief period while descending. The propeller…Sep 18, 1983 · N22697 · Substantial damageNTSB CHI83LA430Accident · No injuriesLimited investigationFinal reportCessna U206F · Garden Prairie, ILWhile en route, the fuel pressure dropped, and subsequently, the eng lost power completely. During a landing in a corn field, the acft was damaged. An investigation revealed that the fuel line had separated at the flow divider. Reportedly, the eng had been…Sep 18, 1983 · N8449Q · Substantial damageNTSB NYC83FA248Accident · 4 fatalField investigationFinal reportCessna U-206FG · Jones Beach, NYThe acft ditched in the ocean about 4 miles se of Jones Beach, NY following eng power failure. The 4 occupants drowned. The plt was going from Washington,DC to westhampton Beach, NY, the acft was last refueled before its departure from westhampton Beach on…Sep 17, 1983 · N50807 · No damageNTSB FTW83FA430Accident · 2 fatalField investigationFinal reportMBB BO-105S · Grand Chenier, LAThe acft departed an offshore platform at 1510 for a 13 min flt to Grand Chenier. On 9/20 the wreckage was recovered from the floor of the gulf. The bottom left side of the fuselage revealed evidence of high impact forces with the water. There was no evidence…Sep 15, 1983 · N3456T · DestroyedNTSB ANC83LA173Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Kenai, AKThe acft collided with a ridgeline when the pilot attempted to fly through a pass. The pass was crested at about 3600 ftsurrounded by elevations of over 8000 ft MSL. The pilot stated that he was attempting to get through merrill pass because of hunters that…Sep 15, 1983 · N2430M · DestroyedNTSB ANC83LA172Accident · No injuriesLimited investigationFinal reportHiller-Soloy UH12E · Cape Yakataga, AKThe helicopter rolled over during a forced landing on a beach after the engine quit. Discussions with the plt owner of the company verified that the acft had run out of fuel. The owner had warned his pilots to visually check fuel on the helicopters due to…Sep 15, 1983 · N3324F · Substantial damageNTSB SEA83FA096Accident · Serious injuriesField investigationFinal reportStinson 108-2 · Quilcene, WAThe acft collided with trees at the 2800 ft level of a mountain after the pilot encountered IMC weather. The weather wasvmc in the area but the mountain ranges had been forecast to be obscured in weather. The pilot had received a weather briefing. The acft…Sep 14, 1983 · N9408K · DestroyedNTSB CHI83FA428Accident · Minor injuriesField investigationFinal reportSikorsky S-76A · Chicago, ILWhile cruising at 2000 ft MSL & 150 KTS, the crew heard a loud noise, and simultaneously, the helicopter yawed aprx 30 to 40 deg to the right & pitched nose down. The aircrew began an autorotation & activated the emergency floats. The helicopter continued in…Sep 14, 1983 · N521AC · DestroyedNTSB ANC83LA170Accident · No injuriesLimited investigationFinal reportCessna 206 · Anchorage, AKThe acft collided with wires and crashed tail first inverted during a forced landing after the engine stopped. The plt said he was descending from 1200 ft to 600 ft for ft hood segment when engine quit. The weather ws VMC. The plt tried to make it to mud…Sep 13, 1983 · N8273G · Substantial damageNTSB MIA83LA230Accident · Minor injuriesLimited investigationFinal reportCessna C-150 · Culebra Island, PRThe pilot stated that while on his long cross country flight the engine started to lose pwr. He then felt a vibration and the prop stopped the acft was ditched near the shore of Culebra Island. It was calculated that the acft flew abt 3 hours and 30 minutes.…Sep 12, 1983 · N11207 · Substantial damageNTSB LAX83LA437Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Santa Barbara, CAWhile circling an area near Santa cruise island, CA. During aerial fish spotting operations, the acft eng began to lose pwr. As the acft apchd the island the eng sustained a complete pwr loss and nosed over drng the ensuing forced lndg. An eng exam revealed…Sep 12, 1983 · N8741V · Substantial damageNTSB DCA83IA040Incident · No injuriesIncident investigationFinal reportBeech B-24R · Potomac, MDThe acft made a forced landing in a field of rye grass after the engine lost power. Investigation revealed that a connecting rod had failed. An FAA inspection revealed that the connecting rod retaining bolts were not properly torqued during a recent major…Sep 12, 1983 · N9196S · Minor damageNTSB FTW83LA428Accident · Minor injuriesLimited investigationFinal reportCessna 180A · Stake IslandThe plt stated, that while flying over gulf waters he forgot to set his altimeter and thought he was at 200 ft when the acft contacted the water. The float were ripped off and the acft sank in about 10 ft of water. The plt and passenger held onto the float…Sep 11, 1983 · N5030E · Substantial damageNTSB DEN83FA217Accident · No injuriesField investigationFinal reportBell 206L-1 · Price, UTThe plt took off with an 800 lb sling load & used 100% torque to expedite clearing power lines. When clear of the lines, he started a climbing turn & reduced the torque to about 80%. At aprx 300 ft AGL & 50 to 60 KTS, the eng began surging which caused the…Sep 10, 1983 · N3900Q · Substantial damageNTSB SEA83FA208Accident · 2 fatalField investigationFinal reportCessna 182N · Kalispell, MTThe pilot's failure to maintain clearance from the terrain while attempting to maneuver back to the departure airport after encountering icing conditions. Factors include icing conditions, mountainous terrain, and low ceilings.Sep 9, 1983 · N92368 · DestroyedNTSB FTW83LA425Accident · No injuriesLimited investigationFinal reportBeech A36 · Daisetta, TXBefore takeoff, the plt was briefed on the wx, including SIGMET 20C, which called for imbedded thunderstorms. While en route, he deviated around an area of wx & was provided vectors to avoid storm cells. In the vicinity of Daisetta, TX, the controller…Sep 9, 1983 · N18BR · Substantial damageNTSB DEN83FA214Accident · 1 fatalField investigationFinal reportCessna R172K · Silverton, COThe plt departed longmont, CO at about 0520 MDT. At 0617 MDT, he contacted the denver en route flt advisory service & received wx info. The location of the acft at that time was not determined. No further radio communications were received from the plt. A…Sep 8, 1983 · N758PB · DestroyedNTSB NYC83FA235Accident · Minor injuriesField investigationFinal reportPiper PA-28RT-201T · Andover, NJAs the acft was climbing thru about 7000 ft on a hot day, the eng abruptly lost power. Several attempts were made to restart the eng, but to no avail. While attempting to restart, the plt noted that the fuel flow indication was at or near zero & the boost…Sep 6, 1983 · N9LH · Substantial damageNTSB MIA83FA223Accident · Minor injuriesField investigationFinal reportCessna T-210N · Gainesville, FLThe acft collided with a ditch during a forced landing after engine failure in flt. The plt stated that during the climbto cruise the engine quit. He attempted to restart it once and then executed a forced landing. Examination of the acft wreckage revealed…Sep 6, 1983 · N6482Y · Substantial damageNTSB LAX83FA424Accident · 4 fatalField investigationFinal reportPiper PA-32-301T · San Marcos, CAAt aprx 2209 PDT, the plt departed fresno, CA on a night, VFR, x-country flt. He cancelled his VFR flt plan at 0009 PDT & landed at ramona, CA at 0012. After landing, he called his wife to inquire about the wx at palomar, CA. She looked out the window &…Sep 6, 1983 · N8196J · DestroyedNTSB FTW83LA429Accident · Serious injuriesLimited investigationFinal reportBritish BAC 1-11 · Green Canyon172While established in cruise flight deviating around an area of thunderstorms the aircraft experienced an encounter with turbulence that caused 1 serious and 2 minor injuriesSep 6, 1983 · YS17C · No damageNTSB SEA83FA198Accident · Serious injuriesField investigationFinal reportBell 205A-1 · Elk Rock, WAThe acft was climbing thru about 800 ft AGL, when the plt noted a severe shudder & vibration. He lowered the collective, then noticed that the N2 & rotor RPM were pegged at 110%. As he reapplied the collective to stop the overspeed, he noted a loss of thrust…Sep 5, 1983 · N58034 · DestroyedNTSB CHI83LA415Accident · No injuriesLimited investigationFinal reportCessna 150G · Paris, ILThe student plt was on his 1st solo x-country flt. On the 1st leg of the flt, he became disoriented, experienced fuel exhaustion & landed in a soybean field. During the landing, the acft nosed over when the gear encountered the tall beans. The student…Sep 5, 1983 · N6227S · Substantial damageNTSB SEA83FA197Accident · Serious injuriesField investigationFinal reportCessna U206F · Juneau, AKThe plt reported that while on a sightseeing flt, he proceeded up the taku inlet northbound. From there, he continued up over the taku glacier while climbing to aprx 5300 ft MSL.thereafter, he turned to proceed down the mendenhall glacier & begun a descent.…Sep 4, 1983 · N8173Q · DestroyedNTSB NYC83LA232Accident · No injuriesLimited investigationFinal reportCessna 120 · Punxsutawney, PAAccording to the pilot when he entered the aircraft he found that the master switch had been left on and the battery wasdown. He flew around the airport for about 45 min, to recharge the battery prior to departing for his destination. He arrived at his…Sep 4, 1983 · N77321 · Substantial damageNTSB MKC83LA212Accident · No injuriesLimited investigationFinal reportWest-Heckman BABY-ACE · Easton, MOThe plt reported that he took off from tarkio, MO on a return flt to plattsburg, MO with 1/2 to 3/4 of a tank of auto fuel. He encountered strong head winds, and subsequently, noticed that the fuel gage was registering empty. At about that time, the eng lost…Sep 4, 1983 · N2308S · Substantial damageNTSB MKC83LA211Accident · No injuriesLimited investigationFinal reportMooney M20C · Bloomfield, IAWhile en route, the plt encountered a progressive, partial power loss. At 1st the eng began running rough, then the manifold pressure dropped to 15 inches (18 inches had been set for cruise). He heard a clicking noise & started a descent from his cruise alt…Sep 4, 1983 · N4057N · Substantial damageNTSB LAX83FA420Accident · 1 fatalField investigationFinal reportHughes 369HS · Ventura, CAThe helicopter was observed descending 'straight down' & 'nose first.' The wreckage was located about 200 yds offshore in about 30 ft of water. Witnesses stated that it was dark & hazy. They were able to see the acft lights, but not the stars. The plt did not…Sep 4, 1983 · N8500N · DestroyedNTSB CHI83LA413Accident · Minor injuriesLimited investigationFinal reportKuster KR-2 · New Lisbon, INThe acft made a forced landing in a cornfield after a loss of power during flt. The acft had been flying about 30 minutes. Post accident examination of the engine revealed a fuel leak around the mixture control linkage shaft. The fuelexhaustion was atttibuted…Sep 4, 1983 · N39JK · Substantial damageNTSB ATL83LA353Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCAA · Dayton, KYThe acft was modified to tow banners & was being used for that purpose. After the acft had been flown about 3 hrs & 20 min, the plt took off on his 4th banner tow flt. He stated that he had used the fuel gages to estimate the amount of fuel remaining. The…Sep 4, 1983 · N88223 · Substantial damage