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

## Cases, newest first

- [NTSB ANC12CA063](https://openairdocs.org/ntsb/ANC12CA063.md): Piper PA-32-301 · King Salmon, AK · Accident · No injuries · Data collection · Final report · Jun 28, 2012 · N8470Y · Substantial damage
  > An in-flight collision with a bird during cruise flight.
- [NTSB WPR12CA278](https://openairdocs.org/ntsb/WPR12CA278.md): Schweizer SGS 1-36 · Bishop, CA · Accident · No injuries · Data collection · Final report · Jun 27, 2012 · N3617U · Substantial damage
  > The glider’s encounter with insufficient atmospheric lift to maintain soaring flight, which resulted in an off-airport landing.
- [NTSB ERA12LA417](https://openairdocs.org/ntsb/ERA12LA417.md): Luters Arnis V Legend · Glenwood, FL · Accident · No injuries · Limited investigation · Final report · Jun 27, 2012 · N3YZ · Substantial damage
  > The total loss of engine power due to the airplane builder’s improper installation of the fuel control unit condition lever cables, which resulted in the airplane’s subsequent forced landing.
- [NTSB CEN12FA395](https://openairdocs.org/ntsb/CEN12FA395.md): Nappi Tito C Lancair 235M · Monroe Center, IL · Accident · 1 fatal · Field investigation · Final report · Jun 26, 2012 · N18TN · Substantial damage
  > The in-flight fire for a reason that could not be determined due to extensive damage from the fire.
- [NTSB ANC12LA058](https://openairdocs.org/ntsb/ANC12LA058.md): Piper PA-32-300 · Gustavus, AK · Accident · No injuries · Limited investigation · Final report · Jun 25, 2012 · N8908N · Substantial damage
  > The fatigue failure of the engine crankshaft for reasons that could not be determined during postaccident metallurgical examination.
- [NTSB WPR12LA275](https://openairdocs.org/ntsb/WPR12LA275.md): Dehavilland Tiger Moth DH 82A · Fontana, CA · Accident · No injuries · Limited investigation · Final report · Jun 24, 2012 · N523R · Substantial damage
  > Partial loss of engine power during cruise flight due to a failed engine cylinder rocker assembly clamping bolt. Contributing to the accident was the failure of unknown maintenance personnel to perform a modification to the assembly that would have prevented…
- [NTSB CEN12LA389](https://openairdocs.org/ntsb/CEN12LA389.md): Hoyle Fighter Escort Wings · Pueblo, CO · Accident · No injuries · Limited investigation · Final report · Jun 23, 2012 · N2051P · Substantial damage
  > An internal failure of one of the electrical system’s two batteries combined with the inadequate electrical system design, which resulted in a total loss of engine power.
- [NTSB CEN12LA388](https://openairdocs.org/ntsb/CEN12LA388.md): Cessna A150K · Mamou, LA · Accident · No injuries · Limited investigation · Final report · Jun 23, 2012 · N8380M · Substantial damage
  > The pilot's inadequate preflight inspection, which resulted in a partial loss of engine power due to fuel contamination.
- [NTSB WPR12LA309](https://openairdocs.org/ntsb/WPR12LA309.md): Beech A36 · Rock Springs, WY · Accident · No injuries · Limited investigation · Final report · Jun 22, 2012 · N4972M · Substantial damage
  > The total loss of engine power due to fuel starvation because of the incorrectly installed fuel cap. Contributing to the accident was the pilot’s decision to continue the flight using fuel from the left fuel tank after she observed fuel streaming from the…
- [NTSB ERA12LA410](https://openairdocs.org/ntsb/ERA12LA410.md): Piper J5A · Atlantic Ocean (Atlantic Ocean) · Accident · No injuries · Limited investigation · Final report · Jun 22, 2012 · N40985 · Substantial damage
  > A loss of engine power for reasons that could not be determined because the aircraft sank after ditching and was not recovered.
- [NTSB ERA12FA409](https://openairdocs.org/ntsb/ERA12FA409.md): Raytheon C90GT · Morgantown, WV · Accident · 1 fatal · Field investigation · Final report · Jun 22, 2012 · N508GT · Substantial damage
  > The pilot's inadequate preflight route planning and in-flight route and altitude selection, which resulted in an in-flight collision with a communications tower in possible instrument meteorological conditions. Contributing to the accident were the pilot's…
- [NTSB ANC12CA059](https://openairdocs.org/ntsb/ANC12CA059.md): Dosser Dale A Blade 582 · Two Rivers, AK · Accident · No injuries · Data collection · Final report · Jun 20, 2012 · N907AD · Substantial damage
  > The total loss of engine power during cruise flight due to fouled spark plugs, which resulted from a stuck mixture control.
- [NTSB CEN12IA377](https://openairdocs.org/ntsb/CEN12IA377.md): Piper PA-28R-200 · Lacon, IL · Incident · No injuries · Incident investigation · Final report · Jun 18, 2012 · N4350T · Minor damage
  > The propeller blade’s failure due to a fatigue crack that originated from a surface gouge that resulted from foreign object damage to the propeller blade that occurred at an unknown time.
- [NTSB ERA12FA395](https://openairdocs.org/ntsb/ERA12FA395.md): Remos Acft Gmbh Flugzeugbau Remos GX · Westminster, MD · Accident · 1 fatal · Field investigation · Final report · Jun 15, 2012 · N206GX · Substantial damage
  > The pilot's inadequate preflight inspection, which failed to ensure that the elevator quick-fastener was properly secured, resulting in an inflight elevator control disconnect and subsequent loss of control during the ensuing emergency landing. Contributing…
- [NTSB ERA12LA399](https://openairdocs.org/ntsb/ERA12LA399.md): Robinson Helicopter R22 Mariner · Oak Island, NC · Accident · No injuries · Limited investigation · Final report · Jun 14, 2012 · N1089N · Substantial damage
  > The pilot's failure to properly execute the helicopter practice autorotation recovery, which resulted in a collision with the water.
- [NTSB ANC12LA051](https://openairdocs.org/ntsb/ANC12LA051.md): Dehavilland DHC-2 · Talkeetna, AK · Accident · No injuries · Limited investigation · Final report · Jun 14, 2012 · N121KT · Substantial damage
  > The loss of engine power after departure due to the separation of an engine cylinder.
- [NTSB ERA12LA394](https://openairdocs.org/ntsb/ERA12LA394.md): Piper PA-28-180 · Ocilla, GA · Accident · Minor injuries · Limited investigation · Final report · Jun 13, 2012 · N9238J · Substantial damage
  > A failure of the No. 2 cylinder connecting rod due to a lack of lubrication, which resulted in a total loss of engine power.
- [NTSB DCA12LA091](https://openairdocs.org/ntsb/DCA12LA091.md): Boeing 737-724 · Winnie, TX · Accident · Serious injuries · Limited investigation · Final report · Jun 13, 2012 · N16709 · No damage
  > the flight crew's penetration of a rapidly developing thunderstorm cell in an area of forecasted convective activity. The serious injuries were the result of a misunderstanding between the captain and cabin crew regarding the potential for turbulence.
- [NTSB WPR12LA256](https://openairdocs.org/ntsb/WPR12LA256.md): Ayres S2R-G6 · Riverton, WY · Accident · No injuries · Limited investigation · Final report · Jun 11, 2012 · N70WY · Substantial damage
  > An engine overspeed shortly after takeoff for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB WPR12CA257](https://openairdocs.org/ntsb/WPR12CA257.md): Cessna 182A · Colfax, WA · Accident · No injuries · Data collection · Final report · Jun 11, 2012 · N4715D · Substantial damage
  > The total loss of engine power during cruise flight due to the missing carburetor drain plug, which had not been secured with safety wire.
- [NTSB WPR12LA253](https://openairdocs.org/ntsb/WPR12LA253.md): Cessna 172B · San Andreas, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 9, 2012 · N7458X · Substantial damage
  > A loss of engine power in cruise flight for reasons that could not be determined because a postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR12FA255](https://openairdocs.org/ntsb/WPR12FA255.md): Piper PA-32-300 · Mountain Home, ID · Accident · 1 fatal · Field investigation · Final report · Jun 9, 2012 · N8990N · Substantial damage
  > The noninstrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in controlled flight into mountainous terrain.
- [NTSB WPR12CA209](https://openairdocs.org/ntsb/WPR12CA209.md): Piper PA-28-140 · Sula, MT · Accident · Minor injuries · Data collection · Final report · Jun 8, 2012 · N2839T · Substantial damage
  > The pilot's inability to maintain clearance from terrain while operating in a downdraft over mountainous terrain.
- [NTSB ERA12FA385](https://openairdocs.org/ntsb/ERA12FA385.md): Pilatus PC-12/47 · Lake Wales, FL · Accident · 6 fatal · Field investigation · Final report · Jun 7, 2012 · N950KA · Substantial damage
  > The failure of the pilot to maintain control of the airplane while climbing to cruise altitude in instrument meteorological conditions (IMC) following disconnect of the autopilot. The reason for the autopilot disconnect could not be determined during…
- [NTSB DCA12CA086](https://openairdocs.org/ntsb/DCA12CA086.md): Boeing 757 2B7 · Philadelphia, PA · Accident · Serious injuries · Data collection · Final report · Jun 7, 2012 · N936UW · No damage
  > an inadvertent encounter with convective turbulence.
- [NTSB DCA12WA089](https://openairdocs.org/ntsb/DCA12WA089.md): Sikorsky S58 · Cusco, Peru · Accident · 14 fatal · Foreign investigation · Jun 6, 2012 · OB-1840-P · Destroyed
  > The Comisión de Investigación de Accidentes de Aviación of Peru (CIAA) has notified the NTSB of an accident involving a Sikorsky S58 helicopter that occurred on June 06, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the CIAA…
- [NTSB ERA12LA379](https://openairdocs.org/ntsb/ERA12LA379.md): Bell 427 · Indiantown, FL · Accident · Minor injuries · Limited investigation · Final report · Jun 4, 2012 · N427AL · Substantial damage
  > The inflight collision with birds, resulting in damage to the rotor head assembly and a subsequent forced landing and rollover.
- [NTSB ANC12CA050](https://openairdocs.org/ntsb/ANC12CA050.md): Walls Craig C Snowyriver Special · Chugiak, AK · Accident · No injuries · Data collection · Final report · Jun 3, 2012 · N207CW · Substantial damage
  > The pilot’s improper fuel planning, which resulted in fuel exhaustion and a total loss of engine power during descent.
- [NTSB ERA12WA383](https://openairdocs.org/ntsb/ERA12WA383.md): Piper PA-28R-200 · São Paulo, Brazil · Accident · 1 fatal · Foreign investigation · Jun 2, 2012 · PT-KRF · Destroyed
- [NTSB ERA12LA380](https://openairdocs.org/ntsb/ERA12LA380.md): Pittman Eddie G CGS Hawk Arrow II · Monroe, VA · Accident · Minor injuries · Limited investigation · Final report · Jun 2, 2012 · N443EP · Substantial damage
  > The pilot’s improper preflight planning and inflight fuel management, which resulted in the total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s unfamiliarity with the airplane’s systems.
- [NTSB ANC12LA046](https://openairdocs.org/ntsb/ANC12LA046.md): Cessna A185F · Skwentna, AK · Accident · No injuries · Limited investigation · Final report · Jun 2, 2012 · N1795R · Substantial damage
  > The pilot's improper fuel management, which resulted in fuel starvation and a total loss of engine power in cruise flight. Contributing to the accident was the pilot's failure to follow the checklist after the loss of engine power.
- [NTSB ERA12FA376](https://openairdocs.org/ntsb/ERA12FA376.md): Hawker Beechcraft A36 · Macon, MS · Accident · 1 fatal · Field investigation · Final report · May 31, 2012 · N976S · Substantial damage
  > The pilot's decision to continue flight into an area of known thunderstorms, which resulted in an in-flight breakup. Contributing to the accident was the pilot's lack of experience in actual instrument meteorological conditions and his reliance on datalink…
- [NTSB ERA12LA366](https://openairdocs.org/ntsb/ERA12LA366.md): Bell 206B · Longboat Key, FL · Accident · No injuries · Limited investigation · Final report · May 25, 2012 · N806LA · Substantial damage
  > Unknown personnel's failure to comply with the engine manufacturer's engine fuel pump replacement guidance, which resulted in a total loss of engine power due to the engine fuel pump failure.
- [NTSB CEN12LA326](https://openairdocs.org/ntsb/CEN12LA326.md): Mooney M20J · Ozark, AR · Accident · Minor injuries · Limited investigation · Final report · May 25, 2012 · N2159D · Substantial damage
  > The failure of a connecting rod due to oil starvation.
- [NTSB ERA12LA356](https://openairdocs.org/ntsb/ERA12LA356.md): Canadair CL-600-2B16 · Hallandale, FL · Accident · No injuries · Limited investigation · Final report · May 23, 2012 · N207JB · Substantial damage
  > The failure of the co-pilot to properly close and latch the passenger door before departure, and the flight crew's failure to ensure that the door was secure by using the door warning system. Contributing to the accident was the flight crew's inadequate use…
- [NTSB WPR12FA222](https://openairdocs.org/ntsb/WPR12FA222.md): Cessna P210N · Glendale, CA · Accident · Minor injuries · Field investigation · Final report · May 22, 2012 · N732JL · Substantial damage
  > The partial loss of engine power during descent for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR12LA219](https://openairdocs.org/ntsb/WPR12LA219.md): Enstrom F28 · Twin Falls, ID · Accident · No injuries · Limited investigation · Final report · May 20, 2012 · N63VP · Substantial damage
  > The pilot's inability to maintain helicopter control during cruise flight due to the failure of the No. 2 main rotor Lamiflex bearing. Contributing to the accident was the pilot's decision to operate the helicopter with a known deficiency and the helicopter’s…
- [NTSB ERA12LA349](https://openairdocs.org/ntsb/ERA12LA349.md): Belcher, Gerald C BEL Aire 2000 · Tyre, NY · Accident · Minor injuries · Limited investigation · Final report · May 20, 2012 · N122BA · Substantial damage
  > A partial loss of engine power for reasons that could not be determined during the postaccident investigation.
- [NTSB ERA12LA343](https://openairdocs.org/ntsb/ERA12LA343.md): Cessna 195A · Tipton, PA · Accident · No injuries · Limited investigation · Final report · May 18, 2012 · N9859A · Substantial damage
  > A fatigue failure of a copper oil line, which resulted in a partial loss of engine power due to oil starvation.
- [NTSB DCA12WA081](https://openairdocs.org/ntsb/DCA12WA081.md): Boeing 737-800 · Dusseldorf, Germany · Accident · No injuries · Foreign investigation · May 17, 2012 · D-ASXH · No damage
  > The German Federal Bureau of Aircraft Accidents (BFU) has notified the NTSB of an accident involving a Boeing 737 that occurred on May 17, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the BFU investigation under the provisions of…
- [NTSB CEN12LA302](https://openairdocs.org/ntsb/CEN12LA302.md): Troyer Kitfox 3 · Elm Creek, NE · Accident · Serious injuries · Limited investigation · Final report · May 14, 2012 · N7199T · Substantial damage
  > The pilot’s failure to verify the amount of oil in the injection oil reservoir before takeoff, which resulted in an insufficient fuel/oil ratio and subsequent loss of engine power.
- [NTSB WPR12FA203](https://openairdocs.org/ntsb/WPR12FA203.md): M Squared Breese · Whitewater, CA · Accident · 1 fatal · Field investigation · Final report · May 13, 2012 · N51336 · Substantial damage
  > The pilot’s decision to fly at low altitude in mountainous terrain in the presence of strong wind and turbulence, which resulted in an aerodynamic upset at too low an altitude for recovery.
- [NTSB ERA12LA332](https://openairdocs.org/ntsb/ERA12LA332.md): Stinson SR-7B · West Ossipee, NH · Accident · Serious injuries · Limited investigation · Final report · May 13, 2012 · N16122 · Substantial damage
  > The pilot's inadequate application of carburetor heat which resulted in the formation of carburetor ice and a partial loss of engine power.
- [NTSB CEN12FA290](https://openairdocs.org/ntsb/CEN12FA290.md): Cessna 401 · Chanute, KS · Accident · 4 fatal · Field investigation · Final report · May 11, 2012 · N9DM · Substantial damage
  > The malfunction of the cabin heater, which resulted in an inflight fire and smoke in the airplane. Contributing to the accident was the pilot’s lack of understanding concerning the status of the airplane's heater system following and earlier overheat event…
- [NTSB DCA12FA069](https://openairdocs.org/ntsb/DCA12FA069.md): Airbus A319-112 · Fort Lauderdale, FL · Accident · Serious injuries · Field investigation · Final report · May 10, 2012 · N951FR · No damage
  > an inadvertent encounter with convectively induced turbulence developing upwards into the flight path, which was not detected on weather radar as configured by the crew. Contributing to the delay in emergency medical personnel notification was the incomplete…
- [NTSB DCA12WA071](https://openairdocs.org/ntsb/DCA12WA071.md): Sukhoi SJ100 · Mt. Salak, Indonesia · Accident · 44 fatal · Foreign investigation · May 9, 2012 · RP97004 · Destroyed
  > On May 9, 2012, at 1450 local time, a Sukhoi SJ100-95, Russian registration RP97004, collided with terrain about 35 miles south of Jakarta, Indonesia. The airplane was on a demonstration flight. The 40 passengers and 4 crew were fatally injured, and the…
- [NTSB CEN12LA288](https://openairdocs.org/ntsb/CEN12LA288.md): Donald K Stovall Pietenpol Aircamper · Rose Hill, KS · Accident · No injuries · Limited investigation · Final report · May 9, 2012 · N728MK · Substantial damage
  > The loss of engine power due to carburetor icing.
- [NTSB ERA12WA504](https://openairdocs.org/ntsb/ERA12WA504.md): Piper PA-28-235 · Tartu, Estonia · Accident · Minor injuries · Foreign investigation · May 4, 2012 · YL-MED · Destroyed
  > On May 4, 2012, about 2055 universal coordinated time, a Piper PA-28-235, Latvian registration YL-MED, was substantially damaged when it impacted a ditch, during a forced landing at night after a loss of power near Tartu Ulenurme Airport (EETU), Tartu,…
- [NTSB CEN12CA274](https://openairdocs.org/ntsb/CEN12CA274.md): Air Tractor AT-301 · Cedar Bluffs, NE · Accident · No injuries · Data collection · Final report · May 3, 2012 · N3166W · Substantial damage
  > The pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB WPR12FA191](https://openairdocs.org/ntsb/WPR12FA191.md): Hughes 269C · Phoenix, AZ · Accident · Serious injuries · Field investigation · Final report · May 2, 2012 · N380TL · Substantial damage
  > A loss of tail rotor drive due to a fatigue failure of the main transmission pinion, which resulted in a loss of directional control during cruise flight.

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

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

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