NTSB investigations, 2011
44 cases where the sequence of events included Unknown or undetermined.
Cases per year
| 2008 | 17 |
|---|---|
| 2009 | 31 |
| 2010 | 52 |
| 2011 | 44 |
| 2012 | 47 |
| 2013 | 43 |
| 2014 | 65 |
| 2015 | 82 |
| 2016 | 100 |
| 2017 | 83 |
| 2018 | 98 |
| 2019 | 83 |
| 2020 | 87 |
| 2021 | 95 |
| 2022 | 124 |
| 2023 | 152 |
| 2024 | 122 |
| 2025 | 120 |
| 2026 | 263 |
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 year(c.\"eventDate\") = 2011
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '000' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 year(c."eventDate") = 2011 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '000' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN12FA072Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Perryville, ARThe pilot's loss of control in flight.NTSB ERA12IA060Incident · No injuriesIncident investigationFinal reportCessna 550 · Key West, FLThe pilots’ failure to appropriately apply the landing gear wheel brakes after landing, to properly perform the hard brake pedal-no braking condition procedure following the reported brake failure and to apply the emergency brakes. The reason for the reported…NTSB ERA12FA057Accident · 1 fatalField investigationFinal reportEckenrode Carl J Vans RV-6 · Taylorsville, GAThe airplane's entry into an uncontrolled descent for reasons that could not be determined because postaccident examination of the airplane and the pilot’s medical history did not reveal any anomalies that would have precluded normal operation.NTSB CEN12LA047Accident · Serious injuriesLimited investigationFinal reportSaber Trike unk · Okmulgee, OKThe in-flight collision with electrical wires for undetermined reasons.NTSB ERA12FA051Accident · 1 fatalField investigationFinal reportCessna 150F · Moncks Corner, SCThe debilitating effects of ethylene glycol poisoning, which resulted in the pilot’s inability to maintain control of the airplane.NTSB CEN12FA001Accident · 1 fatalField investigationFinal reportRobinson Helicopter R66 · Philip, SDThe in-flight separation of the main rotor mast following a mast bumping event. The reason for the mast bumping event could not be determined due to postaccident damage.NTSB DCA11WA108Accident · 18 fatalForeign investigationAviocar CASA C212 · Aceh, IndonesiaThe National Transportation Safety Committee of Indonesia (KNKT) has notified the NTSB of an accident involving a Aviocar CASA C212 that occurred on September 29, 2011. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT investigation…NTSB WPR11WA476Accident · 2 fatalForeign investigationBell 412SP · Mataram, West Nusa, IndonesiaOn September 25, 2011, at 1341 local time (0541 UTC) a Bell Helicopter 412SP, Indonesia registry PK-OVC, crashed in a jungle under unknown circumstances 150 kilometers east of Selaparang Airport, Mataram, West Nusa Tenggara, Indonesia. The Helicopter was…NTSB DCA11WA099Incident · No injuriesForeign investigationAirbus A320 · Cusco, PeruOn September 19, 2011, at 1620 UTC, an Airbus A320-233, N493TA, experienced smoke in the cockpit. The airplane landed uneventfully at Alejandro Velasco Astete International Airport (SPZO), Peru, its original destination. None of the passengers or crewmembers…NTSB CEN11WA639Accident · 2 fatalForeign investigationPiper PA-31P · Ciudad Apodaca, MexicoNTSB ERA11WA509Accident · 2 fatalForeign investigationRobinson R44 · Rio de Janeriro, BrazilOn September 10, 2011, about 2330 universal coordinated time, a Robinson R44 II, Brazilian registration PR-CEC, was substantially damaged when it impacted wooded terrain during an aerial photography flight, near Rio de Janeiro, Brazil. The foreign…NTSB WPR11FA429Accident · 1 fatalField investigationFinal reportBrewster LONG-EZ · Kanab, UTThe pilot's loss of airplane control during cruise flight.NTSB CEN11WA603Accident · 1 fatalForeign investigationCessna TU206G · Sioux Lookout, CanadaNTSB CEN11CA662Accident · No injuriesData collectionFinal reportPiper PA-30 · Saguache, COThe pilot's failure to maintain airplane control during the aborted takeoff.NTSB CEN11WA695Accident · 6 fatalClass 5 · ForeignCessna 210K · (Atlantic Ocean)NTSB ERA11LA501Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Monmouth, MEOperation of the airplane by a non-certificated pilot and his failure to maintain airplane control.NTSB ANC11LA080Accident · 2 fatalLimited investigationFinal reportPiper PA-18-150 · Cape Yakataga, AKA collision into water during initial climb after takeoff for undetermined reasons.NTSB WPR11WA351Accident · 1 fatalForeign investigationRobinson R22 · Fitzroy Crossing, Australia, AustraliaOn July 27, 2011, at 0930 universal coordinated time, a Robinson R-22 Beta, VH-YOL, registered to and operated by a private owner, collided with terrain near Fitzoy Crossing, Australia. The helicopter was substantially damaged and the pilot, the sole…NTSB CEN11LA504Accident · No injuriesLimited investigationFinal reportQuasar Acft 214SL · Fort Worth, TXA fuel leak in the engine compartment, which resulted in an engine fire.NTSB WPR11LA307Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Columbia, CAThe airplane’s failure to climb at a sufficient rate to clear trees and terrain beyond the end of the runway for reasons that could not be determined because postaccident examination did not reveal any mechanical malfunctions or failures that would have…NTSB CEN11CA445Accident · Minor injuriesData collectionFinal reportSkytrails Lsa Predator · Coldspring, TXThe pilot's inadequate consideration of obstructions on his flight path and inability to maintain altitude following an unexplained loss of lift.NTSB CEN11LA449Accident · Minor injuriesLimited investigationFinal reportAbbey Victor RV9-A · Leander, TXThe partial loss of engine power for reasons that could not be determined because examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR11LA272Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Hogeland, MTCollision with the ground while maneuvering at low altitude for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN11LA385Accident · No injuriesLimited investigationFinal reportWiley C W RV-6A · Colgate, OKThe loss of engine power for undetermined reasons.NTSB WPR11FA256Accident · 3 fatalField investigationFinal reportBellanca 17-31ATC · Ukiah, ORThe non-instrument-rated pilot's decision to conduct a visual flight rules flight over mountainous terrain into a region covered by clouds, which likely resulted in spatial disorientation and subsequent loss of airplane control.NTSB CEN11WA382Accident · 1 fatalForeign investigationAir Tractor AT-502B · La Fora, Tiquisate, GuatemalaNTSB ERA11WA310Accident · 4 fatalForeign investigationPiper PA-34-200 · Sao Pedro, BrazilOn May 16, 2011, about 0130 universal coordinated time, a Piper PA-34-200, Brazilian registration PT-IFS, was destroyed when it impacted hilly terrain under unknown circumstances near Sao Pedro, Sao Paulo, Brazil. The Brazilian certificated pilot and three…NTSB ERA11WA305Accident · 3 fatalForeign investigationCessna 210M · Breu Branco, BrazilOn May 14, 2011, about 1430 universal coordinated time, a Cessna 210M, Brazilian registration PR-HSM, was substantially damaged when it impacted wooded terrain under unknown circumstances, in a remote, dense forest near Breu Branco, Brazil. The foreign…NTSB ERA11FA299Accident · 1 fatalField investigationFinal reportPiper PA-22-150 · Benezette, PAThe pilot's loss of airplane control for reasons that could not be determined from the available evidence.NTSB ERA11FA293Accident · Serious injuriesField investigationFinal reportBeech F33A · Tarentum, PAThe pilot's delay in aborting the takeoff, which resulted in a runway overrun. Contributing to the accident was the pilot's inadequate preflight planning and excessive loading of the airplane.NTSB ANC11WA028Accident · 1 fatalForeign investigationCessna 195A · Campbell River, CanadaNTSB CEN11LA308Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Streetman, TXThe airplane’s inability to establish a climb for undetermined reasons, which resulted in a collision with trees.NTSB CEN11FA285Accident · 1 fatalField investigationFinal reportHawker-Beechcraft E-55 · De Queen, ARThe pilot’s loss of control during takeoff for undetermined reasons.NTSB ERA11WA245Accident · 2 fatalForeign investigationBell 206B · Santo Andre City, BrazilOn April 8, 2011, at 2030 coordinated universal time (1730 local time), a Bell 206B, Brazilian registration PT-YMJ, was destroyed when it impacted terrain at the 5,000-foot level of the Serra do Mar mountain range in Santo André, São Paulo, Brazil. The pilot…NTSB ERA11WA251Accident · 3 fatalForeign investigationEurocopter AS-355-F2 · Alto Alegre, BrazilOn April 6, 2011, about 2225 coordinated universal time, a Eurocopter AS-355-F2, Brazilian registration PT-HNA, was destroyed when it impacted terrain near Alto Alegre, Brazil. The pilot and one passenger incurred minor injuries, and three passengers were…NTSB WPR11WA176Accident · 4 fatalForeign investigationPiper PA-32R · Moree, AustraliaThe accident is under the jurisdiction of and is being investigated by the Australian Transport Safety Bureau.NTSB ERA11FA214Accident · 1 fatalField investigationFinal reportAerostar S A YAK-52 · Palm Coast, FLThe pilot’s failure to recover from the nose-low descent during an aerobatic maneuver.NTSB CEN11FA244Accident · 2 fatalField investigationFinal reportCessna 182M · Hot Springs, ARA total loss of engine power for undetermined reasons.NTSB WPR11FA173Accident · 3 fatalField investigationFinal reportCessna P210 · Daggett, CAThe pilot's decision to conduct the flight into a region of reported moderate to severe turbulence and icing conditions, followed by a loss of airplane control and an aerodynamic spin from which the pilot did not recover.NTSB ERA11WA189Accident · 1 fatalForeign investigationCessna 182 · Calamar, ColombiaOn March 14, 2011, about 0815 universal coordinated time, a Cessna, 182N, Colombian registration, HK1084, operated by Transportes Aereos del Ariari, crashed while returning to Aerodromo Jorge E. Gonzalez- San Jose Guaviare (SKSJ), Calamar, Colombia, shortly…NTSB DCA11WA024Accident · 7 fatalForeign investigationRaytheon Hawker · Sulaimanyia, IraqOn February 4, 2011 about 1449 UTC, OD-SKY, a Hawker Beechcraft HS-850XP, registered to Club Aviation S.A.L and operated by Sky Lounge services S.A.L., crashed during the initial takeoff climb at Suliamaniyah International Airport, Iraq. The 3 crew members…NTSB ERA11WA143Accident · 3 fatalForeign investigationBeech 58 · Patrimonio Regina City, BrazilOn January 28, 2011, at 2047 coordinated universal time (1847 local time), a Beech 58, Brazilian registration PT-BOR, was substantially damaged when it impacted terrain near Patrimônio Regina City, Paraná, Brazil. The two pilots and the passenger were fatally…NTSB CEN11WA151Accident · 1 fatalForeign investigationCirrus Design SR20 · Santiago Atitlán, GuatemalaNTSB DCA11WA069Accident · No injuriesForeign investigationBoeing 727 · Urmia, IranOn January 9, 2011, an Iran Air Boeing B727-200, registration EP-IRP, crashed during missed approach to Orumiyeh Airport (OITR), Urmia, Iran. Of the 105 passengers and crew onboard, 78 were fataly injured and 27 received serious injuries. The airplane was…