# Major NTSB investigations

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 10 of 14 · 654 cases

## Cases, newest first

- [NTSB ATL85MA275](https://openairdocs.org/ntsb/ATL85MA275.md): Smith, Ted Aerostar Aerostar 600 · Eva, AL · Accident · 6 fatal · Major investigation · Final report · Sep 13, 1985 · N680CC · Destroyed
  > Drg an IFR arrival/dscnt, the plt stated he 'had to feather 1 eng, I have an oil leak & I'm just trying to dscnd...' He then said he was dscndg thru 5300'. As he contd the apch, he informed the controller he would be unable to go around since the hydr sys…
- [NTSB DCA85AA036](https://openairdocs.org/ntsb/DCA85AA036.md): Douglas DC-9-14 · Milwaukee, WI · Accident · 31 fatal · Final report · Sep 6, 1985 · N100ME · Destroyed
  > The Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-87/01. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm Drg…
- [NTSB DCA85AA035](https://openairdocs.org/ntsb/DCA85AA035.md): Beech 99 · Auburn, ME · Accident · 8 fatal · Final report · Aug 26, 1985 · N300WP · Destroyed
  > Drg arr, aprx 12 mi south of the final apch fix (faf), flt 1808 was clrd for an ILS rwy 4 apch. Aprx 3 min later, ATC controller (ctlr) noted acft was tracking east of the localizer (LOC) course. He asked if the flt was rcvg the ILS LOC. Capt replied 'not yet…
- [NTSB ANC85MA157](https://openairdocs.org/ntsb/ANC85MA157.md): Gates Learjet 24D · Gulkana, AK · Accident · 3 fatal · Major investigation · Final report · Aug 20, 1985 · N455JA · Destroyed
  > During a night arrival, the flt was on an instrument apch to the Gulkana arpt when radio contact with the acft was lost. A search was initiated & the wreckage was found 7.4 mi north of the terminal VOR on the 330 deg radial. The inbound course for the VOR rwy…
- [NTSB FTW85MA317](https://openairdocs.org/ntsb/FTW85MA317.md): Beech 200 · Quinlan, TX · Accident · 3 fatal · Major investigation · Final report · Aug 12, 1985 · N100HC · 2 aircraft · Destroyed
  > N100HC and N33177 collided due to the failure of both plts to maintain adequate visual separation. The PIC of N100HC made a poor decision by performing the simulated emergency descent on a low alt airway. The southerly descending maneuver was performed…
- [NTSB DCA85AA031](https://openairdocs.org/ntsb/DCA85AA031.md): Lockheed L-1011-385-1 · Dallas/Ft Worth, TX · Accident · 135 fatal · Final report · Aug 2, 1985 · N726DA · Destroyed
  > The Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-86/05. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm Psbl…
- [NTSB FTW85MA297](https://openairdocs.org/ntsb/FTW85MA297.md): Beech H35 · El Reno, OK · Accident · 3 fatal · Major investigation · Final report · Jul 25, 1985 · N356B · Destroyed
  > The acft took off at 1054 CDT in VMC with no flt plan. At that time, there was a rprtd ceiling of 1800 ft. at 1112 CDT, the plt rprtd he was at 10,000 ft, 'just reaching the tops.' At 1137 CDT, he stated 'we're about 60 west of oke city, westbound to sayre…
- [NTSB ATL85MA177](https://openairdocs.org/ntsb/ATL85MA177.md): Gulfstream G-159 · Nashville, TN · Accident · 2 fatal · Major investigation · Final report · Jun 1, 1985 · N181TG · Destroyed
  > The acft was being operated as general aviation flt 115 & was deptg on a routine night flt. Drg takeoff/initial climb, the left eng lost pwr. The flt crew attempted to cont the climb-out, but following the application of water-methanol, the plt lost drctnl…
- [NTSB CHI85MA169](https://openairdocs.org/ntsb/CHI85MA169.md): Cessna 310R · St James, MI · Accident · 7 fatal · Major investigation · Final report · Apr 20, 1985 · N1334G · Destroyed
  > During a night arrival, the plt reported that he had the arpt in sight & canceled his IFR flt plan. A witness saw the lights of the acft as it circled the destination arpt. He reported the acft had turned left to a southerly heading, & shortly thereafter, he…
- [NTSB DCA85AA015](https://openairdocs.org/ntsb/DCA85AA015.md): Boeing 747 SP-09 · San Francisco, CA · Accident · Serious injuries · Final report · Feb 19, 1985 · N4522V · Substantial damage
  > While abv a cloud layer (top at FL 370) nr the jet stream, autoplt was engaged & was in the performance mngmnt sys (pms)mode. The pms provided pitch guidance to hold FL 410, roll guidance to ailerons & spoilers for roll ctl & autothrottle to maint.85 mach…
- [NTSB CHI85MA100](https://openairdocs.org/ntsb/CHI85MA100.md): Swearingen SA-227 · London, KY · Accident · Serious injuries · Major investigation · Final report · Jan 31, 1985 · N568UP · Destroyed
  > Drg arrival, at 0540:31, the capt was clrd for an RNAV rwy 5 apch & was told to contact London fss on 121.6 mhz, 'now.' However, he did not make the radio call until aprx 3 min later. The acft broke out of the wx at about 1000' & 1 mi fm the arpt (before the…
- [NTSB ATL85MA083](https://openairdocs.org/ntsb/ATL85MA083.md): Lockheed 188C · Dobbins Afb, GA · Accident · No injuries · Major investigation · Final report · Jan 29, 1985 · N854U · Substantial damage
  > During gear retraction after takeoff, the right main gear became jammed in a partially retracted psn & the respective in-transit gear light would not extinguish. Attempts to recycle the gear were unsuccessful. The flt crew diverted to atlanta, GA; then…
- [NTSB MIA85MA064](https://openairdocs.org/ntsb/MIA85MA064.md): Piper PA-32R-301 · Bradley, FL · Accident · 6 fatal · Major investigation · Final report · Dec 27, 1984 · N8227J · Destroyed
  > The plt completed a 30 min insurance check flt, then loaded the acft with baggage/pax & departed decauter, IL on a flt to naples, FL. A refueling stop was made at columbus, GA. At 1750 the acft departed columbus & cruised uneventfully until sometime after…
- [NTSB DCA85AA004](https://openairdocs.org/ntsb/DCA85AA004.md): Embraer EMB-110P1 · Jacksonville, FL · Accident · 13 fatal · Final report · Dec 6, 1984 · N96PB · Destroyed
  > Provincetown-boston airlines flt 1039, an Embraer EMB-110P1, was cleared to takeoff on rwy 31 at 1812 EST. Drg the initial climb nr the departure end of the rwy, the capt routinely acknowledged an instrn to contact dep control (ctl). Shortly thereafter, the…
- [NTSB ATL85MA049](https://openairdocs.org/ntsb/ATL85MA049.md): Beech 58 · Charleston, SC · Accident · 1 fatal · Major investigation · Final report · Dec 6, 1984 · N7230R · Destroyed
  > Plt descended below mda during a night VOR (non-precision) apch to an uncontrolled arpt and collided with trees & groundwhich were obscured by fog. The plt had 'pushed' himself to make the trip according to friends and associates in an attempt to win an…
- [NTSB LAX85MA012](https://openairdocs.org/ntsb/LAX85MA012.md): Bell 206B · Riverside, CA · Accident · 3 fatal · Major investigation · Final report · Oct 10, 1984 · N3U · Destroyed
  > The acft departed fullerton, CA (elev 96') at O958 PDT on a flt to big bear, CA (elev 6750'). There was no record of the plt obtaining a wx briefing. At aprx 1015, a witness heard the helicopter circling above the bottom of 'an early morning fog hanging over…
- [NTSB LAX85MA008](https://openairdocs.org/ntsb/LAX85MA008.md): Gates Learjet 24B · San Francisco, CA · Accident · 3 fatal · Major investigation · Final report · Oct 9, 1984 · N864CL · Destroyed
  > The acft, a Gates lear jet 24B, modified by a howard/raisebach mark ii conversion, was cleared for takeoff on rwy 28L. Tower psnl estimated that the acft rotated for takeoff at 3200' down the rwy & was at aprx 200' AGL when the plt was instructed to contact…
- [NTSB ATL84MA296](https://openairdocs.org/ntsb/ATL84MA296.md): Piper PA-31T3 · Atlanta, GA · Accident · Serious injuries · Major investigation · Final report · Sep 24, 1984 · N9193Y · Substantial damage
  > The normal fuel load for the flt was 1500 lbs, but with a forecast tail wind & an estimated flt time for only 1+10, the crew accepted the lower indctd (950 lb) fuel load. The flt was uneventful until an indctn of 250 lbs per side, then the fuel 'seemed to…
- [NTSB DEN84MA266](https://openairdocs.org/ntsb/DEN84MA266.md): Aero Commander 690 · Little America, WY · Accident · 4 fatal · Major investigation · Final report · Aug 25, 1984 · N9150N · Destroyed
  > About 10 min after takeoff at 1005 MDT, the plt was cleared to climb to FL 190. This was atc's last communication with the acft. At 1030:39, the controller attempted to contact the plt to advise that he had lost radar contact & to recycle the transponder &…
- [NTSB DCA84AA034](https://openairdocs.org/ntsb/DCA84AA034.md): Beech C-99 · San Luis Obispo, CA · Accident · 17 fatal · Class 1 · Final report · Aug 24, 1984 · N6399U · 2 aircraft · Destroyed
  > At about 1118, a Beech C-99 (wings west flt 628), N6399U, & a rockwell 112TC, N112SM, collided in midair aprx 8 mi west-northwest of the san loui Obispo county arpt. The rockwell 112TC had departed paso robles, CA & was descending toward the san loui Obispo…
- [NTSB NYC84MA270](https://openairdocs.org/ntsb/NYC84MA270.md): Sikorsky S-76A · Fort Dix, NJ · Accident · 1 fatal · Major investigation · Final report · Aug 11, 1984 · N63WW · Destroyed
  > The aircrew of the helicopter contacted mcguire rapcon & obtained clearance to proceed thru the mcguire afb control zone at 1500 ft. a short time later, the crew declared an emergency. Witnesses on the ground heard a loud 'bang' & observed the helicopter…
- [NTSB DCA84AA033](https://openairdocs.org/ntsb/DCA84AA033.md): Britten-Norman BN-2A Islander · Vieques, PR · Accident · 9 fatal · Final report · Aug 2, 1984 · N589SA · Destroyed
  > A witness reported he heard an apparent eng problem after the acft took off & began a left turn for a x-wind departure. Reportedly, the acft oscillated, then after regaining some lost alt, it banked abruptly to the left, nosed down, & subsequently, crashed in…
- [NTSB DEN84MA247](https://openairdocs.org/ntsb/DEN84MA247.md): Cessna 421C · Fort Lupton, CO · Accident · 3 fatal · Major investigation · Final report · Aug 1, 1984 · N6231G · Destroyed
  > During a preflt wx briefing, the plt was advised of thunderstorms & intense rain showers on the route of flt. However, he filed an IFR flt plan & took off. During flt, the ATC controller advised the plt of a level 6 cell ahead & noted that he had no report on…
- [NTSB LAX84MA392](https://openairdocs.org/ntsb/LAX84MA392.md): Piper PA-31T · Concord, CA · Accident · 6 fatal · Major investigation · Final report · Jul 14, 1984 · DIKKS · Destroyed
  > The Piper PA-31T was a foreign registered acft (federal republic of germany). The owner/plt in the left front seat held a german commercial certificate with airplane instrument, single eng land & multi-eng land ratings. The plt in the right front seat held an…
- [NTSB ATL84MA208](https://openairdocs.org/ntsb/ATL84MA208.md): Piper PA-32-300 · Canton, GA · Accident · 5 fatal · Major investigation · Final report · Jun 24, 1984 · N8640N · Destroyed
  > The acft with a student plt at the controls had an in-flt breakup during a night x-country flt. During a preflt wx briefing, he was advised that VFR flt was not recommended. The plt terminated the conversation before the briefing was completed. While in flt,…
- [NTSB CHI84MA249](https://openairdocs.org/ntsb/CHI84MA249.md): Cessna 340A · Cincinnati, OH · Accident · 4 fatal · Major investigation · Final report · Jun 20, 1984 · N5345J · Destroyed
  > Plt requested fuel from FBO but failed to make it clear what type he wanted. The FBO personnel misunderstood the plt's request and refueled the acft with 'jet a' instead of aviation grade gasoline. The plt did not monitor the refueling process and failed to…
- [NTSB DCA84AA027](https://openairdocs.org/ntsb/DCA84AA027.md): Learjet 23A · Windsor Locks, CT · Accident · 3 fatal · Final report · Jun 5, 1984 · N101PP · Destroyed
  > According to witnesses, the acft made a normal apch to rwy 33 with no apparent abnormalities. However, when it was about 200 ft over the apch lights, they heard an increase in the eng thrust & the acft's descent stopped. Two plt witnesses thought the aircrew…
- [NTSB DCA84AA025](https://openairdocs.org/ntsb/DCA84AA025.md): Boeing 727-222 · Denver, CO · Accident · No injuries · Final report · May 31, 1984 · N7640U · Substantial damage
  > Before takeoff, the crew of N7647U (ua flt 663) noted cumulus clouds & virga in the area. At 1327, a Dehavilland dash 7 crew rprtd a 25 kt loss of airspeed, but svrl other acft then took off without rprtg a problem. Due to radio conjestion,the captain did not…
- [NTSB NYC84MA151](https://openairdocs.org/ntsb/NYC84MA151.md): Piper PA-60-601P · Cockeysville, MD · Accident · 2 fatal · Major investigation · Final report · Apr 28, 1984 · N6079R · Destroyed
  > On the day of departure the plt had received a 30 min familiarization flt upon completion of the superstar conversion. Emphasis was directed to eng gages, fuel flow & counter, & power settings. The flt was flown at 5,500 ft. the plt then obtained a wx…
- [NTSB ATL84MA148](https://openairdocs.org/ntsb/ATL84MA148.md): Piper PA-34-220T · Mt Airy, GA · Accident · 6 fatal · Major investigation · Final report · Apr 23, 1984 · N8443H · Destroyed
  > Drg arrival, the plt reqd & rcvd clnc to fly drct to the unctld arpt, altho the arpt had no terminal nav fac & the acft had no RNAV type equip. Nrby at athens, the 0745 spl wx OBS was in part: indef cig, sky obscd, vsby 1/4 mi with fog. At 0801, atl ctr clrd…
- [NTSB ATL84MA114](https://openairdocs.org/ntsb/ATL84MA114.md): Cessna 421B · Cullman, AL · Accident · 6 fatal · Major investigation · Final report · Mar 6, 1984 · N3291Q · Destroyed
  > Plt cleared for night NDB rwy 19 apch to folwom field. Erratic radar track drg procedure turn and inbd intercept. Witnesses described 200 ft ceiling and reduced vis in fog at airport. Other witnesses observed acft on northbound course,followed by turn to west…
- [NTSB NYC84MA102](https://openairdocs.org/ntsb/NYC84MA102.md): Piper PA-31 · Cumberland, MD · Accident · 3 fatal · Major investigation · Final report · Mar 5, 1984 · N6629L · Destroyed
  > Approx 16 min prior to the accident the plt was cleared for the localizer DME approach. The acft collided with the mountainous terrain on a hdg of about 220 degrees at approx 8.5 DME on a bearing of 051 degrees from the arpt. As indicated on the loc/dme rwy…
- [NTSB DCA84AA018](https://openairdocs.org/ntsb/DCA84AA018.md): Mcdonnell Douglas DC-10-30 · Jamaica, NY · Accident · Serious injuries · Final report · Feb 28, 1984 · LNRKB · Substantial damage
  > During an ILS apch to rwy 4R with a tailwind, the acft (scandinavian flt 901) was being flown by the coplt. The acft was fast on final apch & was landed aprx 4700 ft beyond the apch end of the rwy at 36 KTS above the programmed touchdown speed. The aircrew…
- [NTSB ANC84MA037](https://openairdocs.org/ntsb/ANC84MA037.md): Embraer EM-110P1 · Cordova, AK · Accident · No injuries · Major investigation · Final report · Feb 22, 1984 · N103VA · Substantial damage
  > During a landing at night, the acft touched down slightly left of the rwy centerline, which was not visible, & began veering to the left. The plt reported that the acft did not respond to rudder inputs, rudder tiller inputs or differential reverse thrust. It…
- [NTSB ATL84MA101](https://openairdocs.org/ntsb/ATL84MA101.md): Beech V35B · Charlottesville, VA · Accident · 4 fatal · Major investigation · Final report · Feb 17, 1984 · N9353Q · Destroyed
  > While proceeding on an IFR flt plan, the plt requested he be assigned an alt below 8000 ft due to 'a passenger with an ear problem.' Otherwise, the en route portion of the flt proceeded without incident. During arrival, the plt was cleared for an ILS apch to…
- [NTSB DCA84AA014](https://openairdocs.org/ntsb/DCA84AA014.md): Fokker F27-100 · Jamaica, NY · Accident · Serious injuries · Final report · Jan 13, 1984 · N148PM · Substantial damage
  > During the previous flt, the acft encountered light icing conditions while crusing at 4000 ft. the capt stated that the ice disappeared from the acft's structure in the course of its descent at 3000 ft & he did not use wing de-icing or the eng cowling…
- [NTSB MKC84MA060](https://openairdocs.org/ntsb/MKC84MA060.md): Douglas DC-3C · St. Louis, MO · Accident · 1 fatal · Major investigation · Final report · Jan 10, 1984 · CGSCA · Substantial damage
  > After landing, the plt-in-command (PIC) placed a refueling order to fill the acft's two 210 gal main tanks for a return flt to toronto, ontario, Canada. After the cargo was unloaded & the acft was refueled, the aircrew aborted the 1st 2 attempts to takeoff…
- [NTSB DCA84AA013](https://openairdocs.org/ntsb/DCA84AA013.md): McDonnell Douglas DC-10-30CF · Anchorage, AK · Accident · Serious injuries · Final report · Dec 23, 1983 · H7339 · 2 aircraft · Destroyed
  > A Piper PA-31, N35206, (south central air flt 59) was cleared to taxi to rwy 6L. The wx at that time was foggy with about 1/8 mi vsiibility, but the RVR was improving & the arpt was expected soon to be acceptable for takeoffs. The PA-31 crew taxied & waited…
- [NTSB ATL84MA063](https://openairdocs.org/ntsb/ATL84MA063.md): Piper PA-34-200T · Lawrenceburg, TN · Accident · 4 fatal · Major investigation · Final report · Dec 12, 1983 · N66MZ · Destroyed
  > During the descent at Lawrenceburg the acft went into clouds at 3500 ft. at 1709 the acft was cleared for an NDB approach. Minimum alt for the approach is 1560 ft. field elevation is 936 ft. the acft was being tracked on radar and the last contact was about…
- [NTSB ATL84MA052](https://openairdocs.org/ntsb/ATL84MA052.md): Beech 58TC · Knoxville, TN · Accident · 4 fatal · Major investigation · Final report · Nov 27, 1983 · N2131L · Destroyed
  > During arrival, the plt checked in with Knoxville apch control & stated that he was proceeding to the downtown arpt for landing. At that time, the wx at mcghee-tyson arpt (aprx 10 mi ssw) was clear with 7 mi visibility. About 10 min later, the plt reported…
- [NTSB FTW84MA076](https://openairdocs.org/ntsb/FTW84MA076.md): Beech B100 · Midland, TX · Accident · 8 fatal · Major investigation · Final report · Nov 26, 1983 · N1910L · Destroyed
  > The acft crashed while completing a charter flt that began at 1220 CST on 11/25/83 to transport a tv sports film crew. The flt began at Midland, TX & proceeded to fort worth & wichita falls, TX, then began a return flt to Midland. During arrival, the plt…
- [NTSB DCA84AA008](https://openairdocs.org/ntsb/DCA84AA008.md): Lockheed L-1011 · Charleston, SC · Accident · Serious injuries · Final report · Nov 25, 1983 · CFTNJ · Minor damage
  > During flt at FL350, the fltcrew noted some thunderstorms in the vicinity of their route of flt & advised the ATC controller that they might have to detour. After turning & climbing to FL370, they noted 'moderate chop to light turbulence' & saw a flash of…
- [NTSB FTW84MA069](https://openairdocs.org/ntsb/FTW84MA069.md): Cessna 210N · El Paso, TX · Accident · 4 fatal · Major investigation · Final report · Nov 22, 1983 · N4742P · Destroyed
  > N4742P departed El Paso, TX, on an IFR flight plan with a clearance to climb to 10,000 feet. No climb restrictions were included in the clearance. Departure control service was provided by albuquerque ARTCC since El Paso tower had shut downfor the night. The…
- [NTSB SEA84MA016](https://openairdocs.org/ntsb/SEA84MA016.md): de Havilland DHC-2 · Challis, ID · Accident · 4 fatal · Major investigation · Final report · Nov 5, 1983 · N9006 · Destroyed
  > The plt took off from the simplot ranch airstrip which was located beside the middle fork of the salmon river, aprx 27 mi northwest of Challis, ID. He departed downriver toward the northeast, but the destination was a usfs strip about 7 mi upriver to the…
- [NTSB DCA84AA005](https://openairdocs.org/ntsb/DCA84AA005.md): Douglas DC-8-63F · Norfolk, VA · Accident · No injuries · Final report · Oct 25, 1983 · N797FT · Destroyed
  > During arrival at nas Norfolk, the aircrew were vectored for a gca apch to rwy 10. They were advised that the wx was 200 ft scattered, 600 ft overcast, visibility 1 mi with rain, wind was from 360 deg at 20 KTS. Also, they were given a PIREP of 'heavy…
- [NTSB DCA83AA036](https://openairdocs.org/ntsb/DCA83AA036.md): Lockheed Learstar, L-18-56 · Silvana, WA · Accident · 11 fatal · Final report · Aug 22, 1983 · N116CA · Destroyed
  > The acft was on a sport parachute flt to carry 24 parachutists to 12,500' over a drop zone (dz) for a mass jump. It was in a cargo configuration with no passenger seats, but it had 1 jump seat. There were 24 seat belts on the floor of the cargo area. Also,…
- [NTSB DCA83AA034](https://openairdocs.org/ntsb/DCA83AA034.md): Piper PA-31-350 · Peach Springs, AZ · Accident · 10 fatal · Final report · Aug 17, 1983 · N88LV · Destroyed
  > The acft departed las vegas, NV as the 2nd of 5 acft on a scheduled grand canyon sight-seeing flt. The 1st portion of the flt was over the las vegas strip area & lake mead & was uneventful. However, wx conditions precluded the plt from continuing over the…
- [NTSB DCA83AA028](https://openairdocs.org/ntsb/DCA83AA028.md): Douglas DC-9-32 · Covington, KY · Accident · 23 fatal · Final report · Jun 2, 1983 · CFTLU · Substantial damage
  > The Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-86/02. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm At…
- [NTSB MIA83AA136](https://openairdocs.org/ntsb/MIA83AA136.md): Lockheed L-1011 · Miami, FL · Incident · No injuries · Final report · May 5, 1983 · N334EA · No damage
  > The Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-84/04. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm…
- [NTSB DCA83AA023](https://openairdocs.org/ntsb/DCA83AA023.md): Gates Learjet 25 · Newark, NJ · Accident · 2 fatal · Final report · Mar 30, 1983 · N51CA · Destroyed
  > The acft was on a ngt check courier flt. During arrival, the indicated airspeed was well above the legal limit of 250 ktfor flt below 10,000 ft. rwy 4R was selected for landing after the crew were advised that their original choice (rwy 11)was noise…

Next page: https://openairdocs.org/ntsb.md?major=1&page=11

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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.board_report_url IS NOT NULL OR c."investigationClass" = 'Class 1' OR c."caseType" = 'Major - Launch')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?major=1&page=10

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
