# NTSB investigations: Enroute

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

Page 68 of 718 · 35,883 cases

## Cases, newest first

- [NTSB ERA16LA172](https://openairdocs.org/ntsb/ERA16LA172.md): Champion 7BCM · Tyrone, GA · Accident · No injuries · Limited investigation · Final report · Apr 30, 2016 · N7620B · Substantial damage
  > A partial loss of engine power during cruise flight for reasons that could not be determined because postaccident examination of the engine revealed no anomalies that would have precluded normal operation.
- [NTSB ERA16WA196](https://openairdocs.org/ntsb/ERA16WA196.md): Sikorsky S76 · Campos dos Goytacazes, Brazil · Accident · No injuries · Foreign investigation · Apr 28, 2016 · PR-EMR · Substantial damage
  > On April 28, 2016, about 1330 coordinated universal time, a Sikorsky S76A, Brazilian registration PR-EMR, was substantially damaged during an emergency landing after a fire indication and precautionary engine shutdown on the right engine followed shortly by a…
- [NTSB ERA16LA265](https://openairdocs.org/ntsb/ERA16LA265.md): Eurocopter Deutschland MBB BK 117 C-2 · Pittsburgh, PA · Accident · No injuries · Limited investigation · Final report · Apr 26, 2016 · N145HN · Substantial damage
  > Maintenance personnel’s failure to properly secure the left vertical fin cowling during recent maintenance, which resulted in its separation and subsequent contact with the tail rotor system during flight.
- [NTSB CEN16WA179](https://openairdocs.org/ntsb/CEN16WA179.md): Swearingen SA 226T · Andorra, Lleida, Spain, Spain · Accident · No injuries · Foreign investigation · Apr 26, 2016 · N125WG · Substantial damage
  > On April 26, 2016, about 1535 hours universal coordinated time, a Swearingen SA-226T airplane, United States registration N125WG, was substantially damaged during landing at the Andorra – La Seu d'Urgell Airport (LESU); Andorra, Lleida, Spain. The airplane…
- [NTSB CEN16LA167](https://openairdocs.org/ntsb/CEN16LA167.md): Probst Zenair 601XL · Hempstead, TX · Accident · No injuries · Limited investigation · Final report · Apr 24, 2016 · C-GXLP · Substantial damage
  > A loose output connection from the generator voltage regulator, which resulted in a loss of power to the electronic ignition system, a total loss of engine power, and a subsequent forced landing, during which the airplane impacted a sign pole.
- [NTSB CEN16LA166](https://openairdocs.org/ntsb/CEN16LA166.md): Cessna 172 · Brimfield, IL · Accident · Minor injuries · Limited investigation · Final report · Apr 23, 2016 · N7614X · Substantial damage
  > A loss of engine power for reasons that could not be determined, as postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR16LA094](https://openairdocs.org/ntsb/WPR16LA094.md): Cessna 182A · Selma, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 19, 2016 · N9909B · Substantial damage
  > The total loss of engine power due to carburetor icing, which resulted from the flight instructor's failure to use carburetor heat during the descent.
- [NTSB ERA16LA166](https://openairdocs.org/ntsb/ERA16LA166.md): Champion 7ECA · Tannersville, PA · Accident · No injuries · Limited investigation · Final report · Apr 19, 2016 · N5094X · Substantial damage
  > A loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB ERA16WA163](https://openairdocs.org/ntsb/ERA16WA163.md): Robinson R66 · Bely Island, Russia · Accident · 3 fatal · Foreign investigation · Apr 18, 2016 · RA-06233 · Substantial damage
- [NTSB ERA16LA164](https://openairdocs.org/ntsb/ERA16LA164.md): Piper PA28 · Okeechobee, FL · Accident · Minor injuries · Class 3 · Limited · Final report · Apr 18, 2016 · N151DC · Substantial damage
  > The failure of the No. 3 piston due to fatigue cracking, which resulted in a total loss of engine power and subsequent forced landing, during which the airplane impacted obstacles.
- [NTSB ENG16RA028](https://openairdocs.org/ntsb/ENG16RA028.md): Bombardier CL600 2C10 · Fukuoka, Japan · Incident · No injuries · Foreign investigation · Apr 17, 2016 · JA06RJ · No damage
  > The Japan Transport Safety Board has notified the NTSB of an incident involving a Bombardier CL-600-2C10, JA06RJ, which took off from Fukuoka Airport at 07:48 local time to Komatsu Airport and during return back to Fukuoka Airport due to weather condition of…
- [NTSB ERA16LA162](https://openairdocs.org/ntsb/ERA16LA162.md): Costruzioni Aeronautiche Tecna P2008 · Burgaw, NC · Accident · Minor injuries · Class 3 · Limited · Final report · Apr 16, 2016 · N588TA · Substantial damage
  > The pilot’s failure to activate the airplane’s alternator, which resulted in an eventual loss of electrical power to the engine’s fuel pumps, fuel starvation, and a total loss of engine power. Contributing was the pilot’s use of an incomplete checklist.
- [NTSB ERA16LA158](https://openairdocs.org/ntsb/ERA16LA158.md): Cessna U206 · Atlantic Ocean (Atlantic Ocean) · Accident · No injuries · Limited investigation · Final report · Apr 15, 2016 · N1346Q · Substantial damage
  > A total loss of engine power for reason(s) that could not be determined because the airplane was not recovered.
- [NTSB GAA16CA196](https://openairdocs.org/ntsb/GAA16CA196.md): Cessna 182 · Moorestown, MI · Accident · Minor injuries · Data collection · Final report · Apr 14, 2016 · N958HP · Substantial damage
  > An in-flight bird strike, which resulted in wind screen damage.
- [NTSB ERA16LA157](https://openairdocs.org/ntsb/ERA16LA157.md): Cessna 175 · Wartburg, TN · Accident · Minor injuries · Class 3 · Limited · Final report · Apr 14, 2016 · N6792E · Substantial damage
  > Catastrophic engine failure due to a fatigue fracture of the No. 6 connecting rod cap.
- [NTSB ANC16WA018](https://openairdocs.org/ntsb/ANC16WA018.md): Rockwell 112 · Revelstoke, Canada · Accident · 2 fatal · Foreign investigation · Apr 11, 2016 · C-GQJN · Destroyed
  > On April 11, 2016, about 2000 Coordinated Universal Time, a Rockwell Commander 112B airplane, CGQJN, impacted terrain near Revelstoke, British Columbia, Canada, under unknown circumstances. The pilot and passenger sustained fatal injuries. The Transportation…
- [NTSB DCA16WA138](https://openairdocs.org/ntsb/DCA16WA138.md): Boeing 737 · Chiang Mai, Thailand · Incident · No injuries · Foreign investigation · Apr 10, 2016 · HS-LTB · No damage
  > Ministry of Transport of Thailand has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on April 10, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Thailand's investigation under the…
- [NTSB CEN16LA151](https://openairdocs.org/ntsb/CEN16LA151.md): Cirrus Design SR20 · Caldwell, TX · Accident · No injuries · Limited investigation · Final report · Apr 10, 2016 · N8PY · Substantial damage
  > The failure of the No. 5 cylinder's exhaust pipe for undetermined reasons, which resulted in a partial loss of engine power. Contributing to the accident was the pilot’s fast and long landing, which led to a runway overrun.
- [NTSB CEN16WA159](https://openairdocs.org/ntsb/CEN16WA159.md): Cessna 550 · Geneva, Switzerland · Incident · No injuries · Foreign investigation · Apr 9, 2016 · EC-LQF · No damage
  > The Swiss Accident Investigation Board (SAIB) of Switzerland has notified the National Transportation Safety Board (NTSB) of an incident involving a Cessna Aircraft Company S550 Citation S/2, EC-LQF, that occurred on April 9, 2016. The NTSB has appointed a…
- [NTSB ANC16FA017](https://openairdocs.org/ntsb/ANC16FA017.md): Cessna 206 · Angoon, AK · Accident · 3 fatal · Field investigation · Final report · Apr 8, 2016 · N50159 · Substantial damage
  > The pilot's inadvertent turn toward terrain that was higher-than-expected while trying to avoid poor visibility conditions and his subsequent attempt to clear terrain, which reduced the airspeed and led to the exceedance of the airplane's critical angle of…
- [NTSB CEN16LA401](https://openairdocs.org/ntsb/CEN16LA401.md): Agustawestland Philadelphia AW139 · Galliano, LA · Accident · No injuries · Limited investigation · Final report · Apr 7, 2016 · N639NA · Substantial damage
  > The fatigue failure of a tail rotor blade erosion shield extension, which resulted in in-flight damage to a main rotor blade.
- [NTSB CEN16WA150](https://openairdocs.org/ntsb/CEN16WA150.md): Robinson R22 Beta · Bern, Switzerland · Incident · No injuries · Foreign investigation · Apr 6, 2016 · HB-ZGO · Minor damage
  > On April 6, 2016, about 1330 Universal Coordinated Time (UTC), the crew of a Robinson R22 BETA, Swiss registration HB-ZGO, made a precautionary landing at Bern Airport (LSZB), Bern, Switzerland, after they smelled smoke. They noted the alternator had failed…
- [NTSB GAA16CA177](https://openairdocs.org/ntsb/GAA16CA177.md): Beech A23 · Hulbert, OK · Accident · Minor injuries · Data collection · Final report · Apr 5, 2016 · N5791V · Substantial damage
  > The pilot's inadequate fuel planning, which resulted in fuel exhaustion, and collision with terrain.
- [NTSB OPS16IA010](https://openairdocs.org/ntsb/OPS16IA010.md): Mooney M20R · Jacksonville, FL · Incident · Class 3 · Incident · Final report · Apr 3, 2016 · N57GX · 2 aircraft · No damage
  > The air traffic controller's decision to issue climb instruction to one aircraft without ensuring the required separation with another could be maintained. Contributing to the incident was the air traffic controller's failure to issue a safety alert in a…
- [NTSB WPR16FA091](https://openairdocs.org/ntsb/WPR16FA091.md): Nokes Matthew Lancair IV P · Fallbrook, CA · Accident · 1 fatal · Field investigation · Final report · Apr 2, 2016 · N438Y · Substantial damage
  > A loss of engine power during cruise for reasons that could not be determined because examination of the airplane did not reveal any anomalies that would have precluded normal operation.
- [NTSB ERA16LA153](https://openairdocs.org/ntsb/ERA16LA153.md): Butterhof Anthony J Ginny B · South Harrison Township, NJ · Accident · Minor injuries · Limited investigation · Final report · Apr 2, 2016 · N349E · Substantial damage
  > The pilot/mechanic's failure to safety-wire the gascolator bale clamp, which resulted in a fuel leak and subsequent total loss of engine power.
- [NTSB ERA16LA145](https://openairdocs.org/ntsb/ERA16LA145.md): Cessna 175B · Hurley, MS · Accident · No injuries · Limited investigation · Final report · Apr 2, 2016 · N8115T · Substantial damage
  > The mechanic's failure to identify and remove a plastic sheath covering a portion of the mixture control cable during an annual inspection, which prevented the proper securing of the mixture control cable and full travel of the control at the carburetor and…
- [NTSB CEN16WA144](https://openairdocs.org/ntsb/CEN16WA144.md): Cessna 208 · Tayoltita, Dgo, Mexico, Mexico · Accident · 3 fatal · Foreign investigation · Apr 1, 2016 · XA-ULU · Substantial damage
  > On April 1, 2016, about 0900 local time, a Cessna 208B single engine airplane, serial number 208B2104, registry XA-ULU, was substantially damaged during an off-airport forced landing near Tayoltita, San Dimas, Durango, Mexico. There were ten persons on-board…
- [NTSB CEN16WA141](https://openairdocs.org/ntsb/CEN16WA141.md): Cessna 172 · Madrid, Spain · Accident · 3 fatal · Foreign investigation · Mar 31, 2016 · EC-JSM · Substantial damage
  > On March 31, 2016, about 1200 coordinated universal time (UTC), a Cessna 172 airplane, Spanish registration EC-JSM, collided with the terrain following a bird strike near Madrid, Spain. The pilot and two passengers sustained fatal injuries, and the airplane…
- [NTSB CEN16LA133](https://openairdocs.org/ntsb/CEN16LA133.md): Mathieu Cassutt · Louisville, NE · Accident · Serious injuries · Limited investigation · Final report · Mar 28, 2016 · N78RM · Substantial damage
  > The pilot's decision to operate with partial carburetor heat while operating in conditions conducive to the formation of carburetor ice, which resulted in a loss of engine power due to carburetor icing.
- [NTSB ERA16LA142](https://openairdocs.org/ntsb/ERA16LA142.md): Piper PA 23-250 · Danville, VA · Accident · Minor injuries · Limited investigation · Final report · Mar 27, 2016 · N22AM · Substantial damage
  > The pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA16FA143](https://openairdocs.org/ntsb/ERA16FA143.md): Robinson R44 · Canadensis, PA · Accident · 1 fatal · Field investigation · Final report · Mar 27, 2016 · N776JM · Destroyed
  > The pilot's loss of control due to spatial disorientation, which occurred after ascending in order to clear rising terrain and inadvertently entering the clouds.
- [NTSB DCA16WA135](https://openairdocs.org/ntsb/DCA16WA135.md): Boeing 737-76N · Porto de Moz Municipality, Brazil · Incident · No injuries · Foreign investigation · Mar 27, 2016 · PR-GOV · No damage
  > The Brazil Centro de Investigação e Prevenção de Acidentes Aeronáuticos (CENIPA) has notified the NTSB of an accident involving a Boeing 737-76N that occurred on March 27, 2016. The NTSB has appointed a U.S. Accredited Representative to assist CENIPA's…
- [NTSB CEN16WA140](https://openairdocs.org/ntsb/CEN16WA140.md): Cessna Skyhawk II 172N · Vulcan de Fuego, Guatemala, Guatemala · Accident · 2 fatal · Foreign investigation · Mar 27, 2016 · TG-KAM · Substantial damage
  > On March 27, 2016, about 2242 universal coordinated time (UTC), a Guatemalan-registered Cessna 172N, TG-KAM, impacted terrain near the Vulcan de Fuego while en route from Tiquisate, Escuintla, to the La Aurora International Airport (MGGT), Guatemala City,…
- [NTSB WPR16LA090](https://openairdocs.org/ntsb/WPR16LA090.md): Cessna 172L · McNeil Island, WA · Accident · No injuries · Limited investigation · Final report · Mar 26, 2016 · N1151M · Substantial damage
  > The student pilot's fuel mismanagement, which led to fuel starvation and a total loss of engine power during cruise flight. Contributing to the accident was his failure to follow the appropriate engine start, before takeoff, and emergency checklists.
- [NTSB CEN16LA134](https://openairdocs.org/ntsb/CEN16LA134.md): Grumman American Avn. AA 1B · Stephenville, TX · Accident · Serious injuries · Limited investigation · Final report · Mar 26, 2016 · N8883L · Substantial damage
  > The loss of engine power during cruise flight due to fuel exhaustion, which resulted from the pilot's inadequate preflight fuel planning and in-flight fuel management.
- [NTSB ERA16WA147](https://openairdocs.org/ntsb/ERA16WA147.md): Bell 206 · Riosucio, Choco, Colombia · Accident · 3 fatal · Foreign investigation · Mar 22, 2016 · HK-5049 · Substantial damage
- [NTSB ERA16WA138](https://openairdocs.org/ntsb/ERA16WA138.md): Bell 206B III · Angostura, Colombia · Accident · 3 fatal · Foreign investigation · Mar 22, 2016 · HK4674 · Destroyed
  > On March 23, 2016, about 1211 universal coordinated time, a Bell 206B III, Colombian registration HK4764, was destroyed when it impacted mountainous terrain and was consumed by a postcrash fire. Three of the four occupants were fatally injured, and one…
- [NTSB DCA16CA181](https://openairdocs.org/ntsb/DCA16CA181.md): Boeing 737 724 · Port Arthur, TX · Accident · Serious injuries · Data collection · Final report · Mar 15, 2016 · N23708 · No damage
  > an inadvertent encounter with clear air turbulence.
- [NTSB ERA16FA127](https://openairdocs.org/ntsb/ERA16FA127.md): Sheahen Dane E RV-8 · Clermont, FL · Accident · 2 fatal · Field investigation · Final report · Mar 12, 2016 · N838RV · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack while maneuvering for a forced landing; which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the fatigue failure of the crankshaft for reasons that could…
- [NTSB DCA16WA122](https://openairdocs.org/ntsb/DCA16WA122.md): Boeing 737 · Malaga, Spain · Incident · No injuries · Foreign investigation · Mar 12, 2016 · LN-NHG · No damage
  > The government of Spain has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on March 12, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Spain's investigation under the provisions of…
- [NTSB ERA16WA132](https://openairdocs.org/ntsb/ERA16WA132.md): Learjet 60 · Doha, Qatar · Incident · No injuries · Foreign investigation · Mar 9, 2016 · A6RJE · Minor damage
  > On March 9, 2016, about 1800 universal coordinated time, a Learjet 60 XR, United Arab Emirates registration A6RJE, incurred minor damage during cruise flight near Hamad International Airport (OTHH), Doha, Qatar. The two pilots, one flight attendant and four…
- [NTSB DCA16WA104](https://openairdocs.org/ntsb/DCA16WA104.md): Boeing 747 · Jeddah, Saudi Arabia · Incident · No injuries · Foreign investigation · Mar 9, 2016 · TF-AMU · No damage
  > The government of Saudi Arabia has notified the NTSB of an accident involving a BOEING 747 airplane that occurred on March 09, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Saudi Arabia's investigation under the…
- [NTSB ERA16LA124](https://openairdocs.org/ntsb/ERA16LA124.md): Cirrus Design SR22 · Hauppauge, NY · Accident · No injuries · Limited investigation · Final report · Mar 5, 2016 · N295AR · Substantial damage
  > The total loss of engine power, which resulted from the failure of the camshaft gear due to fatigue. Contributing to the accident was the owner/operator's failure to comply with the engine manufacturer's recommended overhaul interval.
- [NTSB ERA16LA123](https://openairdocs.org/ntsb/ERA16LA123.md): Taylorcraft BL · St. Petersburg, FL · Accident · No injuries · Class 3 · Limited · Final report · Mar 5, 2016 · N22661 · Substantial damage
  > A partial loss of engine power due to the fatigue fracture of the No. 3 cylinder head stud.
- [NTSB ENG16RA026](https://openairdocs.org/ntsb/ENG16RA026.md): Cessna 208 · Georgetown, Guyana · Incident · No injuries · Foreign investigation · Mar 3, 2016 · 8R-GHT · No damage
  > The Guyana Civil Aviation Authority (GCAA) has notified the NTSB of an incident involving a Cessna 208B, which occurred on March 3, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA investigation under the provisions of ICAO…
- [NTSB GAA16CA143](https://openairdocs.org/ntsb/GAA16CA143.md): Bell 47 · Agua Dulce, CA · Accident · Minor injuries · Data collection · Final report · Mar 2, 2016 · N568TB · Substantial damage
  > The pilot's failure to set the appropriate collective friction prior to releasing the collective in flight, which resulted in decreased main rotor pitch, settling with power, and an impact with terrain.
- [NTSB CEN16LA118](https://openairdocs.org/ntsb/CEN16LA118.md): Cessna 150G · Simmesport, LA · Accident · No injuries · Limited investigation · Final report · Mar 2, 2016 · N3339J · Substantial damage
  > The installation of an improper bearing and thrust washer during engine overhaul, which resulted in failure of the connecting rods and a subsequent total loss of engine power.
- [NTSB CEN16FA116](https://openairdocs.org/ntsb/CEN16FA116.md): Curtiss Wright Travel AIR 4000 · Palmer Lake, CO · Accident · 2 fatal · Field investigation · Final report · Mar 2, 2016 · N6464 · Destroyed
  > The pilot's failure to maintain sufficient airspeed while maneuvering at low altitude in strong gusting winds, which resulted in exceedance of the airplane's critical angle of attack and an aerodynamic stall/spin. Contributing to the accident was the pilot's…
- [NTSB CEN16LA112](https://openairdocs.org/ntsb/CEN16LA112.md): Cirrus Design SR22 · Laguna Pueblo, NM · Accident · Minor injuries · Limited investigation · Final report · Feb 29, 2016 · N2711M · Substantial damage
  > A total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's inadequate oversight of the airplane's refueling and her subsequent failure to verify and monitor the fuel quantity before and during the flight.

Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=69

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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
```

This list as a web page: https://openairdocs.org/ntsb-phases/400/cases?page=68

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.