# NTSB investigations: Initial climb

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 412 · 20,556 cases

## Latest cases

- [NTSB WPR27LA019](https://openairdocs.org/ntsb/WPR27LA019.md): Cessna 177A · San Jose, CA · Accident · Serious injuries · Class 3 · Limited · Investigation open · Oct 17, 2026 · N30544
- [NTSB DCA27LA013](https://openairdocs.org/ntsb/DCA27LA013.md): Bombardier CL-600-2D24 · St. Louis, MO · Accident · Serious injuries · Class 4 · Limited · Investigation open · Oct 17, 2026 · N574NN · No damage
- [NTSB CEN27LA014](https://openairdocs.org/ntsb/CEN27LA014.md): Cessna 210N · Gonzales, LA · Accident · Class 4 · Limited · Investigation open · Oct 13, 2026 · N1329U
- [NTSB CEN27LA013](https://openairdocs.org/ntsb/CEN27LA013.md): Piper PA-28-140 · Abita Springs, LA · Accident · No injuries · Class 3 · Limited · Preliminary report · Oct 12, 2026 · N9859W · Substantial damage
  > On October 12, 2026, at 1540 central daylight time, a Piper PA-28-140 airplane, N9859W, sustained substantial damage when it was involved in an accident near Abita Springs, Louisiana. The private pilot was uninjured. The airplane was operated as a Title 14…
- [NTSB WPR27FA012](https://openairdocs.org/ntsb/WPR27FA012.md): Gugger David RV-7A · Petaluma, CA · Accident · 2 fatal · Class 3 · Field · Investigation open · Oct 7, 2026 · N425DG
- [NTSB GAA27WA005](https://openairdocs.org/ntsb/GAA27WA005.md): Cessna R172 · Tarija, Bolivia · Accident · No injuries · Class 5 · Foreign · Oct 7, 2026 · CP-2646 · Substantial damage
- [NTSB ENG27LA001](https://openairdocs.org/ntsb/ENG27LA001.md): Boeing 777-222 · San Francisco, CA · Incident · No injuries · Class 4 · Limited · Investigation open · Oct 6, 2026 · N796UA
- [NTSB WPR27LA008](https://openairdocs.org/ntsb/WPR27LA008.md): Hakala John Charles Lancair IV-P-T · Ontario, OR · Accident · No injuries · Class 3 · Limited · Investigation open · Oct 4, 2026 · N5UC
- [NTSB CEN26LA330](https://openairdocs.org/ntsb/CEN26LA330.md): Cessna 152 · Bolingbrook, IL · Accident · Class 3 · Limited · Investigation open · Sep 29, 2026 · N69009
- [NTSB WPR26LA358](https://openairdocs.org/ntsb/WPR26LA358.md): Reynolds Dennis E Bearhawk Patrol · Cottage Grove, OR · Accident · Serious injuries · Class 3 · Limited · Investigation open · Sep 27, 2026 · N240BP
- [NTSB CEN26FA325](https://openairdocs.org/ntsb/CEN26FA325.md): EXP PA-18 Replica · Buffalo, MN · Accident · 1 fatal · Class 3 · Field · Preliminary report · Sep 27, 2026 · N43LK · Substantial damage
  > On September 27, 2026, about 1608 central daylight time, an experimental PA-18 Replica airplane, N43LK, sustained substantial damage when it was involved in an accident near Buffalo, Minnesota. The pilot was fatally injured, and the pilot-rated passenger was…
- [NTSB ANC26LA107](https://openairdocs.org/ntsb/ANC26LA107.md): Piper PA-28-140 · Junction, TX · Accident · Serious injuries · Class 3 · Limited · Investigation open · Sep 21, 2026 · N224BB
- [NTSB ANC26FA106](https://openairdocs.org/ntsb/ANC26FA106.md): Piper PA-18-150 · Northway, AK · Accident · 2 fatal · Class 3 · Field · Investigation open · Sep 18, 2026 · N9128D
- [NTSB DCA26WA364](https://openairdocs.org/ntsb/DCA26WA364.md): Boeing 777-223 · Ezeiza, Argentina · Incident · No injuries · Class 5 · Foreign · Sep 14, 2026 · N761AJ
- [NTSB WPR26FA329](https://openairdocs.org/ntsb/WPR26FA329.md): Grumman American Avn. AA-5 · Fresno, CA · Accident · 4 fatal · Class 3 · Field · Preliminary report · Sep 5, 2026 · N6510L · Destroyed
  > On September 5, 2026, about 1345 Pacific daylight time, a Grumman AA-5, N6510L, was destroyed when it was involved in an accident near Fresno, California. The pilot and 3 passengers were fatally injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB ERA26LA328](https://openairdocs.org/ntsb/ERA26LA328.md): Piper PA-28-180 · Dallas, GA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Sep 4, 2026 · N7635W · Substantial damage
  > On September 3, 2026, at 2004 eastern daylight time, a Piper PA-28-180, N7635W, was substantially damaged when it was involved in an accident near Dallas, Georgia. The flight instructor and student pilot were seriously injured. The airplane was operated as a…
- [NTSB ERA26FA326](https://openairdocs.org/ntsb/ERA26FA326.md): Maclura Evolution · Tampa, FL · Accident · 2 fatal · Class 3 · Field · Preliminary report · Sep 3, 2026 · N305PV · Destroyed
  > On September 3, 2026, about 0815 eastern daylight time, an experimental, amateur-built Evolution airplane, N305PV, was destroyed when it was involved in an accident near Tampa, Florida. The commercial pilot and passenger were fatally injured. The airplane was…
- [NTSB ANC26LA096](https://openairdocs.org/ntsb/ANC26LA096.md): Cessna R182 · Lebanon, TN · Accident · Minor injuries · Class 3 · Limited · Investigation open · Sep 1, 2026 · N6346T
- [NTSB WPR26LA324](https://openairdocs.org/ntsb/WPR26LA324.md): Zenith CH701 · Byron, CA · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 30, 2026 · N701WJ · Substantial damage
  > On August 30, 2026, about 0905 Pacific daylight time, an experimental amateur-built Zenith CH701, N701WJ, was substantially damaged when it was involved in an accident at Byron Airport (C83), Byron, California. The pilot was not injured. The airplane was…
- [NTSB ERA26LA319](https://openairdocs.org/ntsb/ERA26LA319.md): Piper PA22 · Pace, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 29, 2026 · N5731D · Substantial damage
  > On August 29, 2026, about 1030 central daylight time, a Piper PA-22-150, N5731D, was substantially damaged when it was involved in an accident near Pace, Florida. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations…
- [NTSB ERA26LA312](https://openairdocs.org/ntsb/ERA26LA312.md): Piper PA24 · Fort Washington, MD · Accident · No injuries · Class 4 · Limited · Investigation open · Aug 21, 2026 · N6969P · Substantial damage
- [NTSB CEN26LA296](https://openairdocs.org/ntsb/CEN26LA296.md): Para-Ski VX · Westport, SD · Accident · 1 fatal · Class 3 · Limited · Preliminary report · Aug 20, 2026 · C-IFBY · Substantial damage
  > On August 19, 2026, about 1920 central daylight time, a Para-Ski VX powered parachute, C-IFBY, was substantially damaged when it was involved in an accident near Westport, South Dakota. The pilot sustained serious injuries, passenger 1 sustained fatal…
- [NTSB ENG26WA039](https://openairdocs.org/ntsb/ENG26WA039.md): Boeing 737 · Cancun, Mexico · Occurrence · Class 5 · Foreign · Aug 18, 2026 · XA-SSR
- [NTSB ENG26FA034](https://openairdocs.org/ntsb/ENG26FA034.md): Boeing 747 · Anchorage, AK · Incident · No injuries · Class 3 · Field · Preliminary report · Aug 15, 2026 · B-18725 · Minor damage
  > On August 15, 2026, 1755 Alaska Daylight Time, a China Airlines Flight Number CI-5265, Boeing 747-400F, registration B-18725, powered by four GE Aerospace CF6-80C2B1F turbofan engines, experienced an inflight fire indication during the initial climb from Ted…
- [NTSB WPR26FA294](https://openairdocs.org/ntsb/WPR26FA294.md): Textron 172S · Provo, UT · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 7, 2026 · N1842E · Substantial damage
  > On August 7, 2026, about 1549 mountain daylight time, a Textron Aviation Inc. 172S, N1842E, was substantially damaged when it was involved in an accident near Provo, Utah. The flight instructor sustained serious injuries, and the pilot undergoing instruction…
- [NTSB CEN26LA282](https://openairdocs.org/ntsb/CEN26LA282.md): Pzl-Bielsko B1-PW-5 · Briggs, TX · Accident · 1 fatal · Class 3 · Limited · Preliminary report · Aug 6, 2026 · N105WS · Substantial damage
  > On August 6, 2026, about 1538 central daylight time, a PZL-Bielsko B1-PW-5 glider, N105WS, was substantially damaged when it was involved in an accident near Briggs, Texas. The pilot was fatally injured. The glider was operated as a Title 14 Code of Federal…
- [NTSB CEN26LA281](https://openairdocs.org/ntsb/CEN26LA281.md): Mooney M20E · Longmont, CO · Accident · No injuries · Class 4 · Limited · Investigation open · Aug 4, 2026 · N3264F · Substantial damage
- [NTSB CEN26LA277](https://openairdocs.org/ntsb/CEN26LA277.md): Taylorcraft BC12-D · Boyceville, WI · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Aug 2, 2026 · N43665 · Substantial damage
  > On August 2, 2026, about 1223 central daylight time, a Taylorcraft BC12-D airplane, N43665 was substantially damaged when it was involved in an accident near Boyceville, Wisconsin. Both the pilot and passenger were seriously injured. The airplane was operated…
- [NTSB CEN26FA275](https://openairdocs.org/ntsb/CEN26FA275.md): Beech E18S · Guymon, OK · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 2, 2026 · N210Q · Destroyed
  > On August 2, 2026, about 1608 central daylight time (CDT), a Beech E18S airplane, N210Q, was destroyed when it was involved in an accident near Guymon, Oklahoma. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB WPR26FA281](https://openairdocs.org/ntsb/WPR26FA281.md): Piper PA-28-180 · Chandler, AZ · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 29, 2026 · N9062J · Destroyed
  > On July 28, 2026, about 1949 mountain standard time, a Piper PA-28-180, N9062J, was destroyed when it was involved in an accident near Chandler, Arizona. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part…
- [NTSB CEN26LA284](https://openairdocs.org/ntsb/CEN26LA284.md): Cessna 150M · Ferris, TX · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jul 25, 2026 · N18YZ · Substantial damage
  > On July 25, 2026, about 1630 central daylight time, a Cessna 150M, N18YZ, was substantially damaged when it was involved in an accident near Ferris, Texas. One pilot sustained minor injuries and the other pilot had no injuries. The airplane was operated as a…
- [NTSB ENG26LA029](https://openairdocs.org/ntsb/ENG26LA029.md): Boeing 757 · Atlanta, GA · Incident · No injuries · Class 3 · Limited · Preliminary report · Jul 24, 2026 · N662DN · No damage
  > On July 24, 2026, about 14:32 Coordinated Universal Time, a Delta Air Lines Boeing 757-200, N662DN, powered by two Pratt & Whitney PW2037 turbofan engines, experienced a No. 1 (left) engine fire during initial climb from Hartsfield-Jackson Atlanta…
- [NTSB ANC26LA076](https://openairdocs.org/ntsb/ANC26LA076.md): Cessna 180K · Anchorage, AK · Accident · No injuries · Class 4 · Limited · Investigation open · Jul 22, 2026 · N180LW · Substantial damage
- [NTSB WPR26LA263](https://openairdocs.org/ntsb/WPR26LA263.md): Schleicher ASW-27 · Montague, CA · Accident · No injuries · Class 4 · Limited · Investigation open · Jul 15, 2026 · N920KB · Substantial damage
- [NTSB ERA26FA271](https://openairdocs.org/ntsb/ERA26FA271.md): Smith Aerostar 601 · Lake Clear, NY · Accident · 3 fatal · Class 3 · Field · Preliminary report · Jul 14, 2026 · N800AA · Destroyed
  > On July 13, 2026, about 2236 eastern daylight time, a Smith Aerostar 601P, N800AA was destroyed when it was involved in an accident near Lake Clear, New York. The private pilot and two passengers were fatally injured. The airplane was operated as a Title 14…
- [NTSB ERA26FA270](https://openairdocs.org/ntsb/ERA26FA270.md): Beech 95-B55 (T42A) · Metter, GA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 13, 2026 · N55FD · Destroyed
  > On July 13, 2026, about 1114 eastern daylight time, a Beechcraft 95-B55, twin-engine airplane, N55FD, was destroyed when it was involved in an accident near Metter, Georgia. The commercial pilot was fatally injured. The airplane was operated as a Title 14…
- [NTSB WPR26LA258](https://openairdocs.org/ntsb/WPR26LA258.md): Remos Acft Gmbh Flugzeugbau Remos GX · Glendale, AZ · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 12, 2026 · N126GX · Substantial damage
  > On July 12, 2026, at 1018 mountain standard time, a Remos GX airplane, N126GX, was substantially damaged when it was involved in an accident near Glendale, Arizona. The flight instructor and student pilot were uninjured. The airplane was operated as a Title…
- [NTSB ERA26FA269](https://openairdocs.org/ntsb/ERA26FA269.md): Cessna 182 · Piseco, NY · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 12, 2026 · N43TB · Destroyed
  > On July 12, 2026, about 1909 eastern daylight time, a Cessna 182J, N43TB, was destroyed when it was involved in an accident near Piseco, New York. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…
- [NTSB WPR26LA251](https://openairdocs.org/ntsb/WPR26LA251.md): Luscombe 8A · Novato, CA · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 7, 2026 · N45886 · Substantial damage
  > On July 7, 2026, about 1200 Pacific daylight time, a Luscombe 8A, N45886, was substantially damaged when it was involved in an accident near Novato, California. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB CEN26LA246](https://openairdocs.org/ntsb/CEN26LA246.md): Rotec Engineering Rally 3 · Hooker, OK · Accident · Minor injuries · Class 4 · Limited · Final report · Jul 7, 2026 · UNREG · Substantial damage
  > The total loss of engine power due to an engine seizure for undetermined reasons because the wreckage was disposed of before it could be examined.
- [NTSB WPR26LA245](https://openairdocs.org/ntsb/WPR26LA245.md): Piper PA-28-140 · Salome, AZ · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 5, 2026 · N3995K · Substantial damage
  > On July 5, 2026, at about 0825 Pacific daylight time, a Piper PA-28-140, N3995K, was substantially damaged when it was involved in an accident near Salome, Arizona. The pilot and passenger were uninjured. The airplane was operating as a Title 14 Code of…
- [NTSB CEN26LA244](https://openairdocs.org/ntsb/CEN26LA244.md): Cassutt Iiim · Odessa, TX · Accident · Serious injuries · Class 4 · Limited · Final report · Jul 5, 2026 · N45889 · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack during the initial climb, which led to an aerodynamic stall and a loss of airplane control at too low of an altitude to recover. Contributing to the accident was the pilot’s lack of recent…
- [NTSB ERA26LA258](https://openairdocs.org/ntsb/ERA26LA258.md): Portzline Joan M Flight Star II SC · Mulberry, FL · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jul 4, 2026 · N432JP · Substantial damage
  > On July 4, 2026, about 1121 eastern daylight time, an experimental amateur-built Flight Star II SC airplane, N432JP, was substantially damaged when it was involved in an accident near Mulberry, Florida. The private pilot and a passenger were seriously…
- [NTSB ERA26LA254](https://openairdocs.org/ntsb/ERA26LA254.md): Rath Michael J Sonerai 2 · Cynthiana, KY · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 30, 2026 · N1406 · Substantial damage
  > On June 30, 2026, at about 1030 eastern daylight time, an experimental Sonerai 2 airplane, N1406, was substantially damaged when it was involved in an accident near Cynthiana, Kentucky. The pilot was not injured. The airplane was operated as a Title 14 Code…
- [NTSB ANC26LA066](https://openairdocs.org/ntsb/ANC26LA066.md): Diamond Aircraft Ind DA 40 NG · Petersburg, VA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jun 29, 2026 · N602RF · Substantial damage
  > On June 29, 2026, about 1945 eastern daylight time (EDT), a Diamond Aircraft Industries Inc. DA40 NG airplane, N602RF, was substantially damaged when it was involved in an accident near Petersburg, Virginia. The flight instructor sustained serious injuries,…
- [NTSB ERA26FA252](https://openairdocs.org/ntsb/ERA26FA252.md): Piper PA24 · Hazen, ND · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 28, 2026 · N6852P · Destroyed
  > On June 28, 2026, about 1317 central daylight time, a Piper PA-24-250, N6852P, was destroyed when it was involved in an accident near Hazen, North Dakota. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part…
- [NTSB ERA26LA251](https://openairdocs.org/ntsb/ERA26LA251.md): Jones Peter M Boeing/Jones 75 · Cleveland, GA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jun 26, 2026 · N3993C · Substantial damage
  > On June 26, 2026, about 1045 eastern daylight time, a Boeing/Jones 75, N3993C, was substantially damaged when it was involved in an accident near Cleveland, Georgia. The pilot and passenger sustained minor injuries. The airplane was operated as a Title 14…
- [NTSB CEN26LA235](https://openairdocs.org/ntsb/CEN26LA235.md): Beech V35B · Greeley, CO · Accident · No injuries · Class 4 · Limited · Investigation open · Jun 17, 2026 · N4275S · No damage
- [NTSB CEN26FA224](https://openairdocs.org/ntsb/CEN26FA224.md): Pacific Aerospace 750XL · Butler, MO · Accident · 12 fatal · Class 2 · Field · Preliminary report · Jun 14, 2026 · N221BN · Destroyed
  > On June 14, 2026, about 1125 central daylight time, a Pacific Aerospace Limited 750XL airplane, N221BN, was destroyed when it was involved in an accident near Butler, Missouri. The pilot and 11 passengers sustained fatal injuries. The airplane was operated as…
- [NTSB ANC26LA049](https://openairdocs.org/ntsb/ANC26LA049.md): William F Schoen RV-7 · Alpine, CO · Accident · Minor injuries · Class 4 · Limited · Investigation open · Jun 10, 2026 · N727BN · Substantial damage

Next page: https://openairdocs.org/ntsb-phases/350/cases.md?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 c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 350)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/350/cases

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