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 ERA13FA115Accident · 1 fatalField investigationFinal reportPilatus PC-12/45 · Burlington, NCThe pilot's failure to maintain airplane control due to spatial disorientation during the initial climb after takeoff in night instrument flight rules conditions.NTSB CEN13FA135Accident · 1 fatalField investigationFinal reportCessna 208B · Pellston, MIThe pilot's inadvertent controlled descent into terrain due to spatial disorientation. Contributing to the accident was lack of visual reference due to night conditions.NTSB WPR13FA080Accident · 1 fatalField investigationFinal reportBell 206 · Delano, CAThe pilot's failure to maintain helicopter control due to spatial disorientation while maneuvering in low visibility, dark night conditions.NTSB WPR13FA073Accident · 2 fatalField investigationFinal reportBeech B100 · Libby, MTThe noncertificated pilot’s failure to maintain clearance from terrain while maneuvering to land in dark night conditions likely due to his geographic disorientation (lost). Contributing to the accident was the pilot’s improper decision to fly at night with a…NTSB WPR13FA072Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Payson, AZThe airplane’s inadvertent encounter, in night instrument meteorological conditions, with unforecast strong up- and downdrafts and possibly severe airframe icing conditions (which likely included supercooled large droplets that the airplane was not…NTSB ERA13FA083Accident · 1 fatalField investigationFinal reportDiamond Aircraft Ind DA 40 · Lake Park, GAThe noninstrument-rated pilot’s improper decision to depart in dark, night marginal visual flight rules conditions, which resulted in his spatial disorientation and subsequent loss of airplane control.NTSB CEN13LA088Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Rochester, MNThe pilot’s spatial disorientation during the instrument approach in night, instrument meteorological conditions, which resulted in the airplane descending below decision height and impacting terrain outside the lateral limits of the localizer. Contributing…NTSB WPR13LA062Accident · 1 fatalLimited investigationFinal reportCessna 172S · Kahului, HIThe noninstrument-rated pilot’s spatial disorientation and subsequent failure to maintain airplane control while operating over water in dark night conditions with reduced visibility due to rain in the area.NTSB CEN13FA085Accident · 4 fatalField investigationFinal reportPiper PA 46-350P · Greensburg, INThe pilot's failure to maintain airplane control while maneuvering in night instrument meteorological conditions due to spatial disorientation.NTSB ERA13FA064Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Canton, CTThe pilot’s failure to maintain clearance from terrain while performing a night visual approach to an airport. Contributing to the accident were the dark night and the pilot's lack of recent experience flying at night.NTSB ERA13FA062Accident · 1 fatalField investigationFinal reportCessna 172K · Savannah, GAThe pilot's failure to maintain airplane control while operating in night, instrument meteorological conditions, due to spatial disorientation.NTSB WPR13FA037Accident · 2 fatalField investigationFinal reportCessna 421C · Shaver Lake, CAThe pilot's failure to regain airplane control following a sudden rapid descent during cruise, which resulted in an in-flight breakup. Contributing to the accident was the pilot's decision to make the flight with a failed vacuum pump, particularly at high…NTSB ERA13FA026Accident · 1 fatalField investigationFinal reportAerospatiale AS 355 · Erwinna, PAThe pilot’s decision to depart under visual flight rules in dark night instrument meteorological conditions, which resulted in subsequent spatial disorientation, uncontrolled descent, and impact with trees and terrain.NTSB WPR13FA010Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Marana, AZThe pilot’s flight in dark night conditions with no visual reference and his subsequent spatial disorientation.NTSB CEN13FA012Accident · 1 fatalField investigationFinal reportCessna 172R · Simpson, LAThe pilot’s loss of airplane control while maneuvering between areas of precipitation during a night cross-country flight.NTSB ERA13LA019Accident · 3 fatalLimited investigationFinal reportPiper PA-23-250 · Charlotte AmalieThe pilot's attempted visual flight rules (VFR) flight into marginal VFR conditions on a dark night over water and his failure to maintain sufficient altitude, which resulted in the airplane’s controlled flight into water. Contributing to the accident was the…NTSB ERA13FA014Accident · 2 fatalField investigationFinal reportBell 407 · Coolbaugh Township, PAThe pilot’s decision to continue visual flight rules flight into instrument meteorological conditions due to self-imposed pressure to complete the trip, which resulted in impact with trees and terrain.NTSB WPR13FA001Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Beatty, NVThe pilot’s inadequate flight planning, subsequent loss of situational awareness, and failure to maintain clearance from the power lines during a dark night approach to a closed, unlit runway.NTSB CEN12LA645Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Branson, MOThe pilot's failure to maintain airplane control during an attempted go-around in dark night conditions.NTSB CEN12FA633Accident · 5 fatalField investigationFinal reportCirrus Design SR22 · Willard, MOThe pilot's loss of airplane control as a result of spatial disorientation experienced in night instrument meteorological conditions.NTSB WPR12FA369Accident · 5 fatalField investigationFinal reportPiper PA-32-301T · South Lake Tahoe, CAA partial loss of engine power for reasons that could not be determined because examinations revealed no evidence of mechanical anomalies with the airframe or engine that would have precluded normal operation and the pilots’ decision to continue the departure…NTSB ERA12FA527Accident · 1 fatalField investigationFinal reportBell 407 · Abingdon, VAThe pilot's improper decision to make a low-level departure over water in dark night conditions without lights, which resulted in controlled flight into the water. Contributing to the accident was the pilot's likely spatial disorientation due to a vestibular…NTSB CEN12IA518Incident · No injuriesIncident investigationFinal reportBell 407 · San Antonio, TXThe pilot’s failure to maintain clearance from a tower guy wire during the approach to a helipad at night.NTSB WPR12FA230Accident · 4 fatalField investigationFinal reportCessna 172S · St. George, UTThe pilot's failure to maintain adequate airspeed during an aggressive pitch-up maneuver, which resulted in a low-altitude aerodynamic stall shortly after takeoff. Contributing to the accident was the pilot's impairment from alcohol consumption and an…NTSB WPR12FA139Accident · 1 fatalField investigationFinal reportBeech B36 · Panoche, CAThe pilot’s lack of situational awareness regarding the surrounding terrain while descending during dark night conditions, which resulted in controlled flight into terrain.NTSB ERA12FA193Accident · 2 fatalField investigationFinal reportCessna 172S · Key West, FLThe non-night-qualified pilot's improper decision to depart in dark night visual meteorological conditions, which resulted in his subsequent spatial disorientation, loss of control, and impact with water.NTSB ANC12CA023Accident · No injuriesData collectionFinal reportCessna 182A · Anchorage, AKThe pilot's inadvertent landing on a frozen lake in dark night conditions.NTSB WPR12FA105Accident · 3 fatalField investigationFinal reportCessna 172S · North Bend, WAThe pilot's physical impairment due to alcohol, which adversely affected his ability to operate the airplane and to maintain clearance from mountainous terrain while operating in dark night conditions.NTSB ERA12CA185Accident · No injuriesData collectionFinal reportCessna 172S · Eufaula, ALAn inadvertent collision with a deer during a night landing.NTSB ERA12FA151Accident · 1 fatalField investigationFinal reportCessna 150G · Quincy, FLThe non-instrument-rated pilot’s spatial disorientation in night instrument meteorological conditions, which resulted in his inability to maintain controlled flight. Contributing to the accident was the pilot’s improper decision to take off in deteriorating…NTSB CEN12LA125Accident · Serious injuriesLimited investigationFinal reportAviat A-1C-180 · McKinney, TXThe passenger's inadvertent contact with a rotating propeller after exiting the parked airplane. Contributing to the accident were the dark night conditions and the deplaning of the passenger while the propeller was turning.NTSB CEN12FA097Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · St. Ignace, MIThe pilot’s decision to initiate visual flight in instrument meteorological conditions and subsequent failure to maintain adequate altitude.NTSB ERA12CA094Accident · No injuriesData collectionFinal reportNuse George F1H Rocket · Caroleen, NCThe pilot did not maintain directional control during takeoff at night due to his distraction with a dropped flashlight, and he delayed his decision to abort the takeoff.NTSB WPR12LA048Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Hailey, IDThe pilot's failure to maintain course heading and terrain clearance because he was distracted by efforts to engage the autopilot shortly after takeoff on a dark night in mountainous terrain.NTSB WPR12MA046Accident · 6 fatalMajor investigationFinal reportRockwell 690 · Apache Junction, AZThe pilot's failure to maintain a safe ground track and altitude combination for the moonless night visual flight rules flight, which resulted in controlled flight into terrain. Contributing to the accident were the pilot's complacency and lack of situational…NTSB ERA12CA080Accident · Serious injuriesData collectionFinal reportBeech V35 · Lusby, MDThe pilot did not maintain clearance from trees during a night approach.NTSB CEN12LA060Accident · No injuriesLimited investigationFinal reportCessna 180 · Eau Claire, WIThe pilot’s disorientation during a night flight, which resulted in an off-airport landing, and his inadequate directional control during the landing roll. Contributing to the accident was the loss of the airplane’s electrical system power.NTSB CEN12CA065Accident · No injuriesData collectionFinal reportCessna 182J · Alexandria, MNThe pilot's failure to maintain directional control during the night landing.NTSB WPR12FA031Accident · 3 fatalField investigationFinal reportCessna 182Q · Lake Havasu City, AZThe pilot's continued cruise flight into cloudy conditions at night, which resulted in a loss of airplane control due to spatial disorientation.NTSB ANC12LA002Accident · Minor injuriesLimited investigationFinal reportCessna 207A · Kwigillingok, AKThe pilot's failure to abort the takeoff when he realized the airplane could not attain sufficient takeoff and climb performance and his improper decision to depart from an airport where night operations were prohibited.NTSB WPR12FA021Accident · 1 fatalField investigationFinal reportCessna 182R · Lexington, ORThe pilot’s failure to maintain situational awareness and terrain clearance on a dark night during the approach to landing.NTSB CEN12CA017Accident · No injuriesData collectionFinal reportLearjet 60 · Lafayette, INThe pilot's decision to taxi the airplane across an unpaved area after the nosewheel inadvertently departed the ramp pavement.NTSB WPR11FA448Accident · 2 fatalField investigationFinal reportCessna 182H · Stanley, IDThe pilot's failure to maintain airplane control due to spatial disorientation while executing a turn to reverse his course in dark night and low-visibility conditions. Contributing to the accident was the pilot's decision to initiate the flight into an area…NTSB CEN11FA557Accident · 3 fatalField investigationFinal reportPiper PA-23 · Millersburg, OHThe pilot’s failure to maintain clearance with terrain during the landing approach in night conditions and fog. Contributing to the accident was the pilot’s inadequate preflight planning.NTSB WPR11FA354Accident · 2 fatalField investigationFinal reportCirrus SR20 · Fredonia, AZThe non-instrument-rated pilots’ loss of situational awareness during a dark night flight over a remote area, which resulted in their failure to maintain an altitude sufficient to ensure adequate terrain clearnance. Contributing to the accident was the…NTSB ERA11FA412Accident · 2 fatalField investigationFinal reportCessna 182S · Erwin, NCThe pilot’s loss of control due to spatial disorientation while maneuvering in dark night conditions.NTSB OPS11IA686Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-83(MD-83) · Apache Junction, AZThe failure of the pilots of both airplanes to see and avoid each other and to maneuver as advised by the air traffic controller in time to prevent the conflict that resulted in the reported near midair collision.NTSB ERA11FA287Accident · 1 fatalField investigationFinal reportCzech Sport Piper Sport · Spring Hill, FLThe pilot's inadvertent application of control inputs that resulted in rapid, right-rolling, negative g-forces during night cruise flight and his subsequent ejection from the airplane. Contributing to the accident was the pilot's decision to fly at night in…NTSB ERA11FA258Accident · 1 fatalField investigationFinal reportCessna 210D · Altavista, VAThe pilot’s loss of airplane control due to spatial disorientation. Contributing to the accident was the pilot’s lack of experience in actual night instrument conditions.NTSB ERA11FA232Accident · 3 fatalField investigationFinal reportCessna 310R · McComb, MSThe pilot's impairment due to alcohol ingestion and his failure to maintain airplane control during an approach at night in instrument meteorological conditions.