NTSB investigations, CA
469 cases where the first occurrence was “In flight collision with object”.
Cases per year
| 1982 | 33 |
|---|---|
| 1983 | 35 |
| 1984 | 28 |
| 1985 | 17 |
| 1986 | 22 |
| 1987 | 19 |
| 1988 | 28 |
| 1989 | 19 |
| 1990 | 18 |
| 1991 | 15 |
| 1992 | 26 |
| 1993 | 29 |
| 1994 | 20 |
| 1995 | 18 |
| 1996 | 10 |
| 1997 | 9 |
| 1998 | 14 |
| 1999 | 9 |
| 2000 | 18 |
| 2001 | 13 |
| 2002 | 11 |
| 2003 | 10 |
| 2004 | 12 |
| 2005 | 10 |
| 2006 | 12 |
| 2007 | 14 |
Where
Open the mapLatest cases
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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
AND 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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA' AND 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 LAX08CA020Accident · Serious injuriesData collectionFinal reportPiper PA-28-140 · Fresno, CAThe pilot's failure to maintain the proper glide path to clear objects during approach for landing.NTSB LAX08CA003Accident · No injuriesData collectionFinal reportLet Blanik L-13 · Hemet, CAThe pilot's failure to maintain a proper descent rate due to his failure to close the air brake and/or partially retract the flaps during an encounter with lost lift on final approach.NTSB LAX07FA241Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · S. Lake Tahoe, CAThe pilot's inadequate preflight planning/decision, and his failure to maintain clearance from trees during takeoff-initial climb. Contributing to the accident were turbulence, downdrafts, and rising terrain.NTSB LAX07TA227Accident · 1 fatalFinal reportBell 205 A1++ · Happy Camp, CAthe pilot's failure to maintain clearance with the trees during a long-line operation. Contributing factors were the Forest Service's inadequate communication between crews, failure to properly assess the safety of the intended drop zone, reduced visibility…NTSB LAX07CA224Accident · Minor injuriesData collectionFinal reportCessna 150M · Woodland, CAAn in-flight collision with a bird. A factor in the accident was the deteriorated aircraft performance capability due to the increased drag that made continued flight impossible.NTSB SEA07TA181Accident · No injuriesFinal reportMcDonnell Douglas DC 10-10 · Tehachapi, CAThe captain's failure to maintain clearance from trees.NTSB SEA07CA143Accident · No injuriesData collectionFinal reportCalstar 1 Eurocopter BO-105S · Concord, CAThe pilot's failure to maintain clearance from an object during hover. Trees were a factor.NTSB LAX07LA168Accident · 1 fatalLimited investigationFinal reportSchweizer G-164B · Colusa, CAThe pilot's failure to maintain clearance from wires.NTSB LAX07LA143Accident · Serious injuriesLimited investigationFinal reportBeech B36TC · West Athens, CAthe pilot's descent below the published minimum descent altitude for the instrument approach procedure, which resulted in a collision with wires and terrain. Contributing to the accident were the pilot's lack of recent experience in the accident airplane and…NTSB SEA07CA103Accident · Minor injuriesData collectionFinal reportCessna 152 · Oak Glen, CAThe flight instructors failure to maintain clearance from trees while maneuvering. Contributing factors were the downdraft weather condition, and the tree.NTSB LAX07LA126Accident · 1 fatalLimited investigationFinal reportArbc 150A · Mecca, CAThe pilot's decision to fly in forecasted unfavorable wind conditions that exceeded the balloon's capabilities.NTSB LAX07LA122Accident · 1 fatalLimited investigationFinal reportScottish Bulldog 120 · So Lake Tahoe, CAThe pilot's failure to maintain clearance from objects and the mountainous terrain.NTSB LAX07CA094Accident · No injuriesData collectionFinal reportGeneral Balloon AX-6 · San Martin, CAThe pilot's failure to maintain adequate altitude/clearance from power lines.NTSB LAX07CA072Accident · Minor injuriesData collectionFinal reportBell Helicopter 206BIII · Springville, CAThe pilot's failure to maintain terrain/obstacle clearance while maneuvering. Factors were the mountainous terrain, trees, and low-altitude flight maneuvers.NTSB LAX07CA053Accident · No injuriesData collectionFinal reportNorth American AT-6C · Mojave, CAthe pilot's failure to maintain adequate clearance from a sign while performing a low altitude maneuver.NTSB LAX07TA001Accident · Minor injuriesFinal reportErickson S64E · Ojai, CAThe pilot-in-command's improper remedial action, which resulted in a loss of helicopter control. Contributing factors were the retardant tank and snorkel designs.NTSB LAX06LA288Accident · 2 fatalLimited investigationFinal reportHughes 369D · Somis, CAThe pilot's inadequate visual lookout, which resulted in a collision with wires.NTSB LAX06CA285Accident · Serious injuriesData collectionFinal reportBeech 99 · Lodi, CAthe failure of the skydiver to correctly follow procedures and directives on exiting the airplane properly, which resulted in his collision with the horizontal stabilizer.NTSB LAX06FA233Accident · 1 fatalField investigationFinal reportBellanca 14-19 · Arcata, CAThe pilot's failure to follow the prescribed instrument approach procedure and to maintain the proper glide slope and altitude/clearance from obstacles while on an instrument landing system approach, resulting in a collision with trees. Contributing to the…NTSB LAX06LA235Accident · Minor injuriesLimited investigationFinal reportAlfred Long-EZ · Hesperia, CAThe pilot's failure to maintain the proper glide path on final approach as a result of the visual illusions created by a narrow, upsloping runway.NTSB LAX06LA147Accident · No injuriesLimited investigationFinal reportChristen Industries A-1 · Creston, CAThe pilot's failure to maintain an adequate clearance from obstacles while intentionally flying at a low altitude.NTSB LAX06CA140Accident · No injuriesData collectionFinal reportPiper PA-31-310 · Victorville, CAan in-flight collision with a bird.NTSB LAX06CA125Accident · Minor injuriesData collectionFinal reportCessna 172N · Compton, CAcontrol interference by the student pilot during a go-around that resulted in an in-flight collision with power lines.NTSB LAX06LA123Accident · 1 fatalLimited investigationFinal reportSchweizer 269C-1 · Valencia, CAThe certified flight instructor's failure to maintain an adequate clearance from objects.NTSB SEA06MA047Accident · 4 fatalMajor investigationFinal reportCessna 560 · Carlsbad, CAThe captain's delayed decision to execute a balked landing (go-around) during the landing roll. Factors contributing to the accident include the captain's improper decision to land with a tailwind, his excessive airspeed on final approach, and his failure to…NTSB LAX06CA084Accident · No injuriesData collectionFinal reportCessna T206H · Palo Alto, CAthe pilot's failure to maintain proper runway alignment, which resulted in a collision with multiple objects.NTSB LAX06LA058Accident · 1 fatalLimited investigationFinal reportCessna 177RG · Dixon, CAthe pilot's intentional flight at low altitude and failure to maintain obstacle clearance with a high tension static line. The glare from the setting sun was a factor.NTSB LAX06FA049Accident · 1 fatalField investigationFinal reportNavion G · Imperial, CAThe pilot's failure to maintain clearance from a tree and transmission wires while performing a low altitude maneuver. Also causal was the pilot's impaired judgment and performance due to alcohol ingestion.NTSB LAX06CA046Accident · No injuriesData collectionFinal reportCameron Balloons N-180 · Rancho Santa Fe, CAthe pilot's inadvertent deactivation of the number 2 burner, which resulted in an increased rate of descent and a collision with a tree short of the intended landing zone.NTSB LAX06LA015Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Avalon, CAthe pilot's failure to maintain an adequate visual lookout and obstacle clearance altitude, which resulted in a collision with power lines. Factors in the accident were the position of the sun relative to the helicopter's flight path, which lessoned the…NTSB LAX06CA002Accident · Serious injuriesData collectionFinal reportBell 206B · Pixley, CAthe pilot's failure to maintain clearance with the wire during a low altitude aerial application flight.NTSB LAX05TA306Accident · No injuriesFinal reportBell 407 · Inyokern, CAThe pilot failed to maintain tail rotor clearance from obstacles during landing.NTSB LAX05LA308Accident · Serious injuriesLimited investigationFinal reportEurocopter AS350B3 · Running Springs, CAThe pilot's failure to maintain an adequate clearance from trees while performing long line external lift operations.NTSB LAX05LA272Accident · 1 fatalLimited investigationFinal reportPatch Dan F Varieze · San Diego, CAa divergence from the final approach course and an in-flight collision with storage containers for undetermined reasons.NTSB LAX05LA187Accident · Serious injuriesLimited investigationFinal reportBell 47G-4A · Bakersfield, CAthe pilot's inadequate visual lookout and failure to maintain clearance from the power lines.NTSB LAX05LA064Accident · 1 fatalLimited investigationFinal reportJimmy Hill Lancair 235 · El Cajon, CAthe pilot's failure to maintain the proper glidepath to avoid obstacles and terrain.NTSB LAX05CA055Accident · No injuriesData collectionFinal reportTop Dog Trike · Torrey Pines, CAthe pilot's inadequate visual lookout, which resulted in the in-flight collision with a power line and a subsequent forced landing. Low altitude flight was a contributing factor.NTSB LAX05FA054Accident · 2 fatalField investigationFinal reportCessna 182P · La Mirada, CAthe pilot's inadequate visual lookout and failure to maintain altitude/clearance from a transmission tower while on an extended base leg of the traffic pattern. A factor in the accident was the sun glare condition.NTSB LAX05CA003Accident · No injuriesData collectionFinal reportCessna 152 · San Jose, CAan in-flight collision with a bird.NTSB LAX04CA323Accident · No injuriesData collectionFinal reportAero Commander S2R · Firebaugh, CAthe failure of the pilot to maintain clearance from high tension wires in dark night conditions. The reason for the loss of engine power after the wire collision was not determined.NTSB LAX04CA309Accident · Minor injuriesData collectionFinal reportCessna 172S · Willits, CAthe pilot's inadvertent descent and controlled flight into obstacles while maneuvering to land. Contributing factors were the dark, nighttime condition, which impaired the pilot's visual perceptions, and the pilot's failure to obtain a pertinent Notice to…NTSB LAX04CA306Accident · No injuriesData collectionFinal reportQuicksilver MXL II · Rio Vista, CAthe pilot's failure to maintain adequate clearance from high vegetation while flying at a low altitude.NTSB LAX04CA278Accident · No injuriesData collectionFinal reportCessna A185F · Gridley, CAThe pilot's improper use of the rudder to correct for torque and P-factor effects and failure to maintain obstacle clearance.NTSB LAX04CA270Accident · No injuriesData collectionFinal reportPdps Pzl-Bielsko SZD-50-3 · Lone Pine, CAthe pilot failed to maintain runway alignment, and misjudged the clearance between the tree and the wing resulting in a collision with the tree.NTSB LAX04CA242Accident · No injuriesData collectionFinal reportVans RV-9A · The Sea Ranch, CAthe pilot's inadequate compensation for gusty crosswind conditions and failure to maintain proper runway alignment, resulting in a collision with trees.NTSB LAX04LA239Accident · 1 fatalLimited investigationFinal reportChampion 7AC · La Porte, CAthe student pilot's failure to maintain clearance with trees while flying along a mountainous ravine.NTSB LAX04TA218Accident · No injuriesFinal reportEurocopter France AS350 B3 · Livermore, CAThe pilot's failure to maintain clearance from obstructions while landing.NTSB LAX04CA155Accident · No injuriesData collectionFinal reportJerry Garrison Christen Eagle II · Hollister, CAthe pilot's failure to obtain proper runway alignment and maintain clearance from a sign due to his inadequate visual lookout. Factors in the accident were crosswind conditions.NTSB LAX04LA055Accident · Minor injuriesLimited investigationFinal reportGoodyear GZ-20A · Gardena, CAThe pilot's delayed go-around during final approach to land, which resulted in an in-flight collision with a fence. A factor associated with the accident is the pilot's failure to maintain adequate altitude/clearance from obstructions.NTSB LAX04LA025Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Pacoima, CAthe pilot's failure to maintain an adequate glide path on final approach and his failure to ensure adequate clearance from obstacles. The dark night was a factor.