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

## Cases, newest first

- [NTSB ERA12LA574](https://openairdocs.org/ntsb/ERA12LA574.md): Cessna 150G · Corinth, MS · Accident · Minor injuries · Limited investigation · Final report · Sep 21, 2012 · N8465J · Substantial damage
  > The improper torque application on the crankshaft gear bolt by maintenance personnel during an engine overhaul, which resulted in the fatigue failure of the locking tab washer and gear alignment dowel and subsequent engine stoppage. Contributing to the…
- [NTSB ERA12LA571](https://openairdocs.org/ntsb/ERA12LA571.md): Beagle B206 Series 2 · Perry, FL · Accident · No injuries · Limited investigation · Final report · Sep 21, 2012 · N26GW · Substantial damage
  > The pilot’s improper in-flight fuel management, which resulted in fuel starvation and the right engine’s complete loss of power. Contributing to the accident was the pilot’s improper configuration of the airplane following the loss of engine power.
- [NTSB CEN12IA662](https://openairdocs.org/ntsb/CEN12IA662.md): Canadair CL-600 Challenger · Denver, CO · Incident · No injuries · Incident investigation · Final report · Sep 21, 2012 · N125PS · No damage
  > The internal failure of the galley heater mat’s thermostat, which resulted in an overheat condition.
- [NTSB CEN12LA652](https://openairdocs.org/ntsb/CEN12LA652.md): Beech 95-C55 · (Gulf of Mexico) · Accident · Minor injuries · Limited investigation · Final report · Sep 20, 2012 · N265Q · Substantial damage
  > An in-flight fire, which resulted in the airplane’s forced landing in water. The source of the fire could not be determined because the airplane wreckage was not recovered.
- [NTSB ERA12CA568](https://openairdocs.org/ntsb/ERA12CA568.md): Cessna 172M · Quitman, MS · Accident · Serious injuries · Data collection · Final report · Sep 19, 2012 · N172HA · Substantial damage
  > The pilot’s improper preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB DCA12CA149](https://openairdocs.org/ntsb/DCA12CA149.md): Airbus Industrie A330-323 · Sophia, NC · Accident · Serious injuries · Data collection · Final report · Sep 18, 2012 · N273AY · No damage
  > an encounter with moderate turbulence while the flight attendant was securing the cabin for arrival.
- [NTSB WPR12CA429](https://openairdocs.org/ntsb/WPR12CA429.md): Piper PA-14 · Emmett, ID · Accident · Minor injuries · Data collection · Final report · Sep 17, 2012 · N5196H · Substantial damage
  > The pilot’s failure to maintain clearance from terrain.
- [NTSB ERA12FA566](https://openairdocs.org/ntsb/ERA12FA566.md): Mooney M20M · Crane Hill, AL · Accident · 2 fatal · Field investigation · Final report · Sep 17, 2012 · N1085A · Substantial damage
  > The pilot’s loss of control in moderate-to-heavy rain. Contributing to the accident was the pilot’s reliance on ADS-B for tactical weather avoidance.
- [NTSB ERA12FA563](https://openairdocs.org/ntsb/ERA12FA563.md): Aerospatiale AS 355F1 · West Windsor, NJ · Accident · 1 fatal · Field investigation · Final report · Sep 15, 2012 · N58020 · Substantial damage
  > Disconnection of the upper rod end from the fore/aft servo due to severely worn threads, which resulted in a loss of control and separation of a main rotor blade during cruise flight. Contributing to the accident were incorrect maintenance procedures and…
- [NTSB WPR12LA417](https://openairdocs.org/ntsb/WPR12LA417.md): Seymour Skyranger · Perris, CA · Accident · Minor injuries · Limited investigation · Final report · Sep 13, 2012 · N936LS · Substantial damage
  > A loss of aircraft control during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR12FA420](https://openairdocs.org/ntsb/WPR12FA420.md): Piper PA-28-181 · Strawberry, AZ · Accident · 3 fatal · Field investigation · Final report · Sep 13, 2012 · N4188E · Substantial damage
  > The flight instructor's and the evaluator's failure to divert at an appropriate time during cruise flight, which resulted in the airplane's inability to maintain a sufficient altitude to clear rising terrain. Contributing to the accident was the flight…
- [NTSB CEN12LA632](https://openairdocs.org/ntsb/CEN12LA632.md): Bruce M Barrett Stolp Starlet SA500 · Shelbyville, IL · Accident · No injuries · Limited investigation · Final report · Sep 13, 2012 · N935B · Substantial damage
  > An abrupt, complete loss of engine power during cruise flight for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB CEN12FA639](https://openairdocs.org/ntsb/CEN12FA639.md): Mooney M20J · Teddys Peak, CO · Accident · 2 fatal · Field investigation · Final report · Sep 13, 2012 · N58119 · Substantial damage
  > The pilot's decision to continue flight into deteriorating weather conditions, including fog and mountain obscuration, and his failure to maintain clearance with known rising terrain along the route of flight, which resulted in controlled flight into terrain.
- [NTSB WPR12LA411](https://openairdocs.org/ntsb/WPR12LA411.md): Cessna A185F · Cambria, CA · Accident · No injuries · Limited investigation · Final report · Sep 9, 2012 · N80SS · Substantial damage
  > A partial loss of engine power during cruise flight for reasons that could not be determined because the airplane sank in the ocean and was not recovered.
- [NTSB CEN12FA617](https://openairdocs.org/ntsb/CEN12FA617.md): Beech A36 · Kansasville, WI · Accident · 1 fatal · Field investigation · Final report · Sep 9, 2012 · N3224G · Substantial damage
  > In-flight loss of control for reasons that could not be determined because postaccident examination of the pilot and testing of the airplane did not reveal any anomalies that would have led to the loss of control.
- [NTSB DCA12WA145](https://openairdocs.org/ntsb/DCA12WA145.md): Boeing 737-800 · Gran Canaria, Spain · Incident · No injuries · Foreign investigation · Sep 7, 2012 · EI-EKV · No damage
  > The Civil Aviation Accident and Incident Investigation Commission (CIAIAC) of Spain, has notified the NTSB of an accident involving a Boeing 737-800 that occurred on September 7, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the…
- [NTSB WPR12LA402](https://openairdocs.org/ntsb/WPR12LA402.md): Hansen HANSEN-VANS RV-6 · Lemolo Lake, OR · Accident · Serious injuries · Limited investigation · Final report · Sep 5, 2012 · N53MH · Substantial damage
  > An overvoltage event due to the failure of the automotive voltage regulator, which resulted in electrical anomalies and smoke in the cockpit and a subsequent forced off-airport landing.
- [NTSB DCA12IA141](https://openairdocs.org/ntsb/DCA12IA141.md): De Havilland DHC8 · Soldotna, AK · Incident · No injuries · Incident investigation · Final report · Sep 5, 2012 · N886EA · No damage
  > an in-flight loss of control due to the flight crew's inattention to airspeed, pitch attitude, and engine power during the climb leading to an aerodynamic stall. Contributing to the incident was the flight crew's failure to recognize and properly recover from…
- [NTSB WPR12CA400](https://openairdocs.org/ntsb/WPR12CA400.md): Piper PA-32-300 · Lancaster, CA · Accident · No injuries · Data collection · Final report · Sep 4, 2012 · N308DF · Substantial damage
  > The student pilot’s inadvertent selection of an empty fuel tank.
- [NTSB ERA12LA543](https://openairdocs.org/ntsb/ERA12LA543.md): Cessna T210M · Tillatoba, MS · Accident · Serious injuries · Limited investigation · Final report · Sep 3, 2012 · N761YN · Substantial damage
  > The pilot's improper fuel management and his decision to continue flight in deteriorating weather conditions with low fuel, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB WPR12LA396](https://openairdocs.org/ntsb/WPR12LA396.md): Beech G35 · Oceano, CA · Accident · No injuries · Limited investigation · Final report · Aug 31, 2012 · N4454D · Substantial damage
  > The pilot’s exceedance of the design maneuvering speed during descent in turbulence, which resulted in structural damage to the aft fuselage.
- [NTSB WPR12LA382](https://openairdocs.org/ntsb/WPR12LA382.md): Mooney M20J · Chelan, WA · Accident · Minor injuries · Limited investigation · Final report · Aug 31, 2012 · N132PC · Substantial damage
  > A loss of engine power during climb for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB ERA12TA538](https://openairdocs.org/ntsb/ERA12TA538.md): Bell 407 · Bath, NY · Accident · Minor injuries · Final report · Aug 31, 2012 · N11SP · Substantial damage
  > The pilot's improper recovery from an in-flight upset, which resulted in the main rotor striking and separating the tail boom. Contributing to the accident was the helicopter manufacturer's failure to warn pilots of unanticipated and unequal aft cyclic…
- [NTSB ERA12LA539](https://openairdocs.org/ntsb/ERA12LA539.md): Cessna 172M · Canadensis, PA · Accident · No injuries · Limited investigation · Final report · Aug 31, 2012 · N391R · Substantial damage
  > The pilot’s failure to attain a proper glidepath.
- [NTSB ANC12FA095](https://openairdocs.org/ntsb/ANC12FA095.md): Bellanca 7GCBC · Homer, AK · Accident · 1 fatal · Field investigation · Final report · Aug 31, 2012 · N57511 · Substantial damage
  > The pilot's failure to see and avoid high tension power lines.
- [NTSB WPR12LA394](https://openairdocs.org/ntsb/WPR12LA394.md): Bellanca 14-19-3 · Healdsburg, CA · Accident · No injuries · Limited investigation · Final report · Aug 30, 2012 · N1299R · Substantial damage
  > The loss of engine power during cruise flight due to the failure of the engine-driven fuel pump as a result of unidentified debris within the vapor return jet.
- [NTSB WPR12LA392](https://openairdocs.org/ntsb/WPR12LA392.md): Cessna 210 · Kemmerer, WY · Accident · No injuries · Limited investigation · Final report · Aug 30, 2012 · N7321E · Substantial damage
  > The total loss of engine power due to fuel exhaustion. Contributing to the accident was the incorrect installation of the fuel bladder tanks.
- [NTSB CEN12LA587](https://openairdocs.org/ntsb/CEN12LA587.md): Aviat A-1 · Rolla, ND · Accident · No injuries · Limited investigation · Final report · Aug 29, 2012 · N49363 · Substantial damage
  > The pilot's failure to secure the right wing's fuel cap before the flight and to properly manage the available fuel supply during the flight, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB CEN12FA586](https://openairdocs.org/ntsb/CEN12FA586.md): Piper PA-23-150 · Canton, MO · Accident · 2 fatal · Field investigation · Final report · Aug 29, 2012 · N1486P · Substantial damage
  > The pilot's improper decision to attempt to execute a forced landing to an open field with obstacles. Contributing to the accident was the left engine’s total loss of power due to fuel starvation as a result of the introduction of air into the fuel system…
- [NTSB CEN12LA582](https://openairdocs.org/ntsb/CEN12LA582.md): Waco UPF-7 · Jim Falls, WI · Accident · No injuries · Limited investigation · Final report · Aug 27, 2012 · N32011 · Substantial damage
  > The blockage of the right fuel tank vent, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB ERA12FA526](https://openairdocs.org/ntsb/ERA12FA526.md): Beech B24R · Dayton, VA · Accident · 1 fatal · Field investigation · Final report · Aug 26, 2012 · N9200S · Substantial damage
  > The pilot's improper fuel management, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the noninstrument-rated pilot's decision to attempt a visual flight rules flight in instrument meteorological conditions…
- [NTSB CEN12FA572](https://openairdocs.org/ntsb/CEN12FA572.md): Eberle John S Fokker DR-1 Triplane · Parker, CO · Accident · Serious injuries · Field investigation · Final report · Aug 26, 2012 · N152RB · Substantial damage
  > The pilot's loss of control of the airplane due to the airplane’s reduced climb performance during high density altitude operations.
- [NTSB ANC12LA093](https://openairdocs.org/ntsb/ANC12LA093.md): Cessna U206D · Nikolai, AK · Accident · No injuries · Limited investigation · Final report · Aug 25, 2012 · N729RV · Substantial damage
  > The total loss of engine power for reasons that could not be determined because the engine was not made available for examination.
- [NTSB CEN12LA583](https://openairdocs.org/ntsb/CEN12LA583.md): Cessna 150M · Arrow Rock, MO · Accident · No injuries · Limited investigation · Final report · Aug 24, 2012 · N63672 · Substantial damage
  > The pilot's inadequate fuel management and in-flight decision making, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN12FA571](https://openairdocs.org/ntsb/CEN12FA571.md): Piper PA-24-250 · Milner, CO · Accident · 1 fatal · Field investigation · Final report · Aug 24, 2012 · N7774P · Substantial damage
  > The student pilot's impairment from alcohol, marijuana, and hypoxia, which adversely affected his ability to maintain control of the airplane.
- [NTSB ERA12LA522](https://openairdocs.org/ntsb/ERA12LA522.md): Piper PA-28RT-201T · Hernando Beach, FL · Accident · No injuries · Limited investigation · Final report · Aug 22, 2012 · N2970G · Substantial damage
  > A partial loss of engine power due to a blockage of the No. 6 cylinder fuel injector nozzle.
- [NTSB WPR12LA365](https://openairdocs.org/ntsb/WPR12LA365.md): Cessna 182Q · McCall, ID · Accident · Minor injuries · Limited investigation · Final report · Aug 20, 2012 · N735KV · Substantial damage
  > The flight instructor’s selection of the wrong route while flying in mountainous terrain at a high-density altitude, which resulted in the airplane impacting terrain when the increase in elevation exceeded the airplane’s climb performance.
- [NTSB ERA12WA530](https://openairdocs.org/ntsb/ERA12WA530.md): Embraer EMB711 · Sta Barbara D'Oeste, Brazil · Accident · 4 fatal · Foreign investigation · Aug 18, 2012 · PT-NKA · 2 aircraft · Substantial damage
  > On August 18, 2012, at 1140 UTC an Embraer EMB-711C (Piper PA-28R-200), Brazilian registration PT-NKA, registered to a private owner, and a Embraer EMB-711C (Piper PA-28R-200), Brazilian registration PT-NIR, registered to a private owner, collided in cruise…
- [NTSB ERA12TA515](https://openairdocs.org/ntsb/ERA12TA515.md): Bell 206B · San Juan, PR · Accident · No injuries · Final report · Aug 18, 2012 · N118EC · Substantial damage
  > The crew’s inadequate preflight inspection and failure to monitor the fuel state during flight, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN12LA558](https://openairdocs.org/ntsb/CEN12LA558.md): Beech A36 · Ruleton, KS · Accident · No injuries · Limited investigation · Final report · Aug 17, 2012 · N262EA · Substantial damage
  > The improper installation of the wastegate controller O-ring, which resulted in a partial loss of engine power.
- [NTSB CEN12LA551](https://openairdocs.org/ntsb/CEN12LA551.md): Piper PA-24-260 · Holton, KS · Accident · Serious injuries · Limited investigation · Final report · Aug 17, 2012 · N8546P · Substantial damage
  > The mechanic's failure to adequately torque the right magneto attachment nuts, allowing the right magneto to come loose, which allowed engine oil to escape, causing the engine to seize.
- [NTSB ERA12TA542](https://openairdocs.org/ntsb/ERA12TA542.md): Ridge Lowell H Jabiru J230 · Otter Lake, NY · Accident · No injuries · Final report · Aug 16, 2012 · N365R · Substantial damage
  > A failure of an engine cylinder exhaust valve due to the buildup of lead deposits on the valve stem and fatigue cracking of the valve stem, resulting in a total loss of engine power, and the loss of the propeller. Contributing to the accident was the lack of…
- [NTSB CEN12TA550](https://openairdocs.org/ntsb/CEN12TA550.md): MD Helicopter 369 · Columbus, OH · Accident · No injuries · Final report · Aug 16, 2012 · N551CP · Substantial damage
  > The failure of a 4th-stage turbine blade due to high-cycle fatigue, which resulted in the loss of engine power.
- [NTSB ERA12FA508](https://openairdocs.org/ntsb/ERA12FA508.md): Beech A36TC · Clifton Park, NY · Accident · 2 fatal · Field investigation · Final report · Aug 15, 2012 · N678DR · Substantial damage
  > A total loss of engine power for reasons that could not be determined during the postaccident investigation and testing.
- [NTSB CEN12IA554](https://openairdocs.org/ntsb/CEN12IA554.md): Cessna 560XL · Des Moines, IA · Incident · No injuries · Incident investigation · Final report · Aug 15, 2012 · N108EK · Minor damage
  > A temporary loss of control during cruise flight for reasons that could not be determined because postincident examination of the autopilot, pitch trim systems, and horizontal stabilizer revealed no anomalies consistent with a loss of control.
- [NTSB CEN12LA557](https://openairdocs.org/ntsb/CEN12LA557.md): Bell 47G-2 · Flandreau, SD · Accident · No injuries · Limited investigation · Final report · Aug 14, 2012 · N444EH · Substantial damage
  > A malfunction of the helicopter’s throttle system, which resulted in a loss of engine power during cruise flight.
- [NTSB DCA12WA160](https://openairdocs.org/ntsb/DCA12WA160.md): BAE BAE146 - 199 · Gaborone, Botswana · Incident · No injuries · Foreign investigation · Aug 11, 2012 · A2-ABF · Minor damage
  > On August 11, 2012 about 1136 UTC, A2-ABF, British Aerospace BAe 146-199, a scheduled commerical flight, operated by Air Botswana, after a loss of power in the no. 2 engine, aborted takeoff at Sir Seretse Khama International Airport, Gaborone, Botswana. There…
- [NTSB CEN12LA539](https://openairdocs.org/ntsb/CEN12LA539.md): Gn-1 Aircamper Mathes · Burlington, WI · Accident · Minor injuries · Limited investigation · Final report · Aug 11, 2012 · N31TM · Substantial damage
  > The pilot's improper installation of the propeller bolts, which resulted in the in-flight separation of the propeller.
- [NTSB DCA12WA125](https://openairdocs.org/ntsb/DCA12WA125.md): Boeing 757-200 · Tenerife Sur, Spain · Incident · No injuries · Foreign investigation · Aug 8, 2012 · G-LSAH · No damage
  > The Civil Aviation Accident and Incident Investigation Commission (CIAIAC) of Spain, has notified the NTSB of an accident involving a Boeing 757-200 that occurred on August 8, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the CIAIAC…
- [NTSB CEN12LA543](https://openairdocs.org/ntsb/CEN12LA543.md): Cross David L Glasair III · Westcliffe, CO · Accident · Serious injuries · Limited investigation · Final report · Aug 7, 2012 · N71AJ · Substantial damage
  > The loss of oil pressure due to the failure of an oil filter gasket, which resulted in a total loss of engine power.

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

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

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