NTSB investigations
448 cases where NTSB found Dark.
Cases, newest first
Query with SQL
duckdb -csv -c "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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03036020')) ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03036020')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB ERA09FA116Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Pittstown, NJThe pilot's failure to maintain an adequate clearance from trees during the night landing approach and the flight instructor's inadequate remedial action.NTSB ERA09CA117Accident · No injuriesData collectionFinal reportBeech G35 · Chattanooga, TNThe pilot's failure to see and avoid the marked helicopter dolly. Contributing to the accident were the dark night conditions.NTSB WPR09FA068Accident · No injuriesField investigationFinal reportBoeing 757-351 · Seattle, WAThe failure of the tug operator and wing walker of the other airplane to maintain clearance with this aircraft during the pushback process in dark night. Also causal was the ramp controller's misinterpretation of the other airplane's gate location and her…NTSB ERA09FA092Accident · 1 fatalField investigationFinal reportCessna 172S · Goodland, FLThe pilot's failure to maintain aircraft control due to spatial disorientation. Contributing to the accident was the night light conditions.NTSB WPR09LA050Accident · 1 fatalLimited investigationFinal reportBeech A36 · Coalinga, CAThe loss of engine power while in climb to cruise flight for undetermined reasons.NTSB CEN09CA071Accident · No injuriesData collectionFinal reportCessna 150F · Trenton, TXThe pilot's improper flare during landing, resulting in a hard landing. Contributing to the accident were the night light conditions and the instructor's inadequate supervision of the pilot.NTSB ERA09LA064Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Groton, CTThe student pilot’s failure to maintain a proper descent profile to avoid trees during the night visual approach and the flight instructor’s inadequate oversight.NTSB ERA09FA060Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Smithfield, RIThe pilot's improper descent below the published minimum descent altitude during the approach, which resulted in controlled flight into terrain.NTSB CEN09LA061Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Downers Grove, ILThe pilot's failure to maintain a proper glidepath while on final approach in night conditions, due to his impairment from recent use of alcohol, cocaine, and over-the-counter and prescription medications.NTSB DCA09FA011Accident · Minor injuriesField investigationFinal reportBombardier CL-600-2B19 · Detroit, MIThe lack of vigilance on the part of the ramp agent driving the baggage tug. Contributing factors include the night conditions, and low visibility due to fog and rain.NTSB ERA09FA036Accident · 1 fatalField investigationFinal reportRobinson R-44 · Gallatin, TNThe pilot's inadvertent descent into water as a result of the dark night and limited outside visual references.NTSB WPR09FA027Accident · 2 fatalField investigationFinal reportCessna P206 · Estacada, ORThe pilot's failure to maintain clearance from trees while on approach to land at night. Contributing to the accident was the electrical system failure and the pilot's diverted attention.NTSB ERA09FA027Accident · 1 fatalField investigationFinal reportPiper PA-30 · Selmer, TNThe pilot's failure to avoid terrain during night instrument meteorological conditions.NTSB WPR09CA006Accident · No injuriesData collectionFinal reportCessna 210-5(205) · Payson, UTThe total loss of engine power during cruise flight for undetermined reasons. Contributing to the accident were a dark night and a cherry orchard at the location where the pilot executed the forced landing.NTSB ERA09CA007Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Chester, CTThe pilot’s failure to obtain the proper touchdown point while landing. Contributing to the accident were the pilot’s inexperience landing at the airport, night conditions, and non-standard runway lighting.NTSB NYC08FA324Accident · 1 fatalField investigationFinal reportCessna 402 · Vineyard Haven, MAA loss of aircraft control due to spatial disorientation.NTSB CHI08FA293Accident · 2 fatalField investigationFinal reportRobinson R44 II · Kenosha, WIThe pilots failure to maintain clearance from terrain resulting in an in-flight collision with a house. Contributing to the accident was the night instrument meteorological conditions (IMC) and the pilot's lack of experience of flying in IMC.NTSB CHI08CA285Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Lakeville, MNThe pilot's lack of clearance from the approach lights and the distraction of those bright approach lights during his night approach.NTSB SEA08LA191Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Burbank, CAThe pilot's improper preflight and in-flight planning, which resulted in fuel exhaustion. Contributing to the accident were the pilot's loss of situational awareness while conducting the normal and emergency checklists during his turn from base to final…NTSB CHI08CA263Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Greenville, MIThe deer that ran onto the runway contacting the airplane. A factor associated with the accident was the dark night conditions.NTSB LAX08FA261Accident · 1 fatalField investigationFinal reportCessna 172S · Incline Village, NVThe pilot's decision to initiate a flight for which he was neither approved nor qualified and his failure to maintain terrain clearance during the flight. Contributing to the accident were the dark night, the mountainous terrain, and the pilot's medical…NTSB CHI08CA235Accident · Minor injuriesData collectionFinal reportCessna 150L · Watertown, SDThe pilot's failure to maintain altitude/clearance from terrain during cruise. Contributing to the accident was the night, the haze, and the tall vegetation.NTSB LAX08CA229Accident · No injuriesData collectionFinal reportBell 47G-3B-1 · Shafter, CAThe pilot's failure to maintain adequate altitude while maneuvering. Contributing factors were the failure of the helicopter's lights during the night flight and the effect of that failure on the pilot's visual perception.NTSB LAX08LA213Accident · 2 fatalLimited investigationFinal reportSchweizer 269 C-1 · Sunol, CAThe pilots' failure to maintain adequate clearance from transmission wires during cruise flight. Contributing to the accident were the dark night and low fog.NTSB LAX08LA198Accident · Serious injuriesLimited investigationFinal reportEurocopter AS 350 B3 · Ash Fork, AZThe pilot's spatial disorientation resulting in his failure to detect and compensate for an unintentional descent during a go-around. Contributing to the accident were the pilot's inadequate choice of landing approach, reduced visibility from brownout…NTSB DEN08CA117Accident · No injuriesData collectionFinal reportCessna T182T · Omaha, NEThe pilot's improper use of the elevator trim resulting in a nose low/hard landing.NTSB DEN08FA101Accident · 4 fatalField investigationFinal reportBell 407 · Huntsville, TXThe pilot's failure to identify and arrest the helicopter's descent, which resulted in its impact with terrain. Contributing to the accident was the limited outside visual reference due to the dark night conditions.NTSB MIA08FA115Accident · 3 fatalField investigationFinal reportCessna T206H · Cedar Key, FLThe pilot’s failure to maintain clearance from the water during a dark night approach to a coastal airport.NTSB NYC08CA200Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Wildwood, NJThe pilot's failure to maintain clearance from trees during approach. Contributing to the accident were the dark night conditions.NTSB CHI08CA131Accident · Minor injuriesData collectionFinal reportKuntz Kuntz 2000 GTS EFI · Dickinson, NDThe pilot's inadequate preflight weather evaluation and the unsuitable terrain encountered during the precautionary landing at night. Contributing to the accident was the pilot becoming lost after inadvertently encountering fog while en route, the night…NTSB LAX08LA127Accident · No injuriesLimited investigationFinal reportCessna 182H · Prescott, AZA loss of engine power from fuel starvation due to the pilot's mismanagement of the fuel system and failure to select a tank containing fuel.NTSB CHI08LA101Accident · 2 fatalLimited investigationFinal reportCessna 172K · Roseglen, NDThe pilot failed to maintain obstacle clearance from the TV antenna during a low altitude maneuver. Contributing factors were the antenna, the night conditions, and pilot impairment due to alcohol.NTSB SEA08FA108Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Big Bear City, CAThe pilot's failure to maintain altitude/clearance from mountainous terrain. Contributing to the accident were the mountainous terrain, the dark night condition, the turbulent wind condition, and the low clouds.NTSB DFW08TA092Accident · No injuriesFinal reportRobinson R44 · Topeka, KSA malfunctioning magneto, resulting in a high engine rpm and low rotor warning indications. A contributing factor was the impact with a light pole, during the precautionary landing.NTSB LAX08FA092Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Benson, AZThe pilot's misjudged speed and altitude during approach that led to a long landing and his subsequent failure to maintain control during an attempted go-around. Contributing to the accident were the dark night, the pilot's low total night flight experience,…NTSB SEA08LA095Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Bridger, MTThe pilot failed to maintain situational awareness during the flight. Contributing to the accident were the dark night, the pilot's failure to follow approved navigational procedures for the flight, and the pilot's over reliance on the avionics in the…NTSB MIA08FA080Accident · 2 fatalField investigationFinal reportCessna 182B · Wildwood, FLThe noninstrument rated pilot's failure to maintain terrain clearance at night in marginal visual flight conditions. Contributing to the accident was the dark night, and low cloud ceilings.NTSB NYC08FA138Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Front Royal, VAThe pilot's failure to maintain clearance from rising mountainous terrain, and his failure to turn toward his assigned course during initial climb. Contributing to the accident were the low ceiling, reduced visibility, dark night conditions, and rising…NTSB SEA08LA073Accident · Minor injuriesLimited investigationFinal reportPiper PA-44-180 · Piru, CAThe loss of engine power for undetermined reasons. Contributing factors were the lack of suitable terrain for the forced landing and dark night conditions.NTSB CHI08CA078Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Cahokia, ILThe flight instructor's failure to correct for proper runway alignment during final approach and his failure to maintain aircraft control during his subsequent go-around. Contributing to the accident was the dual-student's failure to properly align with the…NTSB DFW08FA062Accident · 3 fatalField investigationFinal reportEurocopter France AS350B2 · S. Padre Island, TXThe pilot's failure to maintain aircraft control resulting in the helicopter impacting the water. Factors contributing to the accident were the pilot's inadvertent flight into instrument meteorological conditions, the low ceiling, dark night conditions, and…NTSB LAX08CA054Accident · No injuriesData collectionFinal reportBell OH-58A · Brawley, CAThe pilot's failure to maintain clearance from obstacles. A factor in the accident was the dark night conditions.NTSB LAX08FA052Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Los Angeles, CAThe pilot's failure to maintain an adequate obstacle clearance altitude from transmission wires during cruise flight. Contributing to the accident was the dark night conditions.NTSB DFW08FA056Accident · 1 fatalField investigationFinal reportAero Commander 500B · Tulsa, OKThe pilot's loss of control due to spatial disorientation and the pilot exceeding the design/stress limits of the aircraft. Factors contributing to the accident were the pilot's reported gyro problem, the dark night conditions , and prevailing instrument…NTSB CHI08FA066Accident · 1 fatalField investigationFinal reportHawker Beechcraft 58 · Cleveland, OHThe pilot experienced spatial disorientation during the inital climb causing him to lose control of the airplane.NTSB SEA08LA061Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2C10 · San Francisco, CAThe company tug operator's failure to maintain clearance with another aircraft during the pushback process. Also causal was the ground controller's failure to alert the pilot of the other aircraft and tug operator of this airplane of the simultaneous pushback…NTSB SEA08FA062Accident · 1 fatalField investigationFinal reportHawker Beechcraft 1900C · Lihue, HIThe pilot's spatial disorientation and loss of situational awareness. Contributing to the accident were the dark night and the task requirements of simultaneously monitoring the cockpit instruments and the other airplane.NTSB DFW08LA055Accident · 1 fatalLimited investigationFinal reportPilatus PC-12/45 · Oklahoma City, OKThe line technician's failure to remain clear of the propeller. A factor was the night lighting conditions.