# 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 162 of 718 · 35,885 cases ## Cases, newest first - [NTSB DCA02MA003](https://openairdocs.org/ntsb/DCA02MA003.md): Cessna 208 · Dillingham, AK · Accident · 10 fatal · Major investigation · Final report · Oct 10, 2001 · N9530F · Destroyed > an in-flight loss of control resulting from upper surface ice contamination that the pilot-in-command failed to detect during his preflight inspection of the airplane. Contributing to the accident was the lack of a preflight inspection requirement for CE-208… - [NTSB FTW02LA006](https://openairdocs.org/ntsb/FTW02LA006.md): Aerospatiale AS355F1 · Rosebud, TX · Accident · Minor injuries · Limited investigation · Final report · Oct 8, 2001 · N911BB · Substantial damage > The pilots impairment due to drugs. Contributing factors were the dark night light conditions, the pilot's failure to refuel, resulting in the total loss of engine power due to fuel exhaustion, and the pilot's misjudged landing flare. - [NTSB CHI02LA002](https://openairdocs.org/ntsb/CHI02LA002.md): Worner 1000 STU · Liberal, KS · Accident · No injuries · Limited investigation · Final report · Oct 7, 2001 · D-OAGH · Substantial damage > The pilot's inadvertent flight into adverse weather conditions during cruise flight and the unsuitable landing area encountered during the uncontrolled descent. Factors relating to this accident were the high wind, the pilot's unsuccessful attempt to… - [NTSB SEA02LA003](https://openairdocs.org/ntsb/SEA02LA003.md): Ellsberg One Design · Bend, OR · Accident · Minor injuries · Limited investigation · Final report · Oct 6, 2001 · N55TE · Substantial damage > the separation of a propeller counterweight mounting bracket due to incorrect mounting bolt torque. Factors include significant powerplant vibration during the forced landing, no suitable landing area, and soft terrain next to the narrow road on which the… - [NTSB NYC02LA005](https://openairdocs.org/ntsb/NYC02LA005.md): Reindl CGS Hawk A · Fayetteville, OH · Accident · Serious injuries · Limited investigation · Final report · Oct 5, 2001 · N3963W · Substantial damage > The owner/mechanic's inadequate annual inspection. A factor related to the accident was the rotted fuel line which separated from it's connection at the fuel pump. - [NTSB IAD02FA002](https://openairdocs.org/ntsb/IAD02FA002.md): Cessna 210M · Pittsfield, PA · Accident · 2 fatal · Field investigation · Final report · Oct 5, 2001 · N6053B · Destroyed > The pilot's loss of control in flight due to spatial disorientation, and his subsequent overstress of the airplane during a recovery attempt. A factor in the accident was the pilot's use of inappropriate medications. - [NTSB IAD02LA001](https://openairdocs.org/ntsb/IAD02LA001.md): Cessna 172B · Phillips, ME · Accident · Serious injuries · Limited investigation · Final report · Oct 4, 2001 · N7591X · Substantial damage > Loss of engine power due to a blockage of the left fuel tank vent line with mud, and the subsequent inadvertent stall. - [NTSB NYC02LA027](https://openairdocs.org/ntsb/NYC02LA027.md): Let Blanik L 33 Solo · Windsor, VA · Accident · No injuries · Limited investigation · Final report · Oct 3, 2001 · N388BA · Substantial damage > The pilot's inadequate preflight inspection, which resulted in a loose battery charger becoming entangled in the rudder pedals during a spin recovery, and a subsequent overstress of the glider. Factors included the loose battery charger, and the non-standard… - [NTSB FTW02LA002](https://openairdocs.org/ntsb/FTW02LA002.md): Hamilton Genesis · Grants, NM · Accident · Serious injuries · Limited investigation · Final report · Oct 3, 2001 · N715MP · Substantial damage > the loose throttle cable resulting in a partial loss of engine power. Contributing factors were the pilot's failure to perform the required yearly condition inspection prior to flight and the lack of suitable terrain for the forced landing. - [NTSB CHI02FA001](https://openairdocs.org/ntsb/CHI02FA001.md): Enstrom F-28A · Attica, MI · Accident · 1 fatal · Field investigation · Final report · Oct 3, 2001 · N137E · Substantial damage > The reported loss of engine power due to fuel exhaustion during cruise flight, the pilot not performing an autorotation, the pilot not maintaining rotor RPM during his emergency descent, and the pilot not maintaining control of the helicopter. A factor was… - [NTSB NYC02LA003](https://openairdocs.org/ntsb/NYC02LA003.md): Piper PA-12 · Ashland, ME · Accident · Minor injuries · Limited investigation · Final report · Oct 2, 2001 · N2528M · Substantial damage > The pilot's inadequate preflight planning, which resulted in a loss of engine power due to fuel exhaustion. - [NTSB NYC02LA002](https://openairdocs.org/ntsb/NYC02LA002.md): Beech C-45H · Hudson, NH · Accident · Minor injuries · Limited investigation · Final report · Oct 2, 2001 · N8393H · Substantial damage > The pilot/owner's failure to properly identify the inoperative engine prior to feathering the wrong propeller, and his lack of familiarity with the required corrective procedures. A factor was the initial engine failure. - [NTSB SEA02LA001](https://openairdocs.org/ntsb/SEA02LA001.md): Cessna 172 · Lindsay, MT · Accident · Serious injuries · Limited investigation · Final report · Oct 1, 2001 · N3910F · Destroyed > The pilot's failure to maintain an altitude clear of terrain. A factor was intentional low altitude flight. - [NTSB LAX01FA306](https://openairdocs.org/ntsb/LAX01FA306.md): Bell 206B · Hilo, HI · Accident · Minor injuries · Field investigation · Final report · Sep 30, 2001 · N206KS · Destroyed > The failure of the mechanic to secure the No. 8 bearing thrust nut during maintenance work, which resulted in the total failure of the first stage turbine wheel shaft. Also causal was his misjudgment of his height during the flare resulting in a hard landing.… - [NTSB CHI01FA329](https://openairdocs.org/ntsb/CHI01FA329.md): Cessna 414 Riley Super-8 · Marshfield, WI · Accident · 3 fatal · Field investigation · Final report · Sep 29, 2001 · N414NG · Destroyed > The pilot's failure to maintain adequate airspeed (Vmc) which resulted in a loss of control. Contributing factors were the improper in-flight planning/decision not to land at a closer airport and the lack of recent experience in multiengine airplanes by the… - [NTSB FTW01LA207](https://openairdocs.org/ntsb/FTW01LA207.md): Ayres S2R-T11 · Spur, TX · Accident · No injuries · Limited investigation · Final report · Sep 19, 2001 · N40173 · Substantial damage > the loss of engine power while in cruise flight for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing. - [NTSB CHI01LA318](https://openairdocs.org/ntsb/CHI01LA318.md): Cirrus Design SR-20 · St. Bonifacius, MN · Accident · Serious injuries · Limited investigation · Final report · Sep 19, 2001 · N747TW · Substantial damage > Improper servicing of the airplane by other maintenance personnel, inadequate inspection of the airplane by the other maintenance personnel prior to the airplane's flight, and the unsuitable terrain encountered during the forced landing. Factors relating to… - [NTSB ATL01LA110](https://openairdocs.org/ntsb/ATL01LA110.md): Cessna 172R · Orlando, FL · Accident · No injuries · Limited investigation · Final report · Sep 17, 2001 · N158RA · Substantial damage > The improper installation of the engine vacuum pump by maintenance personnel which resulted in oil exhaustion and the subsequent loss of engine power. A factor was the none-suitable terrain. - [NTSB LAX01LA286](https://openairdocs.org/ntsb/LAX01LA286.md): Cessna 172L · Tucson, AZ · Accident · 1 fatal · Limited investigation · Final report · Sep 16, 2001 · N4312Q · Destroyed > the pilot's controlled descent into a residence for undetermined reasons. - [NTSB DCA01MA065](https://openairdocs.org/ntsb/DCA01MA065.md): Boeing 757 · Shanksville, PA · Accident · 44 fatal · Major investigation · Final report · Sep 11, 2001 · N591UA · Destroyed > The Safety Board did not determine the probable cause and does not plan to issue a report or open a public docket. The terrorist attacks of September 11, 2001 are under the jurisdiction of the Federal Bureau of Investigation. The Safety Board provided… - [NTSB DCA01MA064](https://openairdocs.org/ntsb/DCA01MA064.md): Boeing 757-200 · Arlington, VA · Accident · 64 fatal · Major investigation · Final report · Sep 11, 2001 · N644AA · Destroyed > The Safety Board did not determine the probable cause and does not plan to issue a report or open a public docket. The terrorist attacks of September 11, 2001 are under the jurisdiction of the Federal Bureau of Investigation. The Safety Board provided… - [NTSB DCA01MA063](https://openairdocs.org/ntsb/DCA01MA063.md): Boeing 767-200ER · New York City, NY · Accident · 65 fatal · Major investigation · Final report · Sep 11, 2001 · N612UA · Destroyed > The Safety Board did not determine the probable cause and does not plan to issue a report or open a public docket. The terrorist attacks of September 11, 2001 are under the jurisdiction of the Federal Bureau of Investigation. The Safety Board provided… - [NTSB DCA01MA060](https://openairdocs.org/ntsb/DCA01MA060.md): Boeing 767-200ER · New York City, NY · Accident · 92 fatal · Major investigation · Final report · Sep 11, 2001 · N334AA · Destroyed > The Safety Board did not determine the probable cause and does not plan to issue a report or open a public docket. The terrorist attacks of September 11, 2001 are under the jurisdiction of the Federal Bureau of Investigation. The Safety Board provided… - [NTSB NYC01LA226](https://openairdocs.org/ntsb/NYC01LA226.md): Murray JN4-D · Morrisdale, PA · Accident · Serious injuries · Limited investigation · Final report · Sep 9, 2001 · N176TP · Substantial damage > Failure of the ignition coil, which resulted in a loss of engine power. A factor was the 10-foot corn in the forced landing field. - [NTSB ATL01FA105](https://openairdocs.org/ntsb/ATL01FA105.md): Piper PA-32R-301 · Byhalia, MS · Accident · 2 fatal · Field investigation · Final report · Sep 8, 2001 · N8398Z · Destroyed > The pilot's improper evaluation of weather conditions which lead to an inflight encounter with turbulent weather resulting in an in flight break up of the airframe, and subsequent uncontrolled descent into terrain. A factor was the pilot's drug impairment. - [NTSB CHI01FA312](https://openairdocs.org/ntsb/CHI01FA312.md): Piper PA-32R-301T · Downers Grove, IL · Accident · Serious injuries · Field investigation · Final report · Sep 7, 2001 · N81557 · Destroyed > the improper preflight planning/preparation and the short field take off/procedure not followed by the pilot. Contributing factors were the airplane's forward center of gravity, the variable gusting wind and improper weight and balance calculations by… - [NTSB ANC01LA138](https://openairdocs.org/ntsb/ANC01LA138.md): de Havilland DHC-3 · Cordova, AK · Accident · Minor injuries · Limited investigation · Final report · Sep 7, 2001 · N254AW · Substantial damage > The loss of engine power during cruise due to the fracture of an engine cylinder exhaust valve. - [NTSB ATL01LA103](https://openairdocs.org/ntsb/ATL01LA103.md): North American P51-D · Lincolnton, NC · Accident · Serious injuries · Limited investigation · Final report · Sep 6, 2001 · N551CB · Destroyed > A cooling system failure, that resulted in a total loss of coolant and the subsequent loss of engine power. A factor was the lack of suitable terrain for an emergency landing. - [NTSB LAX01LA300](https://openairdocs.org/ntsb/LAX01LA300.md): Cessna 182G · Cottonwood, AZ · Accident · Serious injuries · Limited investigation · Final report · Sep 5, 2001 · N3250S · Substantial damage > The pilot's failure to obtain/maintain a proper descent rate, as well as prematurely starting his decent during nighttime operations, subsequently colliding with 60-foot power lines 4 miles from the airport. - [NTSB LAX01LA289](https://openairdocs.org/ntsb/LAX01LA289.md): Cessna 150J · Sonoma, CA · Accident · No injuries · Limited investigation · Final report · Sep 5, 2001 · N51256 · Substantial damage > Fuel exhaustion due to the pilot's inadequate preflight fuel consumption calculations and failure to ensure that adequate fuel was onboard the airplane prior to departure. A factor in the accident was the pilot's continued use of the airplane with known… - [NTSB ANC01LA148](https://openairdocs.org/ntsb/ANC01LA148.md): Cessna 180 · Big Lake, AK · Accident · No injuries · Limited investigation · Final report · Sep 5, 2001 · N74806 · Substantial damage > A loss of engine power during cruise flight for an undertermined reason. - [NTSB NYC01LA220](https://openairdocs.org/ntsb/NYC01LA220.md): Andre Mini Max 1500R · Chesapeake, VA · Accident · No injuries · Limited investigation · Final report · Sep 3, 2001 · N962JA · Substantial damage > The pilot's failure to follow the engine manufacturer's descent procedure, which resulted in a lean mixture condition and subsequent engine seizure. - [NTSB NYC01LA221](https://openairdocs.org/ntsb/NYC01LA221.md): de Havilland DHC-94 Moth Minor · Farmington, PA · Accident · No injuries · Limited investigation · Final report · Sep 2, 2001 · N9403 · Substantial damage > The in-flight separation of a propeller blade, which resulted in a forced landing to unsuitable terrain. A factor related to the accident was the plowed field. - [NTSB ANC01LA141](https://openairdocs.org/ntsb/ANC01LA141.md): Jacobs KE-1-A · Willow, AK · Accident · No injuries · Limited investigation · Final report · Sep 1, 2001 · N24KJ · Substantial damage > A loss of engine power during cruise flight for an undertermined reason. - [NTSB SEA01MA163](https://openairdocs.org/ntsb/SEA01MA163.md): Kawasaki KV-107-II · Emigrant, MT · Accident · 3 fatal · Major investigation · Final report · Aug 31, 2001 · N186CH · Destroyed > The loss of control during cruise/climb flight for undetermined reasons. - [NTSB IAD01LA102](https://openairdocs.org/ntsb/IAD01LA102.md): Embraer ERJ-135ER · Richmond, VA · Accident · Serious injuries · Limited investigation · Final report · Aug 30, 2001 · N25504 · No damage > Inadequate company procedures/directives, which resulted in the flight attendant leaving her seat prematurely, while the airplane was still in an area of turbulence. - [NTSB ATL01LA098](https://openairdocs.org/ntsb/ATL01LA098.md): Schleicher ASK-21 · Eagleville, TN · Accident · No injuries · Limited investigation · Final report · Aug 26, 2001 · N121FL · Substantial damage > The loss of thermals during the glider flight that resulted in the collision with high vegetation while maneuvering for an emergency landing. A factor was high vegetation. - [NTSB ATL01LA095](https://openairdocs.org/ntsb/ATL01LA095.md): Piper PA-32-300 · Homerville, GA · Accident · No injuries · Limited investigation · Final report · Aug 26, 2001 · N2116G · Substantial damage > The improper replacement of an accessory drive component with an unapproved part by maintenance personnel, which resulted in a fatigue fracture of the component and loss of engine power. The airplane subsequently collided with power lines and trees during an… - [NTSB SEA01LA157](https://openairdocs.org/ntsb/SEA01LA157.md): Super Quickie 2 · Bonney Lake, WA · Accident · No injuries · Limited investigation · Final report · Aug 25, 2001 · N34DQ · Substantial damage > Improper carburetor adjustment resulting in a total loss of engine power while in a descent configuration. Factors include an excessively lean mixture setting and unsuitable terrain for landing. - [NTSB LAX01LA288](https://openairdocs.org/ntsb/LAX01LA288.md): Ryan ST3KR · Camarillo, CA · Accident · No injuries · Limited investigation · Final report · Aug 25, 2001 · N48742 · Substantial damage > The improper fabrication/reassembly and inspection of the engine throttle control linkage during aircraft restoration by the operator, and the failure of the operator's inspection personnel to detect the error during subsequent annual inspections. - [NTSB FTW01LA195](https://openairdocs.org/ntsb/FTW01LA195.md): Bell 206L-3 · Cameron, LA · Accident · Serious injuries · Limited investigation · Final report · Aug 24, 2001 · N350AL · Destroyed > fuel contamination due to the combination of DIEGME, water, and bacterial growth, which resulted in formation of an apple-jelly type material that blocked the fuel nozzle screen and led to a loss of engine power. - [NTSB CHI01FA290](https://openairdocs.org/ntsb/CHI01FA290.md): Navion L-17B · Newaygo, MI · Accident · 1 fatal · Field investigation · Final report · Aug 23, 2001 · N1017B · Substantial damage > The pilot inadvertently positioning the fuel selector in an intermediate position, resulting in a loss of engine power. An additional cause was the pilot's failure to verify the fuel selector position during the engine restart attempt. Factors to the accident… - [NTSB FTW01FA188](https://openairdocs.org/ntsb/FTW01FA188.md): Cessna 152 · Weatherford, TX · Accident · 1 fatal · Field investigation · Final report · Aug 22, 2001 · N4755B · Destroyed > The student pilot's improper decision making in that he landed with a tailwind and failed to execute a go-around, which resulted in a runway overrun. Contributing factors were the inaccurate reading of the left fuel gage as a result of improper maintenance by… - [NTSB MIA01LA224](https://openairdocs.org/ntsb/MIA01LA224.md): Airbus Industrie A320-232 · Needles, CA · Accident · Serious injuries · Limited investigation · Final report · Aug 20, 2001 · N605AW · No damage > an inadvertent in-flight encounter with turbulence. - [NTSB MIA01LA222](https://openairdocs.org/ntsb/MIA01LA222.md): Cirrus Design SR-22 · Mitchell, GA · Accident · No injuries · Limited investigation · Final report · Aug 19, 2001 · N232CD · Substantial damage > The poor in-flight planning by the pilot-in-command resulting in the total loss of engine power due to fuel starvation. - [NTSB ATL01FA094](https://openairdocs.org/ntsb/ATL01FA094.md): Piper PA-28-151 · Rienzi, MS · Accident · 3 fatal · Field investigation · Final report · Aug 19, 2001 · N57297 · Destroyed > The pilot experienced spatial disorientation, which resulted in an in-flight loss of control and subsequent collision with trees and terrain. A factor was the dark night condition. - [NTSB FTW01LA200](https://openairdocs.org/ntsb/FTW01LA200.md): Cessna 182A · Salado, TX · Accident · No injuries · Limited investigation · Final report · Aug 18, 2001 · N4795D · Substantial damage > A loss of engine power for undetermined reasons. A factor was the pilot's failure to maintain airspeed during the forced landing resulting in a stall. This report was modified on December 2, 2005. - [NTSB DEN01LA149](https://openairdocs.org/ntsb/DEN01LA149.md): Piper PA-32RT-300 · Rock Springs, WY · Accident · No injuries · Limited investigation · Final report · Aug 18, 2001 · N3015L · Substantial damage > the mechanic's failure to perform an airworthiness directive, which resulted in the loss of engine oil through a partially failed oil filter converter plate gasket, and subsequent failure of a connecting rod during cruise flight. A contributing factor was the… - [NTSB CHI01LA285](https://openairdocs.org/ntsb/CHI01LA285.md): Waters Avid Bandit · Northville, MI · Accident · Serious injuries · Limited investigation · Final report · Aug 18, 2001 · N62PT · Substantial damage > fuel starvation due to the pilot's improper fuel calculations. A factor was the concrete building. - [NTSB CHI01LA284](https://openairdocs.org/ntsb/CHI01LA284.md): Cameron Balloons Shuttle 90 · Centralia, IL · Accident · Minor injuries · Limited investigation · Final report · Aug 18, 2001 · N8094S · Destroyed > The balloon envelope fire. A contributing factor was the flammability of the envelope. Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=163 ## 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=162 --- 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.