# NTSB investigations, 2018: 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 1 of 7 · 340 cases

## Latest cases

- [NTSB CEN19LA064](https://openairdocs.org/ntsb/CEN19LA064.md): Cessna 152 · Horseshoe Bay, TX · Accident · Minor injuries · Limited investigation · Final report · Dec 29, 2018 · N6202M · Substantial damage
  > The pilot's inadequate preflight and in-flight fuel planning, which resulted in the total loss of engine power due to fuel exhaustion.
- [NTSB ENG19IA008](https://openairdocs.org/ntsb/ENG19IA008.md): Airbus A220 · Busan, South Korea · Incident · Class 3 · Incident · Final report · Dec 26, 2018 · HL8314 · No damage
  > The manufacturer’s inadequate cleaning of the crucible before melting the nickel alloy used in casting the low pressure turbine stage 3 blades that resulted in a casting anomaly from where an intergranular crack occurred became the origin of a fatigue crack…
- [NTSB ERA19RA077](https://openairdocs.org/ntsb/ERA19RA077.md): Agusta A109 · Santa Maria Coronango, State of Puebla, Mexico · Accident · 5 fatal · Foreign investigation · Dec 24, 2018 · XA-BON · Destroyed
  > The government of Mexico has notified the NTSB of an accident involving a AGUSTA A109S helicopter that occurred on December 24, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the…
- [NTSB ERA19LA079](https://openairdocs.org/ntsb/ERA19LA079.md): Cessna 172 · Fort Lauderdale, FL · Accident · No injuries · Limited investigation · Final report · Dec 24, 2018 · N3015E · Substantial damage
  > A total loss of engine power due to the fatigue fracture of the No. 2 exhaust rocker arm stud.
- [NTSB ERA19LA091](https://openairdocs.org/ntsb/ERA19LA091.md): Czech Sport Sportcruiser · Naples, FL · Accident · Serious injuries · Limited investigation · Final report · Dec 22, 2018 · N564SC · Substantial damage
  > Collision with a bird in flight, which resulted in damage to the engine, a fuel leak, and a subsequent total loss of engine power due to fuel exhaustion.
- [NTSB WPR19LA049](https://openairdocs.org/ntsb/WPR19LA049.md): Taylorcraft L 2M · Walla Walla, WA · Accident · No injuries · Class 3 · Limited · Final report · Dec 21, 2018 · N46147 · Substantial damage
  > The pilot's improper preflight planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB DCA19WA057](https://openairdocs.org/ntsb/DCA19WA057.md): Boeing 747-428 · Delhi Airspace, India · Incident · No injuries · Foreign investigation · Dec 21, 2018 · N919CA · No damage
  > The Aircraft Accident Investigation Bureau (AAIB) of India has notified the NTSB of an incident involving a Boeing 747, which occurred on December 21, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the…
- [NTSB ERA19LA072](https://openairdocs.org/ntsb/ERA19LA072.md): Piper PA46 · Mayport, FL · Accident · 2 fatal · Class 3 · Limited · Final report · Dec 20, 2018 · N307JM · Destroyed
  > An in-flight loss of control following an encounter with supercooled large droplet icing conditions, which ultimately resulted in an uncontrolled descent and subsequent inflight breakup. Also causal was the pilot’s failure to maintain an appropriate airspeed…
- [NTSB ERA19LA074](https://openairdocs.org/ntsb/ERA19LA074.md): Diamond DA20 · McCormick, SC · Accident · Minor injuries · Class 3 · Limited · Final report · Dec 19, 2018 · N346MA · Substantial damage
  > A partial loss of engine power due to debris obstructing the metering plug orifice in the throttle and metering unit.
- [NTSB CEN19WA080](https://openairdocs.org/ntsb/CEN19WA080.md): Cirrus SR22 · Toussus-Le-Noble, France · Accident · No injuries · Foreign investigation · Dec 18, 2018 · N842CD · Destroyed
  > The government of France has notified the NTSB of an accident involving a CIRRUS SR22 airplane that occurred on December 18, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions…
- [NTSB ERA19LA069](https://openairdocs.org/ntsb/ERA19LA069.md): Cessna 152 · Bell Glade, FL · Accident · No injuries · Limited investigation · Final report · Dec 17, 2018 · N4886B · Substantial damage
  > A partial loss of engine power due to the No. 1 cylinder's valve keeper becoming dislodged, which ultimately resulted in the intake valve becoming stuck in the valve guide and in the loss of compression to the cylinder.
- [NTSB CEN19LA047](https://openairdocs.org/ntsb/CEN19LA047.md): Rans S12 · McClure, OH · Accident · No injuries · Limited investigation · Final report · Dec 16, 2018 · N3165V · Substantial damage
  > The cold seizure of the cylinder/piston due to the pilot’s failure to adequately warm the engine before takeoff, which resulted in a loss of engine power during a departure climb.
- [NTSB WPR19LA041](https://openairdocs.org/ntsb/WPR19LA041.md): Hawker Hawker Hntr FMK 58 · Honolulu, HI · Accident · Serious injuries · Class 3 · Limited · Final report · Dec 13, 2018 · N323AX · Destroyed
  > A total loss of engine power for undetermined reasons.
- [NTSB CEN19WA102](https://openairdocs.org/ntsb/CEN19WA102.md): Cirrus SR22 · Beauberry, France · Accident · 3 fatal · Foreign investigation · Dec 10, 2018 · F-HUGE · Substantial damage
  > The government of France has notified the NTSB of an accident involving a Cirrus SR22 airplane that occurred on December 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions…
- [NTSB ERA19LA062](https://openairdocs.org/ntsb/ERA19LA062.md): Mooney M20K · Paramus, NJ · Accident · Minor injuries · Limited investigation · Final report · Dec 9, 2018 · N5756W · Substantial damage
  > Maintenance personnel's improper assembly of the engine during overhaul, which resulted in lubrication restriction due to a bearing shift and the subsequent engine failure.
- [NTSB ERA19LA063](https://openairdocs.org/ntsb/ERA19LA063.md): Lancair LC41 · Moscow, PA · Accident · No injuries · Class 3 · Limited · Final report · Dec 4, 2018 · N618G · Substantial damage
  > A total loss of engine power and catastrophic engine failure due to the failure of the left turbocharger, which resulted in oil loss and oil starvation. Contributing to the accident was the failure of maintenance personnel to overhaul the turbocharger in…
- [NTSB DCA19CA034](https://openairdocs.org/ntsb/DCA19CA034.md): Boeing 767 · SUNNS intersection, Osaka, Japan · Accident · Serious injuries · Class 4 · Data collection · Final report · Dec 4, 2018 · N193DN · No damage
  > The airplane’s encounter with severe turbulence.
- [NTSB CEN19WA040](https://openairdocs.org/ntsb/CEN19WA040.md): Cessna U206 · Culiacan, Sinaloa, Mexico · Accident · 4 fatal · Foreign investigation · Dec 3, 2018 · XB-NGU · Substantial damage
- [NTSB WPR19LA035](https://openairdocs.org/ntsb/WPR19LA035.md): Cessna 172P · Santa Rita · Accident · Minor injuries · Class 3 · Limited · Final report · Dec 2, 2018 · N98884 · Substantial damage
  > A total loss of engine power for undetermined reasons.
- [NTSB DCA19CA037](https://openairdocs.org/ntsb/DCA19CA037.md): Airbus A320 · LAS Vegas, NV · Accident · Serious injuries · Class 4 · Data collection · Final report · Dec 1, 2018 · N632NK · No damage
  > The airplane’s encounter with severe turbulence.
- [NTSB WPR19WA033](https://openairdocs.org/ntsb/WPR19WA033.md): Cessna U206 · Machadodorp, South Africa · Accident · Serious injuries · Foreign investigation · Nov 29, 2018 · ZS-DIV · Substantial damage
  > On November 29, 2018, about 1606 universal coordinated time, a Cessna U206D airplane, South African registration ZS-DIV, impacted terrain near the Skoonman Kloff in the Machadodorp area in Mpumalanga Province, South Africa. The pilot and 4 passengers were…
- [NTSB WPR19WA038](https://openairdocs.org/ntsb/WPR19WA038.md): Bell 407 GX · West Bangkala, Indonesia · Accident · No injuries · Foreign investigation · Nov 28, 2018 · PK-JPB · Substantial damage
  > On November 28, 2018, about 0850 coordinated universal time, a Bell Helicopter 407 GX, PK-JPB, executed a precautionary landing following the illumination of the engine chip detector caution light near West Bangkala, Indonesia. There were no injuries to the…
- [NTSB ERA19WA104](https://openairdocs.org/ntsb/ERA19WA104.md): Agusta AW109 · Campos do Jordao, Brazil · Accident · 6 fatal · Foreign investigation · Nov 24, 2018 · PT-FPS · Destroyed
  > The government of Brazil has notified the NTSB of an accident involving a Agusta AW109 helicopter that occurred on November 24, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…
- [NTSB WPR19WA081](https://openairdocs.org/ntsb/WPR19WA081.md): Cessna U206 · Chemajenjera Hill, Zimbabwe · Accident · 5 fatal · Foreign investigation · Nov 23, 2018 · Z-BRS · Destroyed
  > On November 23, 2018, about 0530 coordinated universal time, a Cessna U206C airplane, Z-BRS, was destroyed when it impacted terrain near Chemajenjera Hill, Zimbabwe. The pilot and four passengers were fatally injured. The airplane was operated under the…
- [NTSB GAA19CA074](https://openairdocs.org/ntsb/GAA19CA074.md): Cirrus SR22 · Sand Creek, WI · Accident · No injuries · Data collection · Final report · Nov 21, 2018 · N579CP · Substantial damage
  > The mechanic's failure to properly secure the air reference line, which resulted in a loss of engine power.
- [NTSB ERA19WA053](https://openairdocs.org/ntsb/ERA19WA053.md): Cessna TU206 · Puente Alto, Chile · Accident · 2 fatal · Class 5 · Foreign · Nov 21, 2018 · CC-CXS · Destroyed
- [NTSB GAA19CA067](https://openairdocs.org/ntsb/GAA19CA067.md): Jabiru J230-SP · Center, TX · Accident · No injuries · Data collection · Final report · Nov 18, 2018 · N667J · Substantial damage
  > The pilot's improper preflight fuel planning, which resulted in fuel exhaustion and a total loss of engine power.
- [NTSB DCA21WA112](https://openairdocs.org/ntsb/DCA21WA112.md): Boeing 737 · Buenos Aires, Argentina · Incident · No injuries · Class 5 · Foreign · Nov 17, 2018 · LV-HFR · No damage
- [NTSB CEN19FA029](https://openairdocs.org/ntsb/CEN19FA029.md): Beech 55 · Liberal, KS · Accident · 2 fatal · Field investigation · Final report · Nov 17, 2018 · N4817M · Substantial damage
  > The pilot's improper decision to fly in an area where moderate icing conditions were forecasted in an airplane that was not certified for such conditions, and in the effort to get out of the icing conditions, his decision to fly below the minimum descent…
- [NTSB ERA19TA051](https://openairdocs.org/ntsb/ERA19TA051.md): Cessna E162 · Franklin, NC · Accident · Minor injuries · Final report · Nov 16, 2018 · N70252 · Substantial damage
  > The pilot's delay in applying carburetor heat, which resulted in a total loss of engine power during descent due to carburetor icing.
- [NTSB ERA19WA045](https://openairdocs.org/ntsb/ERA19WA045.md): Piper PA25 · Ezperanza, Dominican Republic · Accident · No injuries · Foreign investigation · Nov 14, 2018 · HI191 · Substantial damage
  > The government of the Dominican Republic has notified the NTSB of an accident involving a PIPER PA25 airplane that occurred on November 14, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of the Dominican Republic's…
- [NTSB CEN19WA041](https://openairdocs.org/ntsb/CEN19WA041.md): Cessna T206H · Tampico, Mexico · Accident · 2 fatal · Foreign investigation · Nov 12, 2018 · XB-ILM · Substantial damage
  > On November 12, 2018, about 2016 UTC, a Mexican registered Cessna T206H airplane, XB-ILM, sustained substantial damage during a forced landing to a highway due to a loss of engine power near Tampico, Tamaulipas, Mexico. The pilot and passenger were not…
- [NTSB DCA19WA023](https://openairdocs.org/ntsb/DCA19WA023.md): Embraer 190 · Bara, Portugal · Incident · No injuries · Foreign investigation · Nov 11, 2018 · P4-KCJ · No damage
  > The GPIA of Portugal has notified the NTSB of an incident involving a Embraer 190 airplane that occurred on November 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the GPIA of Portugal's investigation under the provisions of ICAO…
- [NTSB GAA19CA066](https://openairdocs.org/ntsb/GAA19CA066.md): Robinson R44 · Lihue, HI · Accident · No injuries · Data collection · Final report · Nov 10, 2018 · N445KP · Substantial damage
  > The passenger’s improper decision to hold her cell phone outside the helicopter, which resulted in it departing the helicopter and striking the tail rotor.
- [NTSB WPR19FA022](https://openairdocs.org/ntsb/WPR19FA022.md): Piper PA28 · Guthrie Center, IA · Accident · 4 fatal · Class 2 · Field · Final report · Nov 9, 2018 · N91770 · Substantial damage
  > Pilot incapacitation due to carbon monoxide poisoning as a result of an undetected crack in an engine exhaust muffler, which permitted entry of exhaust gasses into the cabin via the cabin heat system.
- [NTSB ERA19FA039](https://openairdocs.org/ntsb/ERA19FA039.md): Cessna 310 · Walton, NY · Accident · 1 fatal · Field investigation · Final report · Nov 9, 2018 · N5044J · Destroyed
  > An in-flight fire of undetermined origin. Contributing to the accident were the severe icing conditions encountered during the final minutes of the flight, which led to a loss of airplane control.
- [NTSB WPR19LA021](https://openairdocs.org/ntsb/WPR19LA021.md): Cessna 182 · Ontario, CA · Accident · No injuries · Class 3 · Limited · Final report · Nov 8, 2018 · N9914M · Substantial damage
  > A partial loss of engine power during descent due to an incorrectly installed carburetor.
- [NTSB GAA19CA070](https://openairdocs.org/ntsb/GAA19CA070.md): Cessna T337 · Homosassa, FL · Accident · No injuries · Data collection · Final report · Nov 8, 2018 · N1ZR · Substantial damage
  > The pilot's inadequate preflight inspection, which resulted in fuel exhaustion and the subsequent total loss of power in both engines.
- [NTSB CEN19WA038](https://openairdocs.org/ntsb/CEN19WA038.md): Piper PA25 · Pachuca, Mexico, Mexico · Accident · 1 fatal · Foreign investigation · Nov 8, 2018 · XB-FRC
  > The government of Mexico has notified the NTSB of an accident involving a PIPER PA25 airplane that occurred on November 08, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions…
- [NTSB GAA19CA053](https://openairdocs.org/ntsb/GAA19CA053.md): Piper PA24 · Texico, NM · Accident · Minor injuries · Data collection · Final report · Nov 5, 2018 · N3214P · Substantial damage
  > The pilot's improper preflight fuel planning, which resulted in fuel exhaustion and a total loss of engine power.
- [NTSB CEN19WA037](https://openairdocs.org/ntsb/CEN19WA037.md): Rotorway Exec · Saint Pierre, St. Pierre & Miquelon · Accident · 1 fatal · Foreign investigation · Nov 5, 2018 · F-PSPM · Destroyed
- [NTSB CEN19FA024](https://openairdocs.org/ntsb/CEN19FA024.md): Bell 206 · Uvalde, TX · Accident · 3 fatal · Field investigation · Final report · Nov 4, 2018 · N417WT · Destroyed
  > The pilot's controlled flight into terrain during night visual meteorological conditions. Contributing to the accident was the pilot improper decision to inhibit the helicopter's terrain warning systems and flight at low altitude.
- [NTSB CEN19WA042](https://openairdocs.org/ntsb/CEN19WA042.md): Piper PA34 · Uk, United Kingdom · Accident · No injuries · Foreign investigation · Nov 2, 2018 · G-OXFF
  > The government of United Kingdom has notified the NTSB of an accident involving a PIPER PA34 airplane that occurred on November 02, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under…
- [NTSB CEN19FA021](https://openairdocs.org/ntsb/CEN19FA021.md): Cessna 210 · Bradley, SD · Accident · 1 fatal · Field investigation · Final report · Nov 2, 2018 · N81KD · Destroyed
  > The non-instrument-rated pilot's improper decision to conduct a flight in which instrument meteorological conditions existed along the route of flight, which resulted in spatial disorientation and a loss of airplane control.
- [NTSB CEN19FA018](https://openairdocs.org/ntsb/CEN19FA018.md): Eurocopter AS350 · Odanah, WI · Accident · 1 fatal · Field investigation · Final report · Oct 29, 2018 · N910S · Destroyed
  > The pilot's loss of helicopter control for undetermined reasons.
- [NTSB ERA19LA029](https://openairdocs.org/ntsb/ERA19LA029.md): Diamond DA20 · Mountain Rest, SC · Accident · No injuries · Limited investigation · Final report · Oct 28, 2018 · N653DC · Substantial damage
  > A partial loss of engine power due to multiple discrepancies of the engine's ignition system.
- [NTSB WPR19LA028](https://openairdocs.org/ntsb/WPR19LA028.md): Bell 430 · Kailua, HI · Accident · No injuries · Class 3 · Limited · Final report · Oct 27, 2018 · N430ST · Substantial damage
  > The separation of one of the tail rotors blades’ root enclosures due to improper repair.
- [NTSB CEN19LA015](https://openairdocs.org/ntsb/CEN19LA015.md): Cessna 172 · Houston, TX · Accident · No injuries · Limited investigation · Final report · Oct 27, 2018 · N3973L · Substantial damage
  > The pilot's failure to apply carburetor heat while operating in an area conducive to carburetor icing, which resulted in a total loss of engine power on approach and subsequent forced landing into a creek.
- [NTSB ERA19LA026](https://openairdocs.org/ntsb/ERA19LA026.md): Piper PA31T · Atlantic Ocean (Atlantic Ocean) · Accident · 5 fatal · Limited investigation · Final report · Oct 25, 2018 · N555PM · Destroyed
  > An in-flight loss of control, which resulted in an impact with water, for reasons that could not be determined because the airplane was not recovered.
- [NTSB WPR19LA014](https://openairdocs.org/ntsb/WPR19LA014.md): North American SNJ · Agoura Hills, CA · Accident · No injuries · Class 3 · Limited · Final report · Oct 23, 2018 · N7969C · Destroyed
  > The failure of the No. 5 piston rod end due to fatigue, which resulted in a total loss of engine power.

Next page: https://openairdocs.org/ntsb-phases/400/cases.md?year=2018&page=2

## 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 year(c."eventDate") = 2018
  AND 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?year=2018

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