NTSB investigations, 2010, Outside the U.S.
8 cases where the sequence of events included Off-field or emergency landing.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 2 |
| 2010 | 8 |
| 2011 | 8 |
| 2012 | 5 |
| 2013 | 4 |
| 2014 | 5 |
| 2017 | 1 |
| 2021 | 6 |
| 2022 | 4 |
| 2023 | 8 |
| 2024 | 2 |
| 2025 | 6 |
| 2026 | 3 |
Latest 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\") = 2010
AND c.\"eventCountry\" <> 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '440' 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") = 2010 AND c."eventCountry" <> 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '440' 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 ERA11WA060Accident · No injuriesForeign investigationCirrus Design SR22 · Luzzara, ItalyOn November 12, 2010, at 1000 universal coordinated time, a Cirrus Design Corp SR22, N918SR, experienced a total loss of engine power while in cruise flight, and was substantially damaged during a forced landing to field in Luzzara, Italy. The pilot was not…NTSB ERA10WA498Accident · Minor injuriesForeign investigationAero Commander 500 · Santo Domingo, Dominican RepublicNTSB ERA10WA371Accident · 1 fatalForeign investigationRobinson R44 · Novo Horizonte, BrazilOn July 16, 2010, about 1645 Universal Coordinated Time (UTC), a Robinson R-44 helicopter, Brazilian registration PR-TNB, operated by Pereira Alvim Participacoes e Empreendimentos Ltda, was destroyed by fire after landing in a cane field at Novo Horizonte,…NTSB ERA10WA338Accident · 2 fatalForeign investigationBolkow BO105 · Buenos Aires, ArgentinaOn June 18, 2010, about 1118 universal Coordinated Time (UTC),an Bolkow BO-105, Argentina registration LV-WJX, operated by a private owner on a business flight, to photograph a automobile accident, collided with tall trees, overhead power lines, and struck…NTSB CEN10WA331Accident · No injuriesForeign investigationCirrus Design SR20 · Sirdal, NorwayOn May 28, 2010, at 1708 coordinated universal time (UTC), a Cirrus Design Corporation model SR20 airplane, s/n 1888, Norwegian registration LN-BCD, was substantially damaged when it impacted mountainous terrain near Sirdal, Norway. The flight had encountered…NTSB WPR10RA197Accident · Serious injuriesForeign investigationEagle 150B · Kota Bahru, MalaysiaOn March 9, 2010, about 1630 local time, an Eagle 150B, Malaysia registration 9M-BEV, crashed near Kota Bahru, Kelantan, Malaysia, subsequent to an in-flight propeller separation. The two occupants, a flight instructor and student pilot, sustained serious…NTSB ERA11WA269Incident · No injuriesForeign investigationEmbraer EMB-202 · Guarau, BrazilOn January 28, 2010, about 1030 coordinated universal time, an Embraer EMB-202, Brazilian registration PT-UPW, had a reported loss of power during cruise and landed in a soybean field near Guarau, Santa Catarina, Brazil. The pilot was not injured And the…NTSB ERA10WA340Accident · Minor injuriesForeign investigationRobinson R44 · San Felipe, ChileOn January 21, 2010, at 2210 universal coordinated time, a Robinson R44 helicopter, Chilean registration CC-PSZ, experienced a loss of engine power while in cruise flight, and was substantially damaged during a subsequent forced landing, in San Felipe, Chile.…