# NTSB investigations: Enroute NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports. Page 64 of 718 · 35,883 cases ## Cases, newest first - [NTSB ANC17LA014](https://openairdocs.org/ntsb/ANC17LA014.md): Piper PA 32R-300 · McGrath, AK · Accident · Serious injuries · Limited investigation · Final report · Nov 21, 2016 · N4352F · Minor damage > The failure of the nose landing gear to extend and lock due to the failure of the alternator and reduced battery power due to the cold ambient temperature, which prohibited the electrically-driven hydraulic pump from supplying adequate hydraulic pressure to… - [NTSB ERA17FA052](https://openairdocs.org/ntsb/ERA17FA052.md): Ryan Navion · New Gretna, NJ · Accident · 1 fatal · Field investigation · Final report · Nov 20, 2016 · N4976K · Substantial damage > The pilot's inadequate preflight weather planning and in-flight weather evaluation, which resulted in an encounter with a strong cold front and the pilot's subsequent loss of airplane control. - [NTSB ERA17WA060](https://openairdocs.org/ntsb/ERA17WA060.md): Agusta A109A II · Varese, Italy · Accident · 1 fatal · Foreign investigation · Nov 19, 2016 · N109W · Destroyed > On November 19, 2016, at 1316 universal coordinated time, an Augusta A109 A II, N109W, was destroyed when it impacted terrain while navigating near Varese, Italy. An Italian passenger was fatally injured and the Italian certificated pilot and Swiss passenger… - [NTSB WPR17WA027](https://openairdocs.org/ntsb/WPR17WA027.md): Robinson R44 · Mount Windsor, Australia · Accident · 1 fatal · Foreign investigation · Nov 18, 2016 · VH-ZNZ · Destroyed > On November 18, 2016, at 1244 local time, a Robinson R44 II, Australian registration VH-ZNZ, collided with terrain near Mount Windsor, Australia. The helicopter was destroyed by a post impact fire. The pilot sustained serious injuries and the passenger was… - [NTSB GAA17CA086](https://openairdocs.org/ntsb/GAA17CA086.md): Beech A36 · Ft. Myers, FL · Accident · Minor injuries · Data collection · Final report · Nov 18, 2016 · N64793 · Substantial damage > An in-flight collision with a flock of birds. - [NTSB ERA17LA044](https://openairdocs.org/ntsb/ERA17LA044.md): Cessna 152 · Miami, FL · Accident · No injuries · Limited investigation · Final report · Nov 13, 2016 · N94292 · Substantial damage > The loss of torque on the No. 3 connecting rod’s nuts, which resulted in the failure of the No. 3 connecting rod’s bolts and a subsequent total loss of engine power due to the operator's maintenance personnel’s improper installation of the connecting rod nuts. - [NTSB CEN17LA039](https://openairdocs.org/ntsb/CEN17LA039.md): Cessna P210N · Pleasanton, TX · Accident · Serious injuries · Limited investigation · Final report · Nov 13, 2016 · N44C · Substantial damage > Maintenance personnel's improper installation of the throttle linkage attachment hardware, which resulted in a partial loss of engine power when the hardware separated in flight. - [NTSB WPR17LA018](https://openairdocs.org/ntsb/WPR17LA018.md): Grumman American Avn. AA 1C · Hemet, CA · Accident · No injuries · Limited investigation · Final report · Nov 10, 2016 · N9556U · Substantial damage > The pilot’s failure to ensure that sufficient fuel was available for the flight, which resulted in a total loss of engine power due to fuel exhaustion. - [NTSB ERA17LA045](https://openairdocs.org/ntsb/ERA17LA045.md): Cessna 150 · Snow Hill, NC · Accident · No injuries · Limited investigation · Final report · Nov 10, 2016 · N23473 · Substantial damage > The total loss of engine power for reasons that could not be determined because postaccident examination of the airplane did not reveal any evidence of preimpact mechanical malfunctions or failures that would have precluded normal operation. - [NTSB ERA17LA041](https://openairdocs.org/ntsb/ERA17LA041.md): Beech 36 · Ormond Beach, FL · Accident · Serious injuries · Limited investigation · Final report · Nov 9, 2016 · N3089A · Destroyed > A loss of aircraft control for reasons that could not be determined because postaccident examination did not reveal any evidence of preimpact mechanical malfunctions or failures of the flight controls that would have precluded normal operation. - [NTSB ERA17WA178](https://openairdocs.org/ntsb/ERA17WA178.md): Cessna 210 · Metropolitana, Chile · Accident · Minor injuries · Foreign investigation · Nov 8, 2016 · CC-LLH > On August 11, 2016, at 1312 coordinated universal time, a Cessna 210N, Chilean registration CC-LLH, was substantially damaged when it impacted terrain during a forced landing near Metropolitana, Chile. The pilot and one passenger sustained minor injuries.… - [NTSB ERA17LA040](https://openairdocs.org/ntsb/ERA17LA040.md): Cessna 177 · Hopkinton, RI · Accident · No injuries · Limited investigation · Final report · Nov 8, 2016 · N30703 · Substantial damage > The pilot's failure to accurately determine the airplane's fuel quantity before the flight, which resulted in a total loss of engine power due to fuel exhaustion. - [NTSB GAA17CA060](https://openairdocs.org/ntsb/GAA17CA060.md): Cessna 172 · Englewood, CO · Accident · No injuries · Data collection · Final report · Nov 7, 2016 · N6026Z · Substantial damage > An in-flight collision with multiple birds. - [NTSB GAA17CA058](https://openairdocs.org/ntsb/GAA17CA058.md): Beech 58TC · Valdosta, GA · Accident · No injuries · Data collection · Final report · Nov 5, 2016 · N2CH · Substantial damage > The pilot’s failure to ensure that adequate fuel was onboard for the flight, which resulted in fuel exhaustion and the loss of engine power. - [NTSB ERA17LA037](https://openairdocs.org/ntsb/ERA17LA037.md): Aviat A 1B · Geneva, FL · Accident · No injuries · Limited investigation · Final report · Nov 2, 2016 · N54HY · Substantial damage > A partial loss of engine power due to debris in the No. 1 cylinder that damaged the spark plugs. - [NTSB GAA17WA584](https://openairdocs.org/ntsb/GAA17WA584.md): DHC 4 · Perkumpulan, Indonesia · Accident · No injuries · Class 5 · Foreign · Oct 31, 2016 · PK-SWW · Substantial damage - [NTSB ANC17FA004](https://openairdocs.org/ntsb/ANC17FA004.md): Fairchild Heli-Porter Pilatus PC-6 · Port Alsworth, AK · Accident · 1 fatal · Field investigation · Final report · Oct 29, 2016 · N5308F · Substantial damage > The airplane's collision with mountainous terrain while operating in an area of reduced visibility and icing conditions. Contributing to the accident was the pilot's inadequate preflight planning, which would have identified deteriorating weather conditions… - [NTSB CEN17LA030](https://openairdocs.org/ntsb/CEN17LA030.md): Cirrus Design SR22 · Bloomfield, NM · Accident · No injuries · Limited investigation · Final report · Oct 28, 2016 · N234PJ · Substantial damage > Maintenance personnel’s failure to fully torque the fuel port cap, which allowed the cap to back off in flight and interrupted fuel flow to the engine, which resulted in a total loss of engine power. - [NTSB WPR17FA013](https://openairdocs.org/ntsb/WPR17FA013.md): Beech A36 · Pittsburg, CA · Accident · 2 fatal · Field investigation · Final report · Oct 25, 2016 · N364RM · Destroyed > A loss of airplane control for reasons that could not be determined due to the extensive impact and fire damage to the airplane. - [NTSB WPR17LA011](https://openairdocs.org/ntsb/WPR17LA011.md): Mooney M20J · Coalinga, CA · Accident · No injuries · Limited investigation · Final report · Oct 23, 2016 · N201EU · Substantial damage > A partial loss of engine power due to the pilot's improper in-flight fuel management, which resulted in fuel starvation. - [NTSB ERA17WA028](https://openairdocs.org/ntsb/ERA17WA028.md): Robinson R44 · Baleisky, Russia · Accident · 3 fatal · Foreign investigation · Oct 23, 2016 · RA-04347 · Destroyed > On October 23, 2016, about 1030 coordinated universal time, a Robinson R44 helicopter, Russian registration RA-04347, was destroyed when it impacted terrain in the Baleisky district, in eastern Siberia, Russia, while en route from Zolotorechensk Airport to… - [NTSB WPR17LA012](https://openairdocs.org/ntsb/WPR17LA012.md): Northland IVP · Lovelock, NV · Accident · Minor injuries · Limited investigation · Final report · Oct 20, 2016 · N4YB · Substantial damage > A total loss of engine power due to the failure of the intake valve in the No. 3 cylinder for reasons that could not be determined based on the available information. - [NTSB GAA17CA036](https://openairdocs.org/ntsb/GAA17CA036.md): Cessna 172 · Carrabassett, ME · Accident · No injuries · Data collection · Final report · Oct 20, 2016 · N1706F · Substantial damage > The pilot’s failure to maintain clearance from trees while maneuvering at a low altitude. - [NTSB GAA17CA032](https://openairdocs.org/ntsb/GAA17CA032.md): Smith AEROSTAR601 · Carrollton, GA · Accident · No injuries · Data collection · Final report · Oct 20, 2016 · N601UK · Substantial damage > The pilot's failure to verify the usable fuel in the fuel tanks, which resulted in an inaccurate fuel totalizer setting during preflight, fuel exhaustion, and a total loss of engine power. - [NTSB ERA17LA023](https://openairdocs.org/ntsb/ERA17LA023.md): Ercoupe 415 · Lindenwold, NJ · Accident · Serious injuries · Limited investigation · Final report · Oct 19, 2016 · N415WE · Substantial damage > A partial loss of engine power for reasons that could not be determined based on the available information. - [NTSB ERA17WA025](https://openairdocs.org/ntsb/ERA17WA025.md): Piper PA23 · Chimbote, Peru · Incident · No injuries · Foreign investigation · Oct 16, 2016 · OB-2039 · No damage > On October 16, 2016, at 1937 universal time coordinated, a Piper PA-23-250 twin-engine airplane, Peruvian registration OB-2039, was not damaged during a precautionary landing to the Jaime Montreuil M. Airport (CHM), Chimbote, Peru. According to Peruvian… - [NTSB ERA17FA017](https://openairdocs.org/ntsb/ERA17FA017.md): Piper PA28 · Austin, PA · Accident · 3 fatal · Field investigation · Final report · Oct 16, 2016 · C-GYSN · Destroyed > The pilot's loss of control while maneuvering in night instrument conditions that included light-to-heavy rain with severe turbulence, updrafts and downdrafts, and hail. Contributing to the accident was the pilot experiencing spatial disorientation, his lack… - [NTSB CEN17LA019](https://openairdocs.org/ntsb/CEN17LA019.md): Bellanca 17-31A · Mc Alester, OK · Accident · Serious injuries · Limited investigation · Final report · Oct 16, 2016 · N93668 · Substantial damage > A total loss of engine power during initial climb due to fuel starvation. - [NTSB WPR17FA008](https://openairdocs.org/ntsb/WPR17FA008.md): Cessna 182D · South Lake Tahoe, CA · Accident · 1 fatal · Field investigation · Final report · Oct 15, 2016 · N8718X · Destroyed > The noninstrument-rated pilot's decision to depart on and continue a flight over mountainous terrain into forecast instrument metrological conditions, icing, and hazardous wind conditions that exceeded the airplanes performance capabilities and resulted in an… - [NTSB ERA17LA016](https://openairdocs.org/ntsb/ERA17LA016.md): Hatcher Roderick R CH701 · Albrightsville, PA · Accident · Serious injuries · Limited investigation · Final report · Oct 15, 2016 · N3701M · Substantial damage > A total loss of engine power during cruise flight for reasons that could not be determined because postaccident examination revealed no anomalies that would have precluded normal operation. - [NTSB CEN17LA018](https://openairdocs.org/ntsb/CEN17LA018.md): Piper PA 18-150 · Jasper, TX · Accident · Minor injuries · Limited investigation · Final report · Oct 15, 2016 · N9473D · Substantial damage > A partial loss of engine power for reasons that could not be determined, because an examination of the airplane did not identify a specific reason for the loss of engine power. - [NTSB ERA17LA018](https://openairdocs.org/ntsb/ERA17LA018.md): Cessna 208 · Dunnellon, FL · Accident · 1 fatal · Limited investigation · Final report · Oct 14, 2016 · N208KM · Substantial damage > The jumpmaster's failure to guard the reserve parachute ripcord, which caused an inadvertent deployment of his reserve parachute. - [NTSB DCA17WA010](https://openairdocs.org/ntsb/DCA17WA010.md): Piper PA28 · Jozini, South Africa · Accident · No injuries · Foreign investigation · Oct 13, 2016 · ZS-FAI · Destroyed > The government of South Africa has notified the NTSB of an accident involving a PIPER PA28 airplane that occurred on October 13, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of South Africa's investigation under the… - [NTSB WPR17LA004](https://openairdocs.org/ntsb/WPR17LA004.md): Rockwell International 112A · Phoenix, AZ · Accident · Serious injuries · Class 3 · Limited · Final report · Oct 12, 2016 · N509CA · Substantial damage > A catastrophic engine failure due to lack of lubrication due to the absence of 2 piston cooling nozzles that backed out of their respective threaded bores, which resulted in a forced landing on unsuitable terrain. - [NTSB ERA17CA012](https://openairdocs.org/ntsb/ERA17CA012.md): Bellanca 8KCAB · Knoxville, TN · Accident · Minor injuries · Data collection · Final report · Oct 11, 2016 · N2504Z · Substantial damage > The pilot's intentional low-altitude operation, which resulted in his failure to maintain clearance from unmarked utility wires. - [NTSB GAA17CA022](https://openairdocs.org/ntsb/GAA17CA022.md): Allen Robert RV6 · Ocala, FL · Accident · No injuries · Data collection · Final report · Oct 10, 2016 · N399DC · Substantial damage > The pilot's improper fuel planning, which resulted in fuel exhaustion, a total loss of engine power, and a forced landing. - [NTSB WPR17LA003](https://openairdocs.org/ntsb/WPR17LA003.md): Melborn Joe B Kolb Sport 600 · Roberts, ID · Accident · Minor injuries · Limited investigation · Final report · Oct 9, 2016 · N914NK · Substantial damage > A total loss of engine power for reasons that could not be determined based on the available information. - [NTSB ERA17LA019](https://openairdocs.org/ntsb/ERA17LA019.md): Cessna 182 · Toone, TN · Accident · No injuries · Limited investigation · Final report · Oct 9, 2016 · N65903 · Substantial damage > A stuck No. 3 cylinder exhaust valve, which resulted in failure of the cylinder's valvetrain components, breach of the cylinder's rocker box cover, and partial loss of engine power due to oil starvation. - [NTSB CEN17LA014](https://openairdocs.org/ntsb/CEN17LA014.md): Cessna 150M · Beasley, TX · Accident · No injuries · Limited investigation · Final report · Oct 8, 2016 · N704LE · Substantial damage > The No. 2 cylinder exhaust valve being stuck in the “full open” position due to carbon deposits, which resulted in a total loss of engine power. - [NTSB ERA17CA008](https://openairdocs.org/ntsb/ERA17CA008.md): Algimantas Jonusas RV-10 · Ashwood, VA · Accident · Serious injuries · Data collection · Final report · Oct 7, 2016 · N100UK · Substantial damage > The noninstrument-rated pilot's inadequate preflight and in-flight weather planning and continued flight into instrument meteorological conditions, which resulted in impact with trees and terrain. - [NTSB DCA17WA032](https://openairdocs.org/ntsb/DCA17WA032.md): Cessna 172 · Brits, North West Province, South Africa · Accident · No injuries · Foreign investigation · Oct 7, 2016 · ZS-MPF · Substantial damage > The South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving ZS-MPF, a Cessna 172M airplane that occurred on October 07, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the SACAA's investigation… - [NTSB ERA17LA006](https://openairdocs.org/ntsb/ERA17LA006.md): Piper PA24 · Hollywood, AL · Accident · No injuries · Limited investigation · Final report · Oct 6, 2016 · N8560P · Substantial damage > A failure of the fuel tank selector valve in a partially closed position, which resulted in fuel starvation to the engine and a total loss of engine power. - [NTSB CEN17FA012](https://openairdocs.org/ntsb/CEN17FA012.md): Fairchild Hiller FH 1100 · Lino Lakes, MN · Accident · 2 fatal · Field investigation · Final report · Oct 6, 2016 · N4035G · Destroyed > The separation of the main rotor assembly due to mast bumping. - [NTSB ANC17WA002](https://openairdocs.org/ntsb/ANC17WA002.md): Steen Skybolt · Blackfalds, Canada · Accident · 1 fatal · Foreign investigation · Oct 6, 2016 · C-GWBD · Substantial damage > On October 06, 2016, about 2050 Coordinated Universal Time, an amateur-built Steen Skybolt airplane, C-GWBD, impacted terrain near Blackfalds, Alberta, Canada, under unknown circumstances. The pilot sustained fatal injuries. The Transportation Safety Board… - [NTSB CEN17LA010](https://openairdocs.org/ntsb/CEN17LA010.md): Piper PA 28-180 · Clarendon, TX · Accident · Minor injuries · Limited investigation · Final report · Oct 2, 2016 · N5196L · Substantial damage > The failure of a cylinder piston pin, which resulted in an obstructed oil inlet screen, reduced the amount of oil available to the engine, and led to the subsequent loss of engine power. Contributing to the accident was the failure of the nonmechanic, who had… - [NTSB ANC17MA001](https://openairdocs.org/ntsb/ANC17MA001.md): Cessna 208B · Togiak, AK · Accident · 3 fatal · Class 1 · Major · Final report · Oct 2, 2016 · N208SD · Destroyed > The flight crew's decision to continue the visual flight rules flight into deteriorating visibility and their failure to perform an immediate escape maneuver after entry into instrument meteorological conditions, which resulted in controlled flight into… - [NTSB CEN17LA009](https://openairdocs.org/ntsb/CEN17LA009.md): Aero Smart Solutions Lancair Evolution · Iola, KS · Accident · Minor injuries · Limited investigation · Final report · Oct 1, 2016 · N38DM · Substantial damage > Water contamination of the fuel due to the pilot’s inadequate preflight inspection, which led to a total loss of engine power. Contributing to the accident was the pilot’s failure to complete the engine-out checklist, which resulted in an excessive loss of… - [NTSB WPR16LA189](https://openairdocs.org/ntsb/WPR16LA189.md): Dehavilland Beaver DHC 2 MK.1 · Lopez Island, WA · Accident · Serious injuries · Limited investigation · Final report · Sep 30, 2016 · N6781L · Substantial damage > The pilot's decision to land in an area of low visibility and ground fog, which resulted in collision with water. - [NTSB ERA16WA332](https://openairdocs.org/ntsb/ERA16WA332.md): Cessna 208 · San Antonio De Prado, Colombia · Accident · 4 fatal · Foreign investigation · Sep 30, 2016 · HK3804 · Substantial damage > On September 30, 2016, about 1705 coordinated universal time, a Cessna 208B, Colombian registration HK3804, was substantially damaged when it impacted high terrain near San Antonio De Prado, Colombia. One of the Colombian certificated pilots and three of the… - [NTSB ERA16LA331](https://openairdocs.org/ntsb/ERA16LA331.md): Piper PA32RT · Camden, SC · Accident · Minor injuries · Limited investigation · Final report · Sep 30, 2016 · N39686 · Substantial damage > A total loss of engine power due to the improper torqueing of the magneto, which led it to its malfunctioning in flight. Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=65 ## The whole list in SQL Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS: ```sql WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')), crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')), current_codes AS ( SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code, row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*' AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982")) ), phases AS ( SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main FROM current_codes WHERE n = 1 UNION ALL SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode" WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes) ), case_phases AS ( SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1 WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names) ) SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 400) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/400/cases?page=64 --- 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.