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 NYC90DGM01Accident · Serious injuriesFinal reportAir Tractor AT-400 · Tyrone, PAThe pilot's failure to maintain adequate clearance from obstructions during low level aerial application operations. The pilot's inadequate visual lookout was a factor.NTSB SEA90LA076Accident · 1 fatalLimited investigationFinal reportPiper PA-18-125 · Rogerson, IDThe pilot's intentional flight below safe altitudes while engaged in low-altitude 'buzzing' activities.NTSB MKC90LA103Accident · No injuriesLimited investigationFinal reportPiper PA-25-235C · Hardin, MOPoor in-flight planning/decision and inadequate visual outlook by the pilot in command.NTSB ATL90FA109Accident · 1 fatalField investigationFinal reportCessna 150L · Stockbridge, GAThe pilot's failure to maintain the proper clearance from objects on the ground.NTSB LAX90LA162Accident · No injuriesLimited investigationFinal reportHughes 369C · Kahului, HIThe pilots failure to ensure that adequate room existed to position the helicopter on the landing platform. Contributing to the accident was the failure of ground personnel to ensure that hazards to the landing helicopter were clear of the landing area.NTSB ATL90FA108Accident · 2 fatalField investigationFinal reportGovernment Aircraft Fact N24A · Wilmington, NCThe pilot's failure to maintain sufficient altitude during a circling maneuver for landing. Factors related to the accident were: weather conditions below minimums for a circling approach, and failure of the pilot to follow IFR procedures.NTSB MIA90LA113Accident · No injuriesLimited investigationFinal reportStinson 108 · Bushnell, FLFailure of the instrucor pilot (CFI) to assure that a timely go-around was made. The obstruction (transmission line) was a related factor.NTSB FTW90LA104Accident · No injuriesLimited investigationFinal reportRyan Navion A · Denison, TXPilot's attempted takeoff with conditions in excess of the airplane's performance capabilities. Contributing to the accident was the high density altitude and the uphill runway.NTSB CHI90FA118Accident · 1 fatalField investigationFinal reportSikorsky S-58F · Southfield, MIA loss of control due to physical incapacitation for unknown reason(s).NTSB DEN90FA100Accident · 4 fatalField investigationFinal reportPiper PA31-325 · Cedar City, UTThe pilot failed to maintain a minimum safe altitude over mountainous terrain during a night VFR approach for landing.NTSB MKC90LA093Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Eden Prairie, MNCollision with animal, factors in the accident were light condition, dusk, and remedial action was not possible.NTSB NYC90LA090Accident · No injuriesLimited investigationFinal reportEnstrom 280 · Thornton, PAFailure to attain a proper climb rate after takeoff from a confined area. Factors include gusty winds and high obstructions.NTSB FTW90LA099Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28A · Danbury, TXPilot in command's failure to see and avoid wires during the final stage of an approach to a confined area. A contributing factor to the accident was the pilot's disregard of the operator's instructions after he landed the first time.NTSB MKC90LA092Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Eldora, IAImproper planning/decision by the pilot, and his failure to maintain clearance from obstructions during the approach to land. Factors related to the accident were: the aircraft's low fuel level, darkness, the pilot's selection of the wrong airport/runway, the…NTSB SEA90LA069Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Minden, NVThe pilot's poor inflight planning and decision.NTSB SEA90FA065Accident · Serious injuriesField investigationFinal reportCessna 172M · Incline Village, NVImproper in-flight planning/decision by the instructor pilot (CFI), and his failure to maintain adequate altitude and clearance from obstructions. Factors related to the accident were: mountainous terrain, high density altitude, and the trees (obstructions).NTSB SEA90FA064Accident · 3 fatalField investigationFinal reportCessna 182M · North Bend, ORThe pilot did not follow the published IFR procedure.NTSB LAX90DVG04Accident · 1 fatalFinal reportGrumman G-164B · Esparto, CAThe pilot misjudged the airplane's clearance with the transmission wires.NTSB BFO90LA033Accident · No injuriesLimited investigationFinal reportCessna 170B · Winchester, VAThe pilot's failure to assure that the airplane would clear the fence after takeoff.NTSB ANC90LA048Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kodiak, AKThe pilot failed to maintain proper obstacle clearance altitude during his final approach.NTSB LAX90LA130Accident · No injuriesLimited investigationFinal reportBurkhart Grob 103 · Byron, CAThe pilot's inadequate visual lookout for objects along the landing runway.NTSB FTW90GA088Accident · 1 fatalFinal reportCessna 337G · Notrees, TXThe pilot's decision to continue VFR flight into known IMC.NTSB LAX90FA123Accident · 1 fatalField investigationFinal reportCessna 172N · Buena Park, CAThe pilot not maintaining the prescribed minimum descent altitude during an instrument approach.NTSB ANC90LA043Accident · No injuriesLimited investigationFinal reportCessna 170B · Sulatna Cross, AKThe pilot failed to adequately assess the existing snow conditions and surrounding terrain (preflight planning) prior to takeoff. Contributing factors were: the lighting conditions, the pilot's over confidence in the airplane's performance capabilities and…NTSB ATL90FA073Accident · No injuriesField investigationFinal reportMBB BO-105S · Benton, ALThe pilot-in-command's inadequate visual lookout. The incorrect wire survey given by the highway patrol personnel was a related factor.NTSB CHI90LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Wonder Lake, ILThe pilot's inadequate compensation for wind conditions, and his faiiure to maintain proper altitude on final approach to land. Factors related to the accident were: the trees & snowbank.NTSB MKC90FA057Accident · 1 fatalField investigationFinal reportBeech B36TC · Inver Grove Hgt, MNPremature lift-off by the pilot, while taking off with a heavy gross weight in unfavorable winds, and the pilot's failure to attain/maintain adequate airspeed, which resulted in an inadvertent stall/mush.NTSB DEN90FA063Accident · 1 fatalField investigationFinal reportPiper PA-12-150 · Milliken, COThe pilot's poor judgement, intentional buzzing, and failure to see and avoid the obstruction (inadequate visual lookout). Factors related to the accident were: the power line and the absence of shoulder harnesses in the aircraft.NTSB DEN90FA058Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Pueblo, COThe pilot's failure to maintain a proper glide path and sufficient altitude to clear obstacles.NTSB MIA90IA072Incident · No injuriesIncident investigationFinal reportPiper PA-30 · Tallahassee, FLProper glidepath not maintained.NTSB BFO90DIG01Accident · 1 fatalFinal reportRolladen-Schneider LS-6 · Cabins, WVThe pilot failed to detect and remain clear of the power line which crossed the field in which he was attempting to land. Contributing to the accident was the moderate to severe turbulence in the area at the time of the accident.NTSB FTW90LA070Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Arlington, TXPoor judgement of the pilot after consumption of alcoholic beverage, his decision to make low passes at night (buzzing), failure of the pilot to maintain proper altitude, and diversion of his attention. Darkness was a related factor.NTSB BFO90FA025Accident · 1 fatalField investigationFinal reportCessna 150F · Arden, NCThe pilot failure to maintain adequate altitude and clearance from a powerline during the landing approach. A factor was the unmarked powerline.NTSB LAX90FA088Accident · 1 fatalField investigationFinal reportBeech F-33A · Oro Valley, AZThe pilot's poor judgement in performing low level aerobatic maneuvers.NTSB FTW90LA067Accident · Serious injuriesLimited investigationFinal reportCessna 172C · Prue, OKFailure of the pilot to see-and-avoid the powerlines. The powerlines were a related factor.NTSB MKC90LA052Accident · No injuriesLimited investigationFinal reportCessna 150 · Clear Lake, MNFailure of the pilot to maintain proper alignment with the runway, his delay in initiating a go-around, and his premature raising of the flaps. Factors related to the accident were the adverse wind conditions and the tree.NTSB NYC90LA070Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Duanesburg, NYThe failure of the flight instructor to adequately monitor the actions of the student pilot and apply corrective action in a timely manner.NTSB LAX90FA062Accident · No injuriesField investigationFinal reportPiper PA-28 · Lincoln, CAInadequate visual lookout by the pilot of the Cessna, which resulted in his failure to see-and-avoid the Piper.NTSB ATL90FA061Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Norris, TNThe student pilot's misjudged descent which resulted in a collision with trees and the ground. A factor was that the pilot was buzzing when the accident occurred.NTSB DEN90LA048Accident · No injuriesLimited investigationFinal reportCameron N105 · Littleton, COInadequate compensation for the wind conditions by the pilot in command.NTSB NYC90FA063Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Fairfield, CTThe intoxicated pilot's failure to attain/maintain a safe altitude to provide clearance from the tree.NTSB CHI90LA073Accident · No injuriesLimited investigationFinal reportBell 222 · Middleville, MIThe pilot's inadequate visual lookout and failure to maintain proper altitude and clearance from the tv tower. The tv tower (guy wire) was a related factor.NTSB MKC90LA051Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Conway, ARThe pilot failed to attain the proper touchdown point and the delayed initiation of the go-around. Contributing to the accident was the fence struck during the aborted landing.NTSB LAX90LA108Accident · No injuriesLimited investigationFinal reportPiper PA-32-R-300 · Sacramento, CAAn inadvertent collision with a large bird during the hours of darkness while in the landing pattern.NTSB NYC90FA051Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Great Barrngton, MAFailure of the pilot to maintain proper altitude and clearance from trees while departing from the airport. Factors related to the accident were: the pilot's inadequate preflight planning/preparation, his allowing the aircraft weight and balance to be…NTSB CHI90FA066Accident · Serious injuriesField investigationFinal reportCessna 402A · Mosinee, WIThe pilot disregarding the published decision height and not performing a missed approach.NTSB MKC90LA047Accident · Serious injuriesLimited investigationFinal reportBurnett Starduster TOO · Lawrence, KSThe pilot misjudged clearance from tree(s) near the approach end of the runway, while on final approach to land. Factors related to the accident were: sunglare, lack of visual cues to the pilot, and tree(s).NTSB FTW90LA047Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Stephenville, TXImproper planning/decision by the pilot.NTSB ANC90FA021Accident · 1 fatalField investigationFinal reportPiper PA-31 · Beluga, AKFailure of the pilot to maintain proper altitude. Darkness and adverse weather conditions were related factors.NTSB ATL90FA038Accident · 3 fatalField investigationFinal reportCessna T210N · Spindale, NCThe pilot-in-command's improper IFR procedure which resulted in descent below the minimum descent altitude. Contributingfactor(s) was: the fog and low ceiling.