NTSB investigations, CA
86 cases where the first occurrence was “Miscellaneous/other”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 4 |
| 1984 | 3 |
| 1985 | 4 |
| 1986 | 6 |
| 1987 | 8 |
| 1988 | 3 |
| 1989 | 5 |
| 1990 | 3 |
| 1991 | 7 |
| 1992 | 2 |
| 1993 | 3 |
| 1995 | 1 |
| 1996 | 4 |
| 1997 | 4 |
| 1999 | 2 |
| 2000 | 5 |
| 2001 | 5 |
| 2002 | 1 |
| 2003 | 2 |
| 2004 | 4 |
| 2005 | 2 |
| 2006 | 2 |
| 2007 | 5 |
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\" = 430)
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" = 430) 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 LAX08CA014Accident · No injuriesData collectionFinal reportPiper PA-34-200T · Napa, CAThe pilot's failure to latch the cargo door during preflight.NTSB LAX07CA286Accident · No injuriesData collectionFinal reportCessna 182F · Bakersfield, CAThe pilot's inadequate preflight inspection and pretakeoff checks during which he failed to remove the gust lock.NTSB LAX07CA282Accident · Minor injuriesData collectionFinal reportPiper J5A · Turlock, CAThe pilot's failure to properly and adequately tie down the airplane during the engine start operation.NTSB LAX07CA172Accident · No injuriesData collectionFinal reportSchweizer SGS2-33A · Los Alamitos, CAfailure of the towrope during the initial climb out.NTSB LAX07LA189Accident · Serious injuriesLimited investigationFinal reportBoeing 757-24APF · Burbank, CAThe tow tractor driver's and mechanic's diverted attention resulting in the airplane rolling over the mechanic's foot. Also causal was the mechanic's failure to maintain clearance from the nose landing gear.NTSB SEA07LA050Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Fresno, CAThe design stress limits of the airframe were exceeded by an unknown pilot.NTSB LAX06TA284Accident · No injuriesFinal reportBell 212 · Happy Camp, CAFailure of compressor second stage stator vane for undetermined reasons while maneuvering.NTSB LAX05TA156Accident · No injuriesFinal reportSikorsky S-70A · Calabasas, CAfatigue of the forward keeper due to known flaws in the manufacturing process.NTSB LAX05CA071Accident · No injuriesData collectionFinal reportRobinson R22B · Rialto, CAthe student pilot's improper use of the cyclic control during a practice autorotation, and the inadequate supervision by the certified flight instructor.NTSB LAX04LA277Accident · No injuriesLimited investigationFinal reportCessna 172RG · San Diego, CAThe pilot's failure to ensure that the landing gear was fully extended, by use of the emergency gear extension system, which resulted in its partial collapse during landing rollout. Also causal was the pilot's failure to follow POH procedures relating to…NTSB LAX04LA225Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Susanville, CAthe pilot's failure to perform a proper preflight inspection of the airplane and ensure that the oil cap was secured, which resulted in a descent into terrain due to his obstructed view out of the windshield.NTSB LAX04TA264Accident · No injuriesFinal reportBell 212HP · Chester, CAthe pilot's excessive use of the cyclic and collective controls in response to the helicopter's unexpected rocking motion, which led to a main rotor contact with the upper wire cutter mounted on the cabin roof. A factor in the accident was the rough, sloping…NTSB LAX04LA197Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Van Nuys, CAthe failure of maintenance personnel to ensure the proper charge of the aft landing gear dampers in accordance with the manufacturer's recommendations.NTSB LAX03IA137Incident · No injuriesIncident investigationFinal reportAirbus Industrie A300F4-605R · Oakland, CAthe failure of the 1R evacuation slide to inflate because the transport-locking pin had not been removed from the regulator during the slide's installation on the 1R door. The cause of the cabin/cockpit smoke was contamination of the air conditioning packs.NTSB LAX03LA097Accident · 1 fatalLimited investigationFinal reportFirefly 11B · Yountville, CAA bystander was impaired by drugs and did not follow the pilot's directive to release the balloon as it began its ascent.NTSB LAX02LA293Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Weed, CAThe pilot's failure to follow adequate hand propping engine starting procedures.NTSB LAX02LA058Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Winters, CAThe failure of the pilot to retard the engine throttle to idle while hand-propping the engine, which resulted in the engine starting at full (takeoff) power and the airplane taking off with no one aboard.NTSB LAX01LA305Accident · No injuriesLimited investigationFinal reportHughes 369D · Carlsbad, CAA hard landing due to the dual student's failure to maintain main rotor speed, his improper landing flare, and the flight control interference by the flight instructor.NTSB LAX01LA240Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A320-232 · San Diego, CAthe flight crew's excessive descent rate, which resulted in an injury to a flight attendant.NTSB LAX01LA117Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Anza, CAThe pilot's failure to maintain control of the airplane following the opening of the cockpit/cabin door. The door came open because of improperly installed upholstery, which resulted in the inability to lock the door.NTSB LAX01TA092Accident · No injuriesFinal reportMcDonnell Douglas 600N · San Diego, CAThe student pilot's improper use of the rotorcraft flight controls, and the instructor pilot's inadequate supervision of the maneuver.NTSB LAX01FA059Accident · 1 fatalField investigationFinal reportDehavilland DHC-6 · Sacramento, CAThe passenger committed suicide.NTSB LAX00LA242Accident · 1 fatalLimited investigationFinal reportWorldwide Aero AEROS-40B · San Bernadino, CAThe ground crew's diverted attention toward the landing airship while trying to catch a mooring rope, which resulted in their failure to detect an immenient collision with each other.NTSB LAX00FA151Accident · 1 fatalField investigationFinal reportBeech B36TC · Fullerton, CAThe pilot's failure to maintain adequate airspeed while in the traffic pattern, which resulted in an inadvertent stall/spin. Contributing factor was the pilot's diverted attention with the loss of engine power from his inadvertent activation of the auxiliary…NTSB LAX00LA100Accident · No injuriesLimited investigationFinal reportBell 47G5 · Riverbank, CAthe pilot's failure to verify that ground personnel had disconnected the loading hose from the hopper before takeoff, resulting in restricted directional control and a hard landing.NTSB LAX00LA063Accident · No injuriesLimited investigationFinal reportCessna 172G · Victorville, CAThe failure of the pilot to maintain positional awareness, which resulted in his becoming lost and disoriented. Contributing factors were the pilot's delay requesting assistance from air traffic control and the failure of the airplane's electrical generator.NTSB LAX99LA264Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Industries Katana DA 20-A1 · San Carlos, CAThe release of the aircraft's left canopy latch following takeoff resulting in the subsequent opening of the canopy in flight. The opened canopy resulted in a degradation of aircraft control and the subsequent hard landing.NTSB LAX99LA181Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · La Verne, CAThe in-flight separation of the right engine cowling due to the operator's inadequate maintenance quality control procedures and the pilot's inadequate preflight inspection.NTSB LAX97IA243Incident · No injuriesIncident investigationFinal reportBoeing 737-522 · Ontario, CAa laser light source of undetermined origin directed toward the cockpit window of an aircraft in-flight by a person or persons unknown.NTSB LAX97LA230Accident · Minor injuriesLimited investigationFinal reportBeech 95-B55 · Beaumont, CAthe pilot's inadvertent movement of the propeller controls, instead of the throttle levers, which resulted in an inadvertent dual engine shutdown. Factors relating to the accident were: the pilot's failure to properly secure the door during preflight, and his…NTSB LAX97IA161Incident · Minor injuriesIncident investigationFinal reportBoeing 737-500 · Rialto, CAa laser light source of undetermined origin, directed by unknown person(s) toward the cockpit window of the aircraft, while the aircraft was on an approach to land.NTSB LAX97FA149Accident · No injuriesField investigationFinal reportAerospatiale AS350D · Los Angeles, CAthe pilot's failure to ensure that the collective lock was properly seated before deplaning.NTSB LAX97IA056Incident · Minor injuriesIncident investigationFinal reportEmbraer EMB-120ER · Los Angeles, CAa laser light source of unknown origin, directed toward the aircraft, as it was approaching to land.NTSB LAX97LA016Accident · No injuriesLimited investigationFinal reportWaco QCF · Big Bear City, CAthe pilot's improper response to a perceived in-flight emergency by abruptly retarding the throttle and failing to properly flare the airplane during the aborted takeoff. The pilot's improper perception of the source of smoke was a related factor.NTSB LAX96LA277Accident · No injuriesLimited investigationFinal reportRobinson R22B · Morgan Hill, CAThe student's improper reaction to an engine/main rotor overspeed condition, and his failure to achieve the proper zero airspeed nose high attitude during a touchdown from an autorotation.NTSB LAX96LA093Accident · 1 fatalLimited investigationFinal reportBell 47-G5 · Pope Valley, CAthe pilot misjudged the clearance between the broadcaster and the truck resulting in the broadcaster's cables becoming entangled with the truck.NTSB LAX95LA254Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Big Bear City, CAThe pilot's improper planning/decision and failure to obtain or maintain adequate airspeed during takeoff. A factor relating to the accident was: the high density altitude.NTSB LAX93LA289Accident · Serious injuriesLimited investigationFinal reportRaven S-60A · La Jolla, CAthe failure of the injured ground crewman to release his hold on the basket in a timely manner when instructed by the pilot.NTSB LAX93LA279Accident · Serious injuriesLimited investigationFinal reportRaven S-60A · Coloma, CAthe passenger's injury to an ankle during the landing touchdown.NTSB LAX93IA245Incident · No injuriesIncident investigationFinal reportBoeing 757-222 · Los Angeles, CAthe inadvertent deployment of an overwing emergency excape slide due to the inadequate latching of the slide compartment door following access by maintenance personnel. A factor in the accident was the inadequate door closing procedure specified by the…NTSB LAX92LA316Accident · No injuriesLimited investigationFinal reportCessna 177 · Turlock, CAThe pilots poor planning in not properly securing the aircraft with tiedowns, chocks or brakes prior to attempting to start the engine by hand propping.NTSB LAX92LA275Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Olancha, CA1) The tow pilot's intentional premature release of the glider, which had become airborne, when the tow plane failed to achieve sufficient airspeed during its takeoff ground roll, and, 2) the glider having insufficient altitude at the time of release to…NTSB LAX92LA055Accident · No injuriesLimited investigationFinal reportCessna 421B · San Andreas, CAThe pilot's inadequate preflight inspection and his failure to follow the airplane's checklist. A contributing factor was the dark night condition.NTSB LAX92FA043Accident · 3 fatalField investigationFinal reportCessna 172M · Carmel Valley, CAThe pilot's failure to maintain a safe altitude above the ground during an intentional low altitude flight in mountainous terrain. Contributing factors related to the pilot becoming distracted while flying over the ground and to his failure to initiate a…NTSB LAX91IA415Incident · Minor injuriesIncident investigationFinal reportAirbus Industrie A-320-231 · Santa Ana, CAThe failure of the flight attendant assigned to the aft galley jumpseat to secure a beverage cart in accordance with company policy.NTSB LAX91FA366Accident · Serious injuriesField investigationFinal reportPiper PA-32RT-300 · Van Nuys, CA(1) The pilot's improper preflight preparation; (2) the pilot's failure to follow the airplane manufacturer's performance data by his selection of an improper flap position for takeoff; and (3) the pilot's choice of a runway too short for a safe takeoff.…NTSB LAX91LA360Accident · No injuriesLimited investigationFinal reportCessna 182 · Long Beach, CAThe failure of the pilot to perform a proper preflight inspection of the aircraft.NTSB LAX91LA318Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Chico, CAThe pilot's improper starting procedure.NTSB LAX91LA274Accident · No injuriesLimited investigationFinal reportRyan ST3KR · Santa Maria, CAOil starvation due to the pilot's failure to properly configure the aircraft for the flight during the preflight inspection.NTSB LAX91LA024Accident · No injuriesLimited investigationFinal reportCessna 152 · Watsonville, CAThe failure of the pilots of both aircraft to see and avoid the other.