# 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 82 of 718 · 35,885 cases

## Cases, newest first

- [NTSB ERA14FA002](https://openairdocs.org/ntsb/ERA14FA002.md): Piper PA-28R-180 · Tifton, GA · Accident · 1 fatal · Field investigation · Final report · Oct 18, 2013 · N11ML · Destroyed
  > The noninstrument-rated pilot’s improper decision to continue visual flight rules flight into known instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control.
- [NTSB DCA14CA014](https://openairdocs.org/ntsb/DCA14CA014.md): Boeing 767 322 · Houston, TX · Accident · Serious injuries · Data collection · Final report · Oct 18, 2013 · N665UA · No damage
  > The airplane's inadvertent encounter with clear air turbulence during cruise flight, which resulted in a serious injury to a flight attendant.
- [NTSB CEN14FA010](https://openairdocs.org/ntsb/CEN14FA010.md): Cessna 177 · Clayton, OK · Accident · 1 fatal · Field investigation · Final report · Oct 18, 2013 · N30495 · Substantial damage
  > Controlled flight into terrain for reasons that could not be determined from the available evidence.
- [NTSB CEN14FA009](https://openairdocs.org/ntsb/CEN14FA009.md): Cessna 500 · Derby, KS · Accident · 2 fatal · Field investigation · Final report · Oct 18, 2013 · N610ED · Destroyed
  > The airplane's encounter with severe icing conditions, which resulted in structural icing, and the pilot's increased workload and subsequent disorientation while maneuvering in instrument flight rules (IFR) conditions with malfunctioning flight instruments,…
- [NTSB ENG14IA001](https://openairdocs.org/ntsb/ENG14IA001.md): Airbus A319 132 · Greenville, TX · Incident · No injuries · Incident investigation · Final report · Oct 15, 2013 · N516NK · Minor damage
  > A high pressure turbine 2nd stage blade separation due to stress corrosion cracking in the J channel cooling cavity. The failed blade entered the gas path and caused substantial damage to the low pressure turbine. The engine was subsequently left at a high…
- [NTSB ERA14CA001](https://openairdocs.org/ntsb/ERA14CA001.md): Cessna 172P · Christmas, FL · Accident · No injuries · Data collection · Final report · Oct 14, 2013 · N65704 · Substantial damage
  > An inflight collision with a bird during cruise flight.
- [NTSB CEN14WA029](https://openairdocs.org/ntsb/CEN14WA029.md): Cessna 208B · Loreto, BCS, Mexico · Accident · 14 fatal · Foreign investigation · Oct 14, 2013 · XA-TXM · Destroyed
  > On October 14, 2013, about 1401 universal time coordinated, a Cessna 208B, XA-TXM, was destroyed when it impacted terrain near Loreto, Baja California Sur, Mexico. The pilot and thirteen passengers on board were fatally injured. The flight originated from the…
- [NTSB CEN14LA030](https://openairdocs.org/ntsb/CEN14LA030.md): Piper PA 32R-300 · Hector, AR · Accident · Minor injuries · Limited investigation · Final report · Oct 14, 2013 · N5605V · Substantial damage
  > An engine failure due to crankshaft fatigue cracking for reasons that could not be determined based on the available evidence.
- [NTSB ERA14WA020](https://openairdocs.org/ntsb/ERA14WA020.md): Bell 407 - NO Series · Gobierno, Argentina · Accident · 1 fatal · Foreign investigation · Oct 13, 2013 · LQ-BHT · Substantial damage
  > On October 11, 2013, at 1900 universal coordinated time, a Bell 407, Argentinian registration LQ-BHT, impacted power lines after takeoff near Gobierno, in the province of San Juan, Argentina. The pilot and three passengers were injured and one passenger was…
- [NTSB CEN14WA013](https://openairdocs.org/ntsb/CEN14WA013.md): Enstrom 280 - FX · Wolica Kozia, Poland · Accident · 2 fatal · Foreign investigation · Oct 12, 2013 · SP-GMB · Substantial damage
  > On October 12, 2013, about 0928 hours universal coordinated time, an Enstrom 280FX, Poland registration SP-GMB, impacted trees and terrain near Wolica Kozia, Poland. The pilot and passenger were fatally injured. The accident investigation is under the…
- [NTSB CEN14LA053](https://openairdocs.org/ntsb/CEN14LA053.md): Cessna 525A · Lincoln, NE · Accident · No injuries · Limited investigation · Final report · Oct 12, 2013 · N368PK · Substantial damage
  > The airplane’s encounter with a flock of American White Pelicans, which resulted in one bird striking the right outboard wing during en route climb from the departure airport.
- [NTSB ENG14WA002](https://openairdocs.org/ntsb/ENG14WA002.md): Airbus A330 - 302 · Caines, Australia, Australia · Incident · No injuries · Foreign investigation · Oct 10, 2013 · B-18358 · Minor damage
  > On October 4, 2013, a China Airlines Airbus A330-302, powered by General Electric CF6-80E1A4 turbofan engines experienced a No. 1 engine starter failure while at cruise after takeoff from Sydney Airport, Sydney Australia. The flight crew shutdown the engine…
- [NTSB ERA14LA007](https://openairdocs.org/ntsb/ERA14LA007.md): Britten-Norman BN-2A-8 · Culebra, PR · Accident · 1 fatal · Limited investigation · Final report · Oct 6, 2013 · N909GD · Substantial damage
  > The pilot's failure to maintain airplane control for reasons that could not be determined because the wreckage was not recovered.
- [NTSB WPR14CA006](https://openairdocs.org/ntsb/WPR14CA006.md): Siemens Rotorway Exec 162F · Nampa, ID · Accident · Minor injuries · Data collection · Final report · Oct 5, 2013 · N104BJ · Substantial damage
  > A flight control malfunction during cruise flight for reasons that could not be determined. No follow-up examination was conducted due to a lapse in agency funding and subsequent government shutdown.
- [NTSB CEN14WA536](https://openairdocs.org/ntsb/CEN14WA536.md): Sikorsky S92 · Stavanger, Norway · Accident · No injuries · Foreign investigation · Oct 4, 2013 · LN-ONW · No damage
  > On October 4, 2013, at 1435 coordinated universal time (UTC), a Sikorsky S-92A helicopter, Norwegian registration LN-ONW, made an emergency landing on the unmanned and decommissioned Yme oil rig. The two crew members and 12 passengers were uninjured. The…
- [NTSB WPR14CA004](https://openairdocs.org/ntsb/WPR14CA004.md): Venables Zenith CH701 · Snohomish, WA · Accident · Minor injuries · Data collection · Final report · Oct 3, 2013 · N143TZ · Substantial damage
  > A jammed rudder control while maneuvering in the pattern for reasons that could not be determined. No follow-up examination was conducted due to a lapse in agency funding and subsequent government shutdown.
- [NTSB ERA13CA435](https://openairdocs.org/ntsb/ERA13CA435.md): Aeronca 65 CA · Thomaston, GA · Accident · Minor injuries · Data collection · Final report · Sep 30, 2013 · N33879 · Substantial damage
  > The pilot's inadequate pre-flight planning and in-flight monitoring of the fuel level which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB WPR13WA433](https://openairdocs.org/ntsb/WPR13WA433.md): Bell 212 - NO Series · Murbad, Thane District, India, India · Accident · 5 fatal · Foreign investigation · Sep 29, 2013 · VT-HGB · Destroyed
  > On September 29, 2013, at 0820 universal coordinated time, a Bell 212, VT-HGB, collided with terrain during cruise flight near Murbad (Thane District), India. The helicopter was destroyed and two flight crew and three passengers were fatally injured. The…
- [NTSB ENG13WA043](https://openairdocs.org/ntsb/ENG13WA043.md): Boeing 737 - 53C · Cusco, Peru · Incident · No injuries · Class 5 · Foreign · Sep 27, 2013 · OB-2041-P · No damage
  > On September 26, 2013, about 2042 EST, a BOEING 737 - 53C airplane, OB-2041-P, experienced an in-flight engine shutdown near Cusco, Peru. The pilot was not injured. The airplane was not damaged. The investigation is under the jurisdiction of the government of…
- [NTSB CEN13LA565](https://openairdocs.org/ntsb/CEN13LA565.md): Cessna 210-5(205) · Weatherford, OK · Accident · No injuries · Limited investigation · Final report · Sep 25, 2013 · N8472Z · Substantial damage
  > The pilot’s inadequate preflight inspection and fuel planning, which resulted in fuel exhaustion and a total loss of engine power during descent.
- [NTSB CEN13LA561](https://openairdocs.org/ntsb/CEN13LA561.md): Weatherly 620 · Ulysses, KS · Accident · No injuries · Limited investigation · Final report · Sep 25, 2013 · N4623M · Destroyed
  > An in-flight fire and subsequent loss of engine power for reasons that could not be determined due to extensive fire damage to the airplane and its fuel and electrical systems.
- [NTSB CEN13LA557](https://openairdocs.org/ntsb/CEN13LA557.md): Beech 35 B33 · Urbana, IN · Accident · Serious injuries · Limited investigation · Final report · Sep 24, 2013 · N8910M · Substantial damage
  > The failure of the crankshaft following several overheating events that had led to a stress crack and the subsequent fracture forward of the No. 6 rod journal.
- [NTSB WPR13WA423](https://openairdocs.org/ntsb/WPR13WA423.md): Cessna 182 - R · Hamilton Aerodrome, Australia, Australia · Accident · 1 fatal · Foreign investigation · Sep 23, 2013 · VH-AUT · Substantial damage
  > On September 23, 2013, at 1950 universal coordinated time, a Cessna 182R, VH-AUT, collided with terrain near Hamilton Aerodrome, Australia. The flight was being operated under the pertinent civil regulations of Australia. The solo student pilot was fatally…
- [NTSB ERA13LA428](https://openairdocs.org/ntsb/ERA13LA428.md): Beech A36 · Wellington, FL · Accident · No injuries · Limited investigation · Final report · Sep 23, 2013 · N40KG · Substantial damage
  > A total loss of engine power due to an interruption in fuel flow, which was most likely due to fuel starvation. Contributing to the accident was the pilot’s failure to maintain control of the airplane while performing the subsequent forced landing to a wet…
- [NTSB CEN13LA562](https://openairdocs.org/ntsb/CEN13LA562.md): Cirrus Design SR22 · Mack, CO · Accident · Minor injuries · Limited investigation · Final report · Sep 23, 2013 · N426TF · Substantial damage
  > A total loss of engine power due to the failure of the engine crankshaft, which resulted from maintenance personnel’s application of insufficient torque on the engine case through bolts.
- [NTSB WPR13FA417](https://openairdocs.org/ntsb/WPR13FA417.md): Bell UH-1V · Cordes Lakes, AZ · Accident · 2 fatal · Field investigation · Final report · Sep 21, 2013 · N22490 · Destroyed
  > The pilot's improper maintenance on the helicopter’s main rotor blade pitch control system, which resulted in an in-flight loss of main rotor blade pitch control, mast bumping, and mast failure.
- [NTSB ERA13CA427](https://openairdocs.org/ntsb/ERA13CA427.md): Cessna 182E · Middletown Springs, VT · Accident · Minor injuries · Data collection · Final report · Sep 21, 2013 · N3152Y · Substantial damage
  > The pilot's inadequate preflight planning, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB ERA13LA421](https://openairdocs.org/ntsb/ERA13LA421.md): American Eurocopter AS350B2 · Canton, MS · Accident · Serious injuries · Limited investigation · Final report · Sep 20, 2013 · N810LE · Substantial damage
  > The pilot’s improper decision to continue flight with a low engine oil pressure warning light instead of landing immediately in accordance with the flight manual emergency checklist. Contributing to the accident was the maintenance technician’s failure to…
- [NTSB DCA13WA158](https://openairdocs.org/ntsb/DCA13WA158.md): Boeing 757 223 · San Andreas, Colombia · Incident · No injuries · Foreign investigation · Sep 19, 2013 · N676AN · No damage
  > The CAA of Colombia has notified the NTSB of an incident involving a Boeing 757-223 airplane that occurred on September 19, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the CAA of Colombia's investigation under the provisions of…
- [NTSB DCA13WA159](https://openairdocs.org/ntsb/DCA13WA159.md): Boeing 787 - 8QQ · Warsaw, Poland · Incident · No injuries · Foreign investigation · Sep 18, 2013 · SP-LRB · No damage
  > On September 18, 2013, a LOT Polish Airlines, Boeing 787-8, registration number SP-LRB, powered by two Rolls-Royce Trent 100-67B turbofan engines experienced a maintenance status message “ENG FUEL FULTER R” during cruise from Beijing Capital International…
- [NTSB WPR13WA410](https://openairdocs.org/ntsb/WPR13WA410.md): Cessna U206 - G · Croydon, Australia · Accident · 2 fatal · Foreign investigation · Sep 15, 2013 · VH-WAV · Destroyed
  > On September 15, 2013, about 1530 Eastern standard time, an Australian registered Cessna 206, VH-WAV, impacted terrain about 95 miles Southeast of Croydon, Queensland, Australia. The airplane was destroyed and the pilot and passenger were fatally injured. The…
- [NTSB ERA13CA420](https://openairdocs.org/ntsb/ERA13CA420.md): Rolladen-Schneider LS 6 · Sussex, NJ · Accident · Minor injuries · Data collection · Final report · Sep 13, 2013 · N650DP · Substantial damage
  > The pilot's improper selection of an off-airport landing site, and his subsequent failure to maintain clearance from trees during a crosswind landing in gusty wind conditions.
- [NTSB ANC13LA100](https://openairdocs.org/ntsb/ANC13LA100.md): Cessna U206F · Kotzebue, AK · Accident · Serious injuries · Limited investigation · Final report · Sep 13, 2013 · N8316Q · Substantial damage
  > The pilot’s improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.
- [NTSB ERA13LA408](https://openairdocs.org/ntsb/ERA13LA408.md): Piper PA-24-250 · Woodstock, CT · Accident · Minor injuries · Limited investigation · Final report · Sep 8, 2013 · N7333P · Substantial damage
  > The pilot’s improper preflight inspection, which resulted in fuel exhaustion and a total loss of engine power.
- [NTSB ERA13LA407](https://openairdocs.org/ntsb/ERA13LA407.md): Piper PA-32R-300 · Guntersville, AL · Accident · Minor injuries · Limited investigation · Final report · Sep 8, 2013 · N8362C · Substantial damage
  > The improper installation of the engine magneto by unknown maintenance personnel, which resulted in the magneto separating from the engine and a subsequent total loss of engine power. Contributing to the accident was the pilot's delay in proceeding directly…
- [NTSB CEN13LA536](https://openairdocs.org/ntsb/CEN13LA536.md): Sweet Wayne A Bushby Mustang II · Woodstock, IL · Accident · Minor injuries · Limited investigation · Final report · Sep 8, 2013 · N54WS · Substantial damage
  > The pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation.
- [NTSB DCA13WA168](https://openairdocs.org/ntsb/DCA13WA168.md): Cessna 206 - H · Kodoeskop, South Africa · Accident · Minor injuries · Foreign investigation · Sep 7, 2013 · ZS-PXV · Substantial damage
  > The South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Cessna T206H airplane that occurred on September 07, 2013. The NTSB has appointed a U.S. Accredited Representative to assist SACAA's investigation under the…
- [NTSB ERA13LA405](https://openairdocs.org/ntsb/ERA13LA405.md): Crowder Michael H Sonex · Waxhaw, NC · Accident · Minor injuries · Limited investigation · Final report · Sep 6, 2013 · N293SX · Substantial damage
  > The pilot/owner/builder’s improper routing of the engine’s crankshaft position sensor cable next to the engine’s exhaust system, which resulted in a total loss of engine power in flight.
- [NTSB ANC13LA102](https://openairdocs.org/ntsb/ANC13LA102.md): Piper J3L-65 · Nondalton, AK · Accident · No injuries · Limited investigation · Final report · Sep 5, 2013 · N38262 · Substantial damage
  > The fracture and subsequent failure of the No. 4 cylinder exhaust valve during cruise flight, which resulted in a total loss of engine power.
- [NTSB CEN13WA527](https://openairdocs.org/ntsb/CEN13WA527.md): Cessna T303 · Jersey · Accident · 2 fatal · Foreign investigation · Sep 4, 2013 · N289CW · Substantial damage
- [NTSB WPR13LA396](https://openairdocs.org/ntsb/WPR13LA396.md): Flight Design Ctsw · Sisters, OR · Accident · No injuries · Limited investigation · Final report · Sep 2, 2013 · N102HA · Substantial damage
  > The pilot's inadequate preflight fuel planning and poor decision-making, which resulted in fuel exhaustion and the subsequent loss of engine power. Contributing to the accident was the lack of documentation describing the limitations of the airplane’s fuel…
- [NTSB CEN13LA518](https://openairdocs.org/ntsb/CEN13LA518.md): American Champion 7GCB · Pearsall, TX · Accident · Minor injuries · Limited investigation · Final report · Sep 2, 2013 · N9967Y · Substantial damage
  > The failure of the rudder cable due to electrical arcing damage from contact with an unguarded battery and the pilot's subsequent loss of control during the go-around.
- [NTSB DCA13WA176](https://openairdocs.org/ntsb/DCA13WA176.md): Airbus A330 - 203 · Fortaleza, Brazil · Accident · Serious injuries · Foreign investigation · Sep 1, 2013 · PT-MVL · No damage
  > The Aeronautical Accident Prevention and Investigation Center of Brazil (CENIPA) has notified the NTSB of an accident involving an Airbus A330-203, registration PT-MVL, which occurred on September 1, 2013. The NTSB has appointed a U.S. Accredited…
- [NTSB ERA13WA439](https://openairdocs.org/ntsb/ERA13WA439.md): Bell 206B · Matoes do Norte, Brazil · Accident · No injuries · Foreign investigation · Aug 30, 2013 · PT-HUE · Substantial damage
  > On August 30, 2013, at 1555 coordinated universal time (1255 local time), a Bell 206B, Brazilian registration PT-HUE, was substantially damaged following a loss of engine power and a subsequent forced landing in Matões do Norte, Maranhão, Brazil. The pilot…
- [NTSB ERA13CA389](https://openairdocs.org/ntsb/ERA13CA389.md): Diamond Aircraft Ind DA 40 · Blairsville, GA · Accident · Minor injuries · Data collection · Final report · Aug 30, 2013 · N447JP · Substantial damage
  > The pilot’s decision to continue visual flight into deteriorating weather, which resulted in an encounter with instrument meteorological conditions and subsequent inability to maintain clearance with terrain.
- [NTSB ENG13WA042](https://openairdocs.org/ntsb/ENG13WA042.md): Boeing 737 · Auckland, New Zealand · Incident · No injuries · Foreign investigation · Aug 30, 2013 · ZK-NGI · No damage
  > The investigation is under the jurisdiction of the government of New Zealand. Further information pertaining to this accident may be obtained from:Transport Accident Investigation Commission PO Box 10323, The Terrace Wellington 6143, New Zealand. Website:…
- [NTSB WPR13LA390](https://openairdocs.org/ntsb/WPR13LA390.md): Bell Helicopter Textron 206L-1 · Payson, AZ · Accident · Serious injuries · Limited investigation · Final report · Aug 28, 2013 · N2018R · Substantial damage
  > A partial loss of engine power due to an overtemperature event that thermally damaged the turbine blades and vanes, which resulted in a hard landing.
- [NTSB WPR13LA389](https://openairdocs.org/ntsb/WPR13LA389.md): Champion 8KCAB · Wahiawa, HI · Accident · Serious injuries · Limited investigation · Final report · Aug 28, 2013 · N413JJ · Substantial damage
  > A total loss of engine power during cruise flight for reasons that could not be determined because postaccident examination of the engine and airframe did not reveal any anomalies that would have precluded normal operation.
- [NTSB CEN13LA514](https://openairdocs.org/ntsb/CEN13LA514.md): Challenger II · Emporia, KS · Accident · Minor injuries · Limited investigation · Final report · Aug 28, 2013 · UNREG · Substantial damage
  > The right wing’s folding up in flight for reasons that could not be determined because an examination did not reveal any abnormalities with the airframe that would have precluded normal operation.
- [NTSB ANC13LA085](https://openairdocs.org/ntsb/ANC13LA085.md): Cessna U206F · Tokotna, AK · Accident · No injuries · Limited investigation · Final report · Aug 24, 2013 · N35952 · Substantial damage
  > A total loss of engine power due to the failure of the crankshaft, which resulted from a mechanic’s application of insufficient torque on the cylinder through bolts.

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

## 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=82

---
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.