# NTSB investigations: Approach

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 3 of 420 · 20,992 cases

## Cases, newest first

- [NTSB CEN26FA051](https://openairdocs.org/ntsb/CEN26FA051.md): Cessna 172N · New Orleans, LA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Nov 25, 2025 · N80FP · Destroyed
  > On November 24, 2025, at 1824 central standard time, a Cessna 172N airplane, N80FP, was destroyed when it was involved in an accident near New Orleans, Louisiana. The flight instructor and pilot receiving instruction were fatally injured. The flight was…
- [NTSB ERA26LA054](https://openairdocs.org/ntsb/ERA26LA054.md): Cessna 172 · Zanesville, OH · Accident · No injuries · Class 4 · Limited · Final report · Nov 24, 2025 · N7805G · Substantial damage
  > The pilot’s failure to maintain clearance from a power line during an approach to land.
- [NTSB CEN26FA050](https://openairdocs.org/ntsb/CEN26FA050.md): Socata TBM 700 · Monroe, WI · Accident · 2 fatal · Class 3 · Field · Preliminary report · Nov 24, 2025 · N700PT · Substantial damage
  > On November 24, 2025, about 1713 central standard time (CST), a Socata TBM 700 airplane, N700PT, was destroyed when it was involved in an accident near Monroe, Wisconsin. The pilot and pilot-rated passenger sustained fatal injuries. The airplane was operated…
- [NTSB CEN26FA049](https://openairdocs.org/ntsb/CEN26FA049.md): Piper PA-28R-201 · Pittsfield, IL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Nov 24, 2025 · N47700 · Substantial damage
  > On November 23, 2025, about 2137 central standard time (all referenced times are CST), a Piper PA-28R-201 airplane, N47700, was substantially damaged when it was involved in an accident near Pittsfield, Illinois. The pilot was fatally injured, and the 2…
- [NTSB DCA26WA036](https://openairdocs.org/ntsb/DCA26WA036.md): Embraer ERJ170 · Greenwich, CT · Occurrence · No injuries · Class 5 · Foreign · Nov 22, 2025 · C-FRQM · No damage
- [NTSB WPR26LA049](https://openairdocs.org/ntsb/WPR26LA049.md): Zenair Stol CH 701 · Shady Cove, OR · Accident · Minor injuries · Class 4 · Limited · Final report · Nov 20, 2025 · N43AH · Substantial damage
  > The pilot’s improper throttle input during an approach, which resulted in a rapid descent, hard landing and runway excursion.
- [NTSB GAA26WA043](https://openairdocs.org/ntsb/GAA26WA043.md): Vulcanair P68 · Waterford Regional Airport, Ireland · Accident · 1 fatal · Class 5 · Foreign · Nov 20, 2025 · EI-HPY · Destroyed
- [NTSB WPR26LA045](https://openairdocs.org/ntsb/WPR26LA045.md): Piper PA-28-181 · Mesa, AZ · Accident · No injuries · Class 3 · Limited · Preliminary report · Nov 17, 2025 · N4402N · Substantial damage
  > On November 17, 2025, about 0830 mountain standard time, a Piper PA 28-181, N4402N, was substantially damaged when it was involved in an accident near Mesa, Arizona. The flight instructor and student pilot were not injured. The airplane was operated as a…
- [NTSB ERA26LA044](https://openairdocs.org/ntsb/ERA26LA044.md): Cirrus Design SR22 · Eastpoint, FL · Accident · No injuries · Class 4 · Limited · Final report · Nov 17, 2025 · N508WH · Substantial damage
  > The pilot’s loss of airplane control during a go-around, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s improper recovery from an aerodynamic stall.
- [NTSB ERA26LA043](https://openairdocs.org/ntsb/ERA26LA043.md): Beech 95-B55 · Dothan, AL · Accident · No injuries · Class 4 · Limited · Final report · Nov 14, 2025 · N711FA · Substantial damage
  > The failure of the left main landing gear actuator rods, which resulted in a gear up landing.
- [NTSB DCA26WA042](https://openairdocs.org/ntsb/DCA26WA042.md): Boeing 737 · Malaga, Spain · Incident · No injuries · Class 5 · Foreign · Nov 14, 2025 · EI-HGG · No damage
- [NTSB CEN26LA044](https://openairdocs.org/ntsb/CEN26LA044.md): Cirrus Design SR20 · Chesterfield, MO · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Nov 11, 2025 · N866CD · Substantial damage
  > On November 11, 2025, about 1750 central standard time, a Cirrus SR20, N866CD, was substantially damaged when it was involved in an accident near Chesterfield, Missouri. The pilot and copilot received minor injuries. The airplane was operated as a Title 14…
- [NTSB WPR26LA046](https://openairdocs.org/ntsb/WPR26LA046.md): Michael W Verzwyvelt SS-7 Super Sport · Boise, ID · Accident · Minor injuries · Class 4 · Limited · Final report · Nov 9, 2025 · N14PM · Substantial damage
  > The pilot’s operation of the airplane while intoxicated, resulting in its impact with obstacles while on approach.
- [NTSB CEN26LA040](https://openairdocs.org/ntsb/CEN26LA040.md): Cessna 180K · Lakeview, AR · Accident · No injuries · Class 4 · Limited · Final report · Nov 8, 2025 · N2697K · Substantial damage
  > The pilot’s decision to continue an approach that resulted in a long landing and inability to stop prior to the end of the runway. Contributing to the accident were the light conditions and a road with vehicles on it immediately adjacent to the end of the…
- [NTSB GAA26WA021](https://openairdocs.org/ntsb/GAA26WA021.md): Piper PA32RT · Contamana, Peru · Accident · No injuries · Class 5 · Foreign · Nov 6, 2025 · OB-1902 · Substantial damage
- [NTSB ERA26LA033](https://openairdocs.org/ntsb/ERA26LA033.md): Cessna 172 · Oxford, CT · Accident · No injuries · Class 4 · Limited · Final report · Nov 6, 2025 · N34LC · Substantial damage
  > The pilot’s failure to compensate for gusty crosswind conditions, which resulted in a loss of control of the airplane and subsequent collision with terrain.
- [NTSB GAA26WA014](https://openairdocs.org/ntsb/GAA26WA014.md): Textron 182T · Nuuk, Greenland · Accident · 1 fatal · Class 5 · Foreign · Oct 25, 2025 · N9009F · Destroyed
- [NTSB DCA26FA019](https://openairdocs.org/ntsb/DCA26FA019.md): Air Vev AIR ZERO2 · Indiantown, FL · Accident · No injuries · Class 4 · Field · Final report · Oct 23, 2025 · N514AX · Destroyed
  > A cascading shutoff of multiple aft motors due to a sudden increase in motor loads during maneuvering, resulting in a loss of control.
- [NTSB WPR26LA025](https://openairdocs.org/ntsb/WPR26LA025.md): Piper PA 46-350P · Queen Creek, AZ · Accident · No injuries · Class 4 · Limited · Final report · Oct 20, 2025 · N699PG · Substantial damage
  > The pilot’s improper runway alignment and failure to maintain clearance from powerlines. Contributing to the accident was sun glare, which obscured the pilot’s view of the runway.
- [NTSB CEN26FA023](https://openairdocs.org/ntsb/CEN26FA023.md): JMB VL-3LSA-912 · Erie, CO · Accident · 2 fatal · Class 3 · Field · Preliminary report · Oct 19, 2025 · N594TT · Substantial damage
  > On October 19, 2025, about 1531 mountain daylight time, a JMB Aircraft VL-3LSA-912, N594TT, was substantially damaged when it was involved in an accident near Erie, Colorado. The pilot receiving instruction and the flight instructor were fatally injured. The…
- [NTSB ERA26LA014](https://openairdocs.org/ntsb/ERA26LA014.md): Cessna 172 · North Lauderdale, FL · Accident · No injuries · Class 4 · Limited · Final report · Oct 13, 2025 · N1206U · Substantial damage
  > A total loss of engine power due to a fuel delivery system leak, which allowed air to enter the fuel system. The source of the leak could not be determined based on the available evidence.
- [NTSB ERA26FA010](https://openairdocs.org/ntsb/ERA26FA010.md): Beech C90 · Fort Worth, TX · Accident · 2 fatal · Class 3 · Field · Preliminary report · Oct 12, 2025 · N291CC · Destroyed
  > On October 12, 2025, about 1334 central daylight time, a Beech C90, N291CC, was destroyed when it was involved in an accident near Fort Worth, Texas. The private pilot and pilot-rated passenger were fatally injured. The airplane was operated as a Title 14…
- [NTSB CEN26LA007](https://openairdocs.org/ntsb/CEN26LA007.md): Cessna R172 · Mount Carroll, IL · Accident · Serious injuries · Class 4 · Limited · Final report · Oct 5, 2025 · N7354V · Substantial damage
  > The pilot’s failure to maintain aircraft control during a go around in gusty wind conditions.
- [NTSB DCA26WA003](https://openairdocs.org/ntsb/DCA26WA003.md): Boeing 737 · Manchester, United Kingdom · Incident · Class 5 · Foreign · Oct 3, 2025 · 9H-QBD · No damage
- [NTSB WPR25LA298](https://openairdocs.org/ntsb/WPR25LA298.md): Cessna 185A · Ilwaco, WA · Accident · No injuries · Class 4 · Limited · Final report · Sep 27, 2025 · N186X · Substantial damage
  > The pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN25LA393](https://openairdocs.org/ntsb/CEN25LA393.md): Floyd G Halderman JR RV-6 · Cambridge, MN · Accident · No injuries · Class 4 · Limited · Final report · Sep 25, 2025 · N851FH · Substantial damage
  > The pilot’s continued operation of the faulty fuel selector valve which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was the degraded operation of the fuel selector valve and the pilot’s poor decision to operate the…
- [NTSB WPR25LA292](https://openairdocs.org/ntsb/WPR25LA292.md): Cessna 182N · Fallbrook, CA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Sep 23, 2025 · N766EE · Substantial damage
  > On September 23, 2025, about 1400 Pacific daylight time, N766EE, a Cessna 182N, was substantially damaged when it was involved in an accident near Fallbrook, California. The pilot received minor injuries. The airplane was operated as a Title 14 Code of…
- [NTSB CEN25LA400](https://openairdocs.org/ntsb/CEN25LA400.md): Piper PA-34-200 · Rush City, MN · Accident · No injuries · Class 4 · Limited · Final report · Sep 23, 2025 · N14SS · Substantial damage
  > The pilot’s failure to properly monitor the airplane glide path which resulted in the inadvertent descent below the approach minimum descent altitude and the impact with trees.
- [NTSB ANC25LA112](https://openairdocs.org/ntsb/ANC25LA112.md): Cessna 172 · Yakataga, AK · Accident · No injuries · Class 4 · Limited · Final report · Sep 22, 2025 · N4282F · Substantial damage
  > The total loss of engine power due to carburetor icing and the pilot’s failure to effectively use carburetor heat in meteorological conditions conducive to the formation of carburetor icing.
- [NTSB ANC25LA118](https://openairdocs.org/ntsb/ANC25LA118.md): Toci Gabe C G Supa · Palmer, AK · Accident · No injuries · Class 4 · Limited · Final report · Sep 19, 2025 · N803R · Substantial damage
  > The pilot’s failure to maintain airplane control during the go-around.
- [NTSB ERA25FA352](https://openairdocs.org/ntsb/ERA25FA352.md): Cirrus Design SR22T · Franklin, NC · Accident · 3 fatal · Class 3 · Field · Preliminary report · Sep 18, 2025 · N218VB · Substantial damage
  > On September 18, 2025, at 1456 eastern daylight time, a Cirrus SR22T, N218VB, was substantially damaged when it was involved in an accident near Franklin, North Carolina. The private pilot and two passengers were fatally injured. The airplane was operated as…
- [NTSB WPR25FA279](https://openairdocs.org/ntsb/WPR25FA279.md): Bellanca 17-30A · Moriarty, NM · Accident · 1 fatal · Class 3 · Field · Preliminary report · Sep 16, 2025 · N432DM · Substantial damage
  > On September 16, 2025, about 1132 mountain daylight time, a Bellanca 17-30A, N432DM, was substantially damaged when it was involved in an accident near Moriarty, New Mexico. The pilot receiving instruction was fatally injured and the flight instructor…
- [NTSB GAA25WA280](https://openairdocs.org/ntsb/GAA25WA280.md): Dehavilland DHC-2 MK. 1 · St Theresa, Canada · Accident · 4 fatal · Class 5 · Foreign · Sep 13, 2025 · C-FDPW · Substantial damage
- [NTSB ERA25LA354](https://openairdocs.org/ntsb/ERA25LA354.md): Jonker Sailplanes JS3 · New Castle, VA · Accident · No injuries · Class 4 · Limited · Final report · Sep 13, 2025 · N68MF · Substantial damage
  > The pilot’s failure to properly configure the glider for landing, which resulted in an excessive descent rate during approach, and subsequent collision with trees short of the intended landing area.
- [NTSB ERA25LA345](https://openairdocs.org/ntsb/ERA25LA345.md): Cessna 172 · Williston, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Sep 13, 2025 · N345QA · Substantial damage
  > On September 13, 2025, about 0733 eastern daylight time, a Cessna 172G, N345QA, was substantially damaged when it was involved in an accident near Williston, Florida. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB CEN25LA379](https://openairdocs.org/ntsb/CEN25LA379.md): Pegasus Quantum 15 · Bedford, IN · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Sep 13, 2025 · N36TJ · Substantial damage
  > On September 13, 2025, at 1625 eastern daylight time, a Pegasus Quantum 15 weight-shift controlled aircraft, N36TJ, sustained substantial damage when it was involved in an accident near Bedford, Indiana. The pilot received serious injuries. The airplane was…
- [NTSB CEN25LA377](https://openairdocs.org/ntsb/CEN25LA377.md): Cessna 172F · Lancaster, TX · Accident · No injuries · Class 4 · Limited · Final report · Sep 13, 2025 · N7774A · Substantial damage
  > The pilot’s inadequate fuel planning and failure to monitor the fuel consumption which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ANC25LA105](https://openairdocs.org/ntsb/ANC25LA105.md): Maule M-5-235C · Point MacKenzie, AK · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Sep 13, 2025 · N343GA · Substantial damage
  > On September 13, 2025, about 12:28 Alaska daylight time, a Maule M5-235C airplane, N343GA, was substantially damaged when it was involved in an accident near Point McKenzie, Alaska. The commercial pilot sustained serious injuries. The airplane was operated…
- [NTSB WPR25LA275](https://openairdocs.org/ntsb/WPR25LA275.md): Piper PA-28-180 · Hollister, CA · Accident · No injuries · Class 4 · Limited · Final report · Sep 11, 2025 · N7756N · Substantial damage
  > The pilot’s delayed go-around from an unstabilized approach that resulted in an impact with terrain.
- [NTSB DCA25WA327](https://openairdocs.org/ntsb/DCA25WA327.md): Boeing 767 · Sydney, Australia · Incident · Class 5 · Foreign · Sep 10, 2025 · VH-XQU · No damage
- [NTSB DCA25WA321](https://openairdocs.org/ntsb/DCA25WA321.md): Boeing 737-832 · Belize City, Belize · Incident · No injuries · Class 5 · Foreign · Sep 10, 2025 · N386DA · Minor damage
- [NTSB CEN25LA401](https://openairdocs.org/ntsb/CEN25LA401.md): CubCrafters CCK-2000 · Thompsonville, MI · Accident · No injuries · Class 3 · Limited · Final report · Sep 7, 2025 · N40DT · Substantial damage
  > A total loss of engine power due to a lack of ignition resulting from a fractured alternator ring terminal and the builder’s incorrect installation of the wire connecting to the alternator. Contributing to the total loss of engine power was the failure of the…
- [NTSB CEN25LA370](https://openairdocs.org/ntsb/CEN25LA370.md): Boeing E75 · Benton, KS · Accident · No injuries · Class 4 · Limited · Final report · Sep 7, 2025 · N75675 · Substantial damage
  > The pilot's failure to maintain clearance from a moving vehicle during an evasive maneuver from a perceived conflict with another airplane. Contributing to the accident was the pilot of the other airplane’s non-standard phraseology and inaccurate position…
- [NTSB CEN25FA366](https://openairdocs.org/ntsb/CEN25FA366.md): Beech P35 · Englewood, CO · Accident · 2 fatal · Class 3 · Field · Preliminary report · Sep 5, 2025 · N463T · Destroyed
  > On September 5, 2025, about 0623 mountain daylight time, a Beech P35 airplane, N463T, was destroyed when it was involved in an accident near Englewood, Colorado. The pilot receiving instruction and flight instructor were both fatally injured. The airplane was…
- [NTSB GAA25WA274](https://openairdocs.org/ntsb/GAA25WA274.md): Beech A36 · Guarantã Do Norte, Brazil · Accident · Minor injuries · Class 5 · Foreign · Sep 4, 2025 · PT-LSU · Substantial damage
- [NTSB CEN25FA364](https://openairdocs.org/ntsb/CEN25FA364.md): Beech K35 · Cambridge, MN · Accident · 1 fatal · Class 3 · Field · Preliminary report · Sep 4, 2025 · N6021E · Substantial damage
  > On September 4, 2025, about 1105 central daylight time, a Beech K35 airplane, N6021E, sustained substantial damage when it was involved in an accident near Cambridge, Minnesota. The pilot sustained fatal injuries. The airplane was operated as a Title 14 Code…
- [NTSB CEN25LA362](https://openairdocs.org/ntsb/CEN25LA362.md): Cessna 414 · New Braunfels, TX · Accident · No injuries · Class 4 · Limited · Final report · Sep 3, 2025 · N39HC · Substantial damage
  > A in-flight collision with a bird during the descent for landing.
- [NTSB WPR25FA268](https://openairdocs.org/ntsb/WPR25FA268.md): Cessna 172M · Fort Morgan, CO · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 31, 2025 · N61657 · 2 aircraft · Destroyed
  > On August 31, 2025, about 1040 mountain daylight time, a Cessna 172M, N61657, and an Extra Flugzeugproduktions-UND EA 300/LC, N330AN, were both destroyed when they collided midair near Fort Morgan, Colorado. The pilot and safety pilot of the Cessna received…
- [NTSB ANC25LA100](https://openairdocs.org/ntsb/ANC25LA100.md): Champion 7GCBC · Sutton, AK · Accident · No injuries · Class 4 · Limited · Final report · Aug 31, 2025 · N5267X · Substantial damage
  > The airplane’s encounter with a downdraft while maneuvering at low altitude, which resulted in a forced landing and collision with terrain.
- [NTSB CEN25LA352](https://openairdocs.org/ntsb/CEN25LA352.md): Glasair GlaStar · Hearne, TX · Accident · Minor injuries · Class 4 · Limited · Final report · Aug 28, 2025 · N605MN · Substantial damage
  > The inflight engine compartment fire for reasons that could not be determined.

Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=4

## 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 = 500)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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