NTSB investigations
4,605 cases where the first occurrence was “In flight collision with object”.
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220) 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220) 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 FTW96LA170Accident · No injuriesLimited investigationFinal reportExplorer Post 51 AA Cubette · Dell City, TXthe pilot's failure to maintain obstacle clearance during a go-around. Factors were the gusty wind and the pilot's inadequate compensation for the wind.NTSB CHI96LA130Accident · 3 fatalLimited investigationFinal reportCessna 177B · Perry, MOthe pilot's impairment of judgment and performance due to alcohol, and his failure to maintain altitude/clearance from the power transmission wires. Darkness, restricting the pilot's ability to see-and-avoid the transmission line, was a related factor.NTSB FTW96LA164Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Boerne, TXThe pilot's improper planning/decision, and his failure to use all of available runway. Factors relating to the accident were: the pilot's overconfidence in the ability of the airplane, the high density altitude, the tailwind, and trees at the departure end…NTSB FTW96LA163Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Midlothain, TXthe pilot's failure to maintain obstacle clearance.NTSB CHI96LA124Accident · No injuriesLimited investigationFinal reportCessna 210 · Marshall, MIA deer that wandered onto the runway. Darkness was a related factor.NTSB SEA96LA070Accident · Minor injuriesLimited investigationFinal reportBell 206B · La Grande, ORthe pilot's failure to maintain clearance with trees after pulling up from an aerial application spray run.NTSB IAD96FA050Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Marion, VAthe pilot's failure to maintain adequate altitude/clearance during the instrument approach (FAF/Outer Marker to Threshold IFR), which resulted in the in-flight collision with trees. A related factor was the foggy weather conditions.NTSB FTW96LA150Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Salado, TXthe pilot's failure to maintain altitude/clearance from the power line.NTSB CHI96LA105Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Camp Lake, WIFailure of the pilot to maintain clearance from trees that were located beside the runway.NTSB NYC96LA072Accident · No injuriesLimited investigationFinal reportCessna 182L · Weedsport, NYthe pilot's decision to takeoff on a closed snow-covered runway, and his inadequate compensation for a crosswind. A factor in the accident was the pilot's lack of recent flying experience.NTSB SEA96LA065Accident · No injuriesLimited investigationFinal reportNicholson Thorp T18CWS · Grantsville, UTthe pilot's failure to maintain clearance from a powerline. A transmission wire and an oil pressure reading of zero were factors.NTSB LAX96FA120Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Elk Grove, CAthe pilot's failure to see and avoid the obstruction.NTSB FTW96LA128Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Iowa, LAthe pilot's selection of the wrong runway for landing, his delay in initiating a go-around (aborted landing), and his failure to maintain clearance from the transmission lines. Factors relating to the accident were: the pilot's improper weather evaluation,…NTSB CHI96FA095Accident · 1 fatalField investigationFinal reportCessna 310 · Portland, INthe pilot's failure to maintain an altitude adequate for terrain clearance. A factor was the weather.NTSB CHI96FA091Accident · 2 fatalField investigationFinal reportHughes 369D · Dweese, NEthe pilot's improper in-flight planning and decision, and his lack of total experience in the type of operation. A factor was the crosswind.NTSB MIA96LA081Accident · No injuriesLimited investigationFinal reportChristen Industries A-1 · Miami, FLFailure of the pilot to maintain proper runway alignment during a go-around, resulting in a collision with trees beside the runway. The crosswind was a related factor.NTSB NYC96FA061Accident · 1 fatalField investigationFinal reportCessna P206A · Forks Township, PAThe pilot's failure to maintain a proper altitude, and insufficient obstruction lighting requirements established by the Federal Aviation Administration and the Federal Communications Commission.NTSB CHI96FA088Accident · 1 fatalField investigationFinal reportBell 206B-III · Pellston, MIflight into known adverse weather conditions (fog) at too low an altitude by the pilot. Factors associated with this accident were inadequate preflight planning and an improper inflight decision by the pilot when he chose to continue flight into the fog…NTSB LAX96FA106Accident · 4 fatalField investigationFinal reportConvair C-131E · Saint Johns, AZinadequate preflight planning and preparation by the first pilot (PIC), his failure to ensure the aircraft was properly loaded within limitations, his failure to use proper flaps for takeoff, his failure to use ADI assisted takeoff, and his resultant failure…NTSB SEA96LA047Accident · No injuriesLimited investigationFinal reportCessna 172M · Mcleary, WAfailure of the pilot to maintain sufficient altitude/clearance from mountainous/wooded terrain. Factors relating to the accident were: the terrain and downdraft conditions.NTSB BFO96FA039Accident · 2 fatalField investigationFinal reportCessna R172K · Highland Hills, OHthe pilot's continued VFR flight into instrument meteorological conditions at a low altitude with known obstacles in the area.NTSB ATL96FA036Accident · 2 fatalField investigationFinal reportPiper PA-46-350P · Peachtree City, GAThe pilot's failure to follow the published instrument approach procedure. The fog was a factor.NTSB FTW96LA096Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Mandeville, LAthe pilot's impairment of judgment and performance due to alcohol, his resultant improper planning/decision, and his failure to maintain sufficient altitude/clearance from obstructions (power lines) at night.NTSB SEA96FA040Accident · 3 fatalField investigationFinal reportCessna 401A · Spokane, WAfailure of the pilot to follow proper IFR procedures, by failing to maintain proper alignment with the localizer course during the ILS approach and/or by failing to follow the proper missed approach procedure. Factors relating to the accident were: darkness;…NTSB SEA96LA041Accident · No injuriesLimited investigationFinal reportCessna 172K · Park City, MTInadequate visual lookout by the pilot, and his failure to maintain sufficient altitude/clearance from the transmission line.NTSB ATL96FA029Accident · 1 fatalField investigationFinal reportCessna 210H · Columbia, TNfailure of the pilot to follow procedures/directives by flying in instrument meteorological conditions (IMC) without proper training/certification; and his failure (or inability) to follow proper IFR procedures and maintain proper altitude during an…NTSB MIA96FA051Accident · 2 fatalField investigationFinal reportCessna 550 · East Naples, FLThe pilot's disregard for the MDA for a specific segment of the VOR/DME approach which resulted in the inflight collision with a guy wire of an antenna and separation of 8.5 feet of the left wing.NTSB MIA96LA050Accident · 2 fatalLimited investigationFinal reportNanchang China CJ6A · Planterville, SCfailure of the pilot to maintain sufficient altitude or clearance from trees.NTSB SEA96LA035Accident · No injuriesLimited investigationFinal reportCessna 172N · Pacific City, ORThe pilot's delay in aborting the landing, which resulted in his failure to clear the perimeter fence. Factors relating to the accident were: the tailwind, and the pilot's failure to land at the proper touchdown point.NTSB FTW96LA083Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Waller, TXthe pilot's failure to maintain obstacle clearance.NTSB ATL96LA024Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Monroe, NCThe pilot's inadequate planning and failure to follow operating procedures resulted in his descent below the decision height while on final approach.NTSB MIA96LA041Accident · No injuriesLimited investigationFinal reportMckibben GN-1 Aircamper · Mayhew, MSThe pilot's improper planning/decision, and failure to verify the airplane's performance data. The airplane's lack of climb capability with the newly manufactured propeller was a related factor.NTSB FTW96FA063Accident · 2 fatalField investigationFinal reportBalloon Works Firefly 7-15 · Oklahoma City, OKThe pilot's failure to maintain obstacle clearance during low altitude straight and level flight.NTSB LAX96FA067Accident · 1 fatalField investigationFinal reportCessna 340A · San Dimas, CAthe pilot's impairment of judgment and performance due to drugs, his resultant improper planning/decision, his failure to follow proper IFR procedures, and his failure to maintain proper altitude during a missed approach. Factors relating to the accident…NTSB FTW96FA060Accident · 1 fatalField investigationFinal reportMcDonnell Douglas 369E · Thibodaux, LAfailure of the pilot to maintain clearance from the power line and utility pole. The gusty/crosswind (weather) condition was a related factor.NTSB ATL96FA018Accident · 2 fatalField investigationFinal reportNavion D · Canton, GAThe pilot's impairment of judgement and performance due to drugs which led to his overconfidence of personal ability and continued flight into known adverse weather conditions. The weather conditions and dark night were factors.NTSB ATL96FA017Accident · 2 fatalField investigationFinal reportCessna 402A · Avon Park, FLThe failure of the pilot to maintain the proper climb rate and direction of flight following takeoff, resulting in a collision with obstacles. The reason for the loss of control and subsequent unusual attitude ground impact was not determined.NTSB CHI96FA045Accident · 1 fatalField investigationFinal reportPiper PA-28 · Friedens, PAthe pilot's failure to follow instrument approach procedures, by not maintaining proper altitude and by descending below the minimum descent altitude. Factors relating to the accident were: the air traffic controller's failure to issue a proper clearance, the…NTSB FTW96FA058Accident · 3 fatalField investigationFinal reportCessna 172P · Hallett, OKThe flight instructor's intentional low altitude flight maneuver. Factors were the static wire and the bright night condition.NTSB LAX96LA066Accident · No injuriesLimited investigationFinal reportBoeing B75-N1 · Chino, CAthe pilot's failure to see and avoid light poles. A poorly planned approach was a factor.NTSB NYC96FA192Accident · 1 fatalField investigationFinal reportCessna 414 · Marlinton, WVThe pilot's continued VFR flight into obscured, rising mountainous terrain, and his failure to climb the airplane as conditions worsened. Factors included the rising terrain and the weather obscuration.NTSB MIA96LA026Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Fort Lauderdale, FLThe pilots failure to follow the visual approach slope indicator and maintain a proper glidepath during approach. Contributing to the accident was pilot fatigue.NTSB FTW96FA048Accident · 1 fatalField investigationFinal reportBeech A35 · Hudson, COThe pilot's failure to maintain clearance. A factor was improper in-flight planning.NTSB LAX96FA050Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Fullerton, CAthe pilot-in-command's failure to follow IFR procedures in that he descended below the minimum descent altitude and failed to execute a missed approach. Contributing to the accident was the pilot-in-command's self-induced pressure to get to work.NTSB LAX96LA048Accident · 1 fatalLimited investigationFinal reportCessna 150H · Imperial, CAthe student pilot's misreading of the altimeter while in the traffic pattern, which put the aircraft in dangerous proximity to the ground and obstructions. A factor in the accident was the pilot's inability to see the power pole due to sun glare as the…NTSB FTW96LA041Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-201T · Keller, TXthe inadequate visual lookout by the driver of the vehicle resulting in his obstructing the runway.NTSB SEA96LA014Accident · No injuriesLimited investigationFinal reportCessna 180J · Stanley, IDthe pilot's failure to maintain clearance with obstacles at the end of the takeoff area. His failure to attain sufficient altitude to clear the obstacles was a factor.NTSB LAX96LA040Accident · 2 fatalLimited investigationFinal reportCessna 180 · Placerville, CAthe pilot's intentional buzzing, his failure to identify an obstruction (inadequate visual lookout), and his failure to maintain adequate altitude/clearance from the obstruction (utility pole). Factors relating to the accident were: dust generated by farm…NTSB NYC96IA022Incident · No injuriesIncident investigationFinal reportBoeing 737-3B7 · Portland, MEa bird strike during takeoff, which resulted in failure of several fan blades in the right engine and a partial loss of engine power.NTSB LAX96LA027Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-150 · Mecca, CAthe pilot/applicant's failure to maintain a glide path angle sufficient to maintain adequate clearance from all obstructions, and the examiner's inadequate supervision of the flight.